PL/SQL (MOSC)

MOSC Banner

Getting ORA-06512: at "SYS.HTTPURITYPE", line 34 Error, while Using HTTPUriType

edited Mar 7, 2014 2:52AM in PL/SQL (MOSC) 6 commentsAnswered

Dear Experts

I am getting Below Errors, when trying to retrieve the data from http url using Sql Query.

ORA-29273: HTTP request failed

ORA-06512: at "SYS.UTL_HTTP", line 1674

ORA-12535: TNS:operation timed out

ORA-06512: at "SYS.HTTPURITYPE", line 34

Below is the Sample Script which i am using to extract the data from Http Url.

1. create table uri_tab ( url httpuritype);

2. insert into uri_tab values (httpuritype.createUri('http://www.test.com'));

3. select e.url.getclob() from uri_tab e;

Regards,

vnjain

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