MQSeries.net :: View topic

nhanks · Posted: Wed Apr 21, 2004 7:25 pm Post subject:

I am having trouble calling simple Oracle Stored Proc.

from ESQL in Database Node
CALL MyProc('world');
CREATE PROCEDURE MyProc(IN in_var CHARACTER) EXTERNAL NAME MyProc;

Oracle sp looks like:
create or replace procedure MyProc(in_var in varchar2)
IS
test_var varchar2(5);
BEGIN
test_var :='hello';
END;

I am using the DataDirect driver for Oracle, have executed mqsisetdbparms correctly, and am logging in with the schema that the above proc is defined in.

Any help would be appreciated.

The following is my ExceptionList from Trace Node:
( WBRK_BROKER.WBIMB ) Error message 'DB Node Error: (
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S000_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x03000000):Line = 558
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmDatabaseNode'
(0x03000000):Name = 'TestFlow#FCMComposite_1_5'
(0x03000000):Label = 'TestFlow.APT_Database'
(0x03000000):Text = 'Node throwing exception'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x01000000):DatabaseException = (
(0x03000000):File = 'F:\build\S000_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x03000000):Line = 181
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Text = 'Root SQL exception'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2321
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '-1'
)
(0x01000000):DatabaseException = (
(0x03000000):File = 'F:\build\S000_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x03000000):Line = 296
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Text = 'Child SQL exception'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2322
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '28000'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '1017'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '[DataDirect][ODBC Oracle driver][Oracle]ORA-0'
)
)
)
)
)
' from trace node 'TestFlow.Trace1'.

The trace node 'TestFlow.Trace1' has output the specified error message.

This is an error message provided by the message flow designer. The user response will be determined by the local environment.