Hello sir! For which user should I create an ACL to use that utl_http from Oracle Apex SQL Commands? And for example, I created an ACL for twilio api host but oracle sql developer still gives me ACL error Can you please help?
My "Thumb UP" for you ... Much better now.... but anyway there was some changes in 19c ... and those changes are not enought to connect... I have provide the ACLs properly, created the wallet, installed the certificate , call the WS adding the wallet but anyway im getting "ORA-53203: Security Violation " ... and this is something new for me... any clue? comments ? We are on apex 23.2
Thanks and you have not provided enough details what you did and how you did as per error seems related privs not granted to the host or port issues, select a.lower_port, a.upper_port from dba_network_acls a where a.host like '%' if you can't share details here then email to info@erpstuff.com thanks
very usefull. you used wallet in UTL_HTTP example, please also make video on how to configure wallet. also you did not provide wallet with apex_web_service example, why ? is it not needed ?
So helpful... Thanks
Glad it was helpful!
Hello sir! For which user should I create an ACL to use that utl_http from Oracle Apex SQL Commands?
And for example, I created an ACL for twilio api host but oracle sql developer still gives me ACL error
Can you please help?
all explained in the video which users to given access. thanks
Its parity much clear now....
Happy to hear it was of any use. Thanks
Sir please help about configure UTL_HTTP for oracle apex with wallet in detail please make same vdo on it
Why do you want this to use instead of apex functionality?
My "Thumb UP" for you ... Much better now.... but anyway there was some changes in 19c ... and those changes are not enought to connect... I have provide the ACLs properly, created the wallet, installed the certificate , call the WS adding the wallet but anyway im getting "ORA-53203: Security Violation " ... and this is something new for me... any clue? comments ? We are on apex 23.2
Thanks and you have not provided enough details what you did and how you did as per error seems related privs not granted to the host or port issues,
select a.lower_port, a.upper_port from dba_network_acls a where a.host like '%'
if you can't share details here then email to info@erpstuff.com
thanks
I do all the Same and still get the error , any ideas?
Without knowing error can't say anything.
very usefull.
you used wallet in UTL_HTTP example, please also make video on how to configure wallet.
also you did not provide wallet with apex_web_service example, why ? is it not needed ?
Sure wallet need to be covered while for APEX you can assign wallet in APEX instance settings hence here not required.
who are you sir ? and where were you ? You have lot of patience ... wish I would have worked with you for atleast 1 year :)
Thanks