Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Probelm with plsql handlers after upgrade ORDS from 20.4 - 24.4

Jozef Demovic SVK37 hours ago — edited 36 hours ago

Hi experts,

I'm facing strange error after I migrated ORDS (oracle APEX 24.2).

In ORDS 20.4 I have simple plsql proces which returns json as expected.

In ORDS 24.4 I got this error:

When I tried to debug The Error i found that there is something with CGI env variables:

Did you ever see this error ?
I tried every simple plsql block :) but everything the same …

Migrated handlers works just fine. Just newly created have this issue.

If I create query handler It works fine.

PS: If i add owa.init_cgi_env at the beginning of the plsql block. It works. But I think that It shoul be initialized automatically ?

Regards.
J

Comments
Post Details
Added 37 hours ago
2 comments
30 views