Author |
Message
|
atreyu5 |
Posted: Thu Sep 16, 2010 6:03 am Post subject: Invoking SP Oracle with OUT REF CURSOR from ESQL WMB 6.1 |
|
|
Newbie
Joined: 16 Sep 2010 Posts: 3
|
Hi,
I'm trying to invoke an Oracle's SP from ESQL, but I get this error at the end of the stacktrace:
Code: |
DatabaseException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbOdbc.cpp
Line:INTEGER:459
Function:CHARACTER:ImbOdbcHandle::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2322
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:22003
Insert
Type:INTEGER:2
Text:CHARACTER:0
Insert
Type:INTEGER:5
Text:CHARACTER:[Oracle][ODBC]Numeric value out of range.
|
This is my minimal example:
ESQL
Code: |
DECLARE cursor REFERENCE TO OutputRoot.XMLNS.Test;
CALL SP_SATIF_CONSULTAS_PAN(cursor.ResultSet1[]);
CREATE PROCEDURE SP_SATIF_CONSULTAS_PAN ()
LANGUAGE DATABASE
DYNAMIC RESULT SETS 1
EXTERNAL NAME "SATCLDS.PKG_SATIF_CONSULTAS_PAN.SP_SATIF_CONSULTAS_PAN";
|
ORACLE
Code: |
CREATE OR REPLACE PACKAGE SATCLDS.PKG_SATIF_CONSULTAS_PAN IS
/*********************************************************************************/
TYPE T_CURSOR IS REF CURSOR;
PROCEDURE SP_SATIF_CONSULTAS_PAN (
O_MOV_MES OUT T_CURSOR);
END PKG_SATIF_CONSULTAS_PAN;
/
|
The ReturnResultSet option in ODBC driver is turn on.
I can view the SP result from TOAD, so it's right.
I'm using WMB 6.1.0.7 and Oracle 10g2, with Oracle's ODBC Driver.
What am i doing wrong?
Thanks in advance. |
|
Back to top |
|
 |
Gaya3 |
Posted: Thu Sep 16, 2010 6:34 am Post subject: |
|
|
 Jedi
Joined: 12 Sep 2006 Posts: 2493 Location: Boston, US
|
did you set the ProcedureRetResults Value "ON" _________________ Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
Back to top |
|
 |
atreyu5 |
Posted: Thu Sep 16, 2010 6:53 am Post subject: |
|
|
Newbie
Joined: 16 Sep 2010 Posts: 3
|
Do you refer to the advance configuration of the ODBC driver?
I have: Enable Result Sets (ON) and Enable Closing Cursors (ON).
But, I haven't one called: ProcedureRetResults
Thanks, |
|
Back to top |
|
 |
mqjeff |
Posted: Thu Sep 16, 2010 7:04 am Post subject: Re: Invoking SP Oracle with OUT REF CURSOR from ESQL WMB 6.1 |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
atreyu5 wrote: |
What am i doing wrong? |
I think it's this:
atreyu5 wrote: |
I'm using WMB 6.1.0.7 and Oracle 10g2, with Oracle's ODBC Driver. |
You need to use the DataDirect ODBC driver for Oracle and not any Oracle supplied ODBC driver. |
|
Back to top |
|
 |
atreyu5 |
Posted: Thu Sep 16, 2010 7:28 am Post subject: |
|
|
Newbie
Joined: 16 Sep 2010 Posts: 3
|
Well, I've installed the Datadirect Driver for Oracle and it works!
So, it's a driver problem?
Are there any Oracle, IBM or Ms option?
Thanks, |
|
Back to top |
|
 |
Gaya3 |
Posted: Thu Sep 16, 2010 7:40 am Post subject: |
|
|
 Jedi
Joined: 12 Sep 2006 Posts: 2493 Location: Boston, US
|
atreyu5 wrote: |
Well, I've installed the Datadirect Driver for Oracle and it works!
So, it's a driver problem?
Are there any Oracle, IBM or Ms option?
Thanks, |
I want to answer this before Jeff does  _________________ Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
Back to top |
|
 |
mqjeff |
Posted: Thu Sep 16, 2010 8:16 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
You shouldn't have needed to *install* the DataDirect ODBC driver, or *any* ODBC driver.
Broker ships with them, and you need to use the ones that ship with Broker as specifically documented in the InfoCenter. |
|
Back to top |
|
 |
|