| Unable to use Dataset on stored procedure [message #143390] |
Mon, 13 March 2006 06:01 |
Eclipse User |
|
|
|
Hi All,
I want to use a Oracle stored procedure on a dataset but it is not
working; here the query I put on my dataset :
{ call BS_STATISTICS.GETEXOCETDETAIL('MO_PAR','200603')}
And here the SQL Code (package only) :
CREATE OR REPLACE PACKAGE BS_STATISTICS
IS
TYPE ExocetStatisticsCount IS RECORD (
nb
f2b_bs.strategy_external_ref_id%TYPE,
place f2b_bs.place%TYPE,
portfolio f2b_bs.portfolio%TYPE,
strategy_kind f2b_bs.strategy_kind%TYPE,
status f2b_bs.status%TYPE
);
TYPE Cur_ExocetStatisticsCount IS REF CURSOR RETURN
ExocetStatisticsCount;
PROCEDURE GETEXOCETDETAIL (
pplace IN varchar2,
pyymmm IN varchar2,
pstats OUT Cur_ExocetStatisticsCount
);
END BS_STATISTICS;
/
When I execute in BIRT I have this error, in other client it is working :
A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.0.1
Error Code:odaconsumer.CannotExecuteStatement
Error Message:Cannot execute the statement.
SQL statement does not return a ResultSet object.
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GETEXOCETDETAIL'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Any idea ?
Thx,
-emmanuel
|
|
|
Powered by
FUDForum. Page generated in 0.26709 seconds
Home