MQSeries.net :: View topic - Calling Oracle Storeprocedure

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Calling Oracle Storeprocedure - Error

Calling Oracle Storeprocedure - Error

« View previous topic :: View next topic »

Author

Message

ghoshly

Posted: Tue Jun 11, 2013 2:14 am Post subject: Calling Oracle Storeprocedure - Error

Partisan

Joined: 10 Jan 2008
Posts: 333

I am calling a Oracle Stored Procedure where single argument is a CLOB and within the store proc it is used to extract values and insert data into table.

I am facing below error.

Code:

[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-30625: method dispatch on NULL SELF argument is disallowed ORA-06512: at "ESB_ICE_OWNER.ICE_SP_UPLOAD_ERROR_SUMMARY", line 14 ORA-06512: at line 1

Though I have checked in debugger and the argument is not null at the point when calling the stored procedure.

Stored Procedure :

Code:

/*
***************************************************************************
* Procedure to load Error Summary table
***************************************************************************
*/
CREATE OR REPLACE
PROCEDURE ICE_SP_UPLOAD_ERROR_SUMMARY(CH_ERROR_DATA IN CLOB) AS

v_IceErrorInfo XMLType;
CH_SourceSystem VARCHAR2(10);
CH_TimeStamp TIMESTAMP;
CH_TrackingId VARCHAR2(50);

BEGIN

v_IceErrorInfo := SYS.XMLTYPE.CREATEXML(CH_ERROR_DATA);

-- CH_SourceSystem       := v_IceErrorInfo.extract('/ICEHeader/*:SourceSystem/text()','xmlns="http://www.sodexo.com/ESB/ICE"').getStringVal();

CH_TRACKINGID          := v_IceErrorInfo.EXTRACT('/ICEProfile/TrackingId/text()').GETSTRINGVAL();
CH_TIMESTAMP          := v_IceErrorInfo.EXTRACT('//TimeStamp/text()').GETSTRINGVAL();

END ICE_SP_UPLOAD_ERROR_SUMMARY;
/

lancelotlinc

Posted: Tue Jun 11, 2013 3:23 am Post subject:

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

This is an Oracle error. You might find more help here:

http://www.dba-oracle.com/t_ora_30625_method_dispatch_on_null_self_argument_is_disallowed.htm
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER

ghoshly

Posted: Tue Jun 11, 2013 6:40 am Post subject:

Partisan

Joined: 10 Jan 2008
Posts: 333

Thanks for the search result Lance

I had got that earlier and initially I was thinking there is mistake on calling the stored procedure.

Though that was not the case, this error was raising because of null value in data

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Calling Oracle Storeprocedure - Error

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP