OraFAQ Forum: SQL & PL/SQL » "SYS.UTL

Home » SQL & PL/SQL » SQL & PL/SQL » "SYS.UTL_HTTP", line 1130 (RedHat oracle ODA)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"SYS.UTL_HTTP", line 1130 [message #594408]

Wed, 28 August 2013 04:43

deepak416
Messages: 63
Registered: January 2013
Location: Pune

Member

Hi,

i am getting ERROR : ORA-06512: at "SYS.UTL_HTTP", line 1130 while i have already provide utl_http permission to db user.

Report message to a moderator

Re: "SYS.UTL_HTTP", line 1130 [message #594411 is a reply to message #594408]

Wed, 28 August 2013 04:48

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

We can clearly see from what you have posted that you have an extra parameter in that call that shouldn't be there. Remove the blob column from the call, that'll do it for ya. (Unless, of course, my second sight isn't working quite as well as it should, in which case, you might want to post some useful info)

Report message to a moderator

Re: "SYS.UTL_HTTP", line 1130 [message #594412 is a reply to message #594408]

Wed, 28 August 2013 04:49

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This in a standard common error and is helpless.
You have to post ALL the stuff not just a bit.

So, Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: "SYS.UTL_HTTP", line 1130 [message #594413 is a reply to message #594408]

Wed, 28 August 2013 04:51

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps you should post some more information (such as complete code you wrote, Oracle database version and whatever else you find interesting); furthermore, I suspect that ORA-06512 is not the only error listed in error stack. Could you post the whole SQL*Plus session?

Lucky guess & possible hint: did you correctly set ACL (Access Control List)?

Report message to a moderator

Re: "SYS.UTL_HTTP", line 1130 [message #594414 is a reply to message #594413]

Wed, 28 August 2013 04:55

deepak416
Messages: 63
Registered: January 2013
Location: Pune

Member

here is the complete detail from the log file

28-AUG-13 08.07.22.730408 PM : getADSLPort : DEBUG : Public IP :172.20.30.15
28-AUG-13 08.07.22.730647 PM : getADSLPort : DEBUG : WSDL URL : http://10.66.12.210:7777
28-AUG-13 08.07.22.730888 PM : getADSLPort : DEBUG : soap request : <?xml version = "1.0" encoding = "UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" >
<SOAP-ENV:Body>
<getSubscriptionNoByIpAddress xmlns="http://iplocationavea/">
<ipAddress xmlns="">172.20.30.15</ipAddress>
</getSubscriptionNoByIpAddress>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
28-AUG-13 08.07.22.733136 PM : InsertTraps : DEBUG : Starting of InsertTraps procedure
28-AUG-13 08.07.22.733529 PM : InsertTraps : DEBUG : End of InsertTraps procedure
28-AUG-13 08.07.22.733864 PM : isValidADSLPort : ERROR : ORA-06512: at "SYS.UTL_HTTP", line 1130

Report message to a moderator

Re: "SYS.UTL_HTTP", line 1130 [message #594416 is a reply to message #594414]

Wed, 28 August 2013 04:58

deepak416
Messages: 63
Registered: January 2013
Location: Pune

Member

or you can also find error from cli
SQL> select getADSLPort('172.20.30.15','http://10.66.12.210:7777',40) from dual;
select getADSLPort('172.20.30.15','http://10.66.12.210:7777',40) from dual
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-24248: XML DB extensible security not installed
ORA-06512: at "SACBLMDBUSER.GETADSLPORT", line 36

Report message to a moderator

Re: "SYS.UTL_HTTP", line 1130 [message #594418 is a reply to message #594416]

Wed, 28 August 2013 04:59

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle

ORA-24248: XML DB extensible security not installed

Cause: XML DB extensible security necessary for this operation has not been installed.

Action: Ensure that XML DB has been installed.

Report message to a moderator

Re: "SYS.UTL_HTTP", line 1130 [message #594424 is a reply to message #594418]

Wed, 28 August 2013 05:12

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

... and FORMAT your posts.

Regards
Michel

Report message to a moderator

Previous Topic:	V$DB_OBJECT_CACHE view
Next Topic:	PLS-00597

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 08 13:24:00 CDT 2025