Skip to Main Content
  • Questions

  • utl_http work with 11g and not with 12c

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Arkadiusz.

Asked: August 29, 2018 - 6:01 pm UTC

Last updated: August 30, 2018 - 2:57 pm UTC

Version: 12.2.0.1.0

Viewed 1000+ times

You Asked

Hi Team
Is there any reason why unsecured connection with basic authentication ( http://user:password@server_address ) is working with 11g and not with 12c (12.2.0.1.0)? I am using utl_http package to connect from database servers to the same external server with webservice and I am receiving error 401-Unauthorized for 12c database. ACL has been configured. Is there any relation that operation system is Windows 2008R2 for 11g and Windows 2012 for 12c?
Thank you
Arkadiusz

and Chris said...

I'm not aware of any changes which would affect this. If you're getting 401s, you've contacted the remote server. But it's rejecting your credentials.

Which could mean:

- You've entered the wrong credentials
- They've changed your password or locked your account
- There's some form of ACL on the remote server preventing access from your new server

Verify the credentials you have work in a browser or other client on the new database server.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library