Getting errors on OCI ATP Oracle 23ai -
select COALESCE(
OWA_UTIL.get_cgi_env('HTTP_X_FORWARDED_FOR'),
OWA_UTIL.get_cgi_env('HTTP_X_REAL_IP'),
OWA_UTIL.get_cgi_env('HTTP_CF_CONNECTING_IP'), -- Cloudflare
OWA_UTIL.get_cgi_env('REMOTE_ADDR'))
from dual;
ORA-06502: PL/SQL: value or conversion error ORA-06512: at "SYS.OWA_UTIL", line 354 https://docs.oracle.com/error-help/db/ora-06502/ 06502. 00000 - "PL/SQL: value or conversion error%s" *Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if you attempt to assign the value NULL to a variable declared NOT NULL, or if you attempt to assign an integer greater than 99 to a variable declared NUMBER(2). *Action: To resolve the issue, change the data, the way the data is manipulated, or the data variable declaration. *Params: 1) error_info occurred. Error at Line: 2 Column: 4, Error at Line: 1 Column: 6
Individual params are bombing too with the same error -
SELECT OWA_UTIL.get_cgi_env('REMOTE_ADDR') FROM DUAL;
- APEX_PUBLIC_USER does not exist on OCI but I see APEX_PUBLIC_ROUTER and ORDS_PUBLIC_USER.
Is WKSP_XXX user or APEX_PUBLIC_ROUTER user in lieu of APEX_PUBLIC_USER on OCI?
TIA