79713660

Date: 2025-07-24 16:13:30
Score: 0.5
Natty:
Report link

Finally...

When I executed from sqlplus i've done it by
sqlplus username/password@sid @script.sql <- works

In PLSQL Developer i run CODE from script.sql <- not working.

Turned out that the problem is in coding.


utl_http.set_header(l_http_request, 'Content-Type', 'application/json; charset=utf-8');

when I changed it to


    utl_http.set_header(l_http_request, 'Content-Type', 'application/json; charset=WINDOWS-1250');

It works. I do not know why - could SQLPlus changing by default file coding? Most important thing that this is working.
Closed.
God is great!

Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: q4za4