Home » SQL & PL/SQL » SQL & PL/SQL » utl_request ORA-29049 error when request salesforce.com
utl_request ORA-29049 error when request salesforce.com [message #629965] Thu, 18 December 2014 03:21 Go to next message
junkai.niu
Messages: 1
Registered: December 2014
Location: 中国
Junior Member

SQL> select utl_http.request('https://login.salesforce.com/', NULL,'file:/tmp/','ASDF') from dual;
select utl_http.request('https://login.salesforce.com/', NULL,'file:/tmp/','ASDF') from dual
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-29049: unknown record
ORA-06512: at line 1

I have created wallet like this:
orapki wallet create -wallet /tmp -pwd password123 -auto_login
orapki wallet add -wallet /tmp -trusted_cert -cert XXX.cer -pwd ASDF

Searched some results:
OERR: ORA-29049 Unknown record (Doc ID 288469.1)

{ This note contains error information about an "Oracle Server"
error number. It may contain additional support notes as
described in Note:22080.1 }
Error: ORA-29049 (ORA-29049)
Text: Unknown record
---------------------------------------------------------------------------
Cause: The record type is unknown.
Action: Enable Oracle Net tracing and attempt the connection again.
Contact Oracle customer support with the trace output.

So I started tracing and got the following logs:
///////////////////////////////////////////////////////////////
Error found. Error Stack follows:
id:0
Operation code:70
NS Error 1:12582
NS Error 2:0
NT Generic Error:0
Protocol Error:0
OS Error:0
NS & NT Errors Translation
12582, 00000 "TNS:invalid operation"
// *Cause: An internal function received an invalid request.
// *Action: Not normally visible to the user. For further details, turn
// on tracing and reexecute the operation. If error persists, contact
// Oracle Customer Support.
/
00000, 00000 "Not An Error"
// *Cause: Everything is working as it should.
// *Action: Dont worry: Be happy.
/
00000, 00000 "Not An Error"
// *Cause: Everything is working as it should.
// *Action: Dont worry: Be happy.
///////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////
Error found. Error Stack follows:
id:0
Operation code:70
NS Error 1:12630
NS Error 2:0
NT Generic Error:0
Protocol Error:0
OS Error:0
NS & NT Errors Translation
12630, 00000 "Native service operation not supported"
// *Cause: An operation requested by a user is not supported by the native
// services component.
// *Action: This may be an internal error if the operation should have been
// supported.
/
00000, 00000 "Not An Error"
// *Cause: Everything is working as it should.
// *Action: Dont worry: Be happy.
/
00000, 00000 "Not An Error"
// *Cause: Everything is working as it should.
// *Action: Dont worry: Be happy.
/
///////////////////////////////////////////////////////////////

end....

Any idea?

Thanks,
Junkai
Re: utl_request ORA-29049 error when request salesforce.com [message #630012 is a reply to message #629965] Thu, 18 December 2014 09:55 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Any idea?
My guess, and this is strictly a guess, is that the errors result from trying to make HTTPS connection using HTTP.
They operate against different ports & I doubt you can intermix them in the same operation.
Previous Topic: plsql table partitions
Next Topic: How to fetch a single record in an array/nested table
Goto Forum:
  


Current Time: Thu Mar 28 20:05:52 CDT 2024