Database Administration (MOSC)

MOSC Banner

PLSQL get detail error message

edited Jan 7, 2023 5:29PM in Database Administration (MOSC) 8 commentsAnswered

Hi All, I am not s plsql person but trying to troubleshoot below issue

As we are trying to follow below URL to see if I could reach an particular external URL, I have set the ACL, and I am getting errors. Can any one help me to figure out what is going on

DB version - 11.2.0.4.0

OS version - Oracle Linux Server release 7.9

URL following - https://oracle-base.com/articles/misc/utl_http-and-ssl

Firewall - outgoing everything is allowed

SET SERVEROUTPUT ON
EXEC UTL_HTTP.set_wallet('file:/u01/app/oracle/product/11.2.0/dbhome_5/owm/wallets/wallet01', 'xxxxxx');
EXEC show_html_from_url('https://yyyyy.oraclecloud.com/crmRestApi/resources/latest/ValuationNew_c');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center