Thank you in advance for your help!
I've written a stored procedure that makes REST calls to Oracle's machine translation service. First, I authenticate my web credentials using the OAUTH_AUTHENTICATE_CREDENTIAL procedure--which has been working fine for me. However, I'm now getting a “no data found” error at this part of my procedure--which is the first line.
I've run this OAUTH procedure via the APEX command line, rather than in my stored procedure, to double check and it works fine! However, within my procedure, I get the “no data found” error. Below is the backtrace. Has anyone experienced this issue before?
Backtrace:
SQLERRM:- ORA-01403: no data found
ORA-06512: at "APEX_230100.WWV_FLOW_CREDENTIAL", line 116
ORA-06512: at "APEX_230100.WWV_FLOW_CREDENTIAL", line 107
ORA-06512: at "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 691
ORA-06512: at "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 718
ORA-06512: at "WKSP_LLTRANSLATIONS.TRANSLATIONS_PKG", line 58
ORA-06512: at "WKSP_LLTRANSLATIONS.TRANSLATIONS_PKG", line 14