Dataset Creation problem

Hi all,
I'm facing a problem while creating dataset in BIRT2.1 by calling procedure,the procedure contains 1IN & 1OUT refcursor parameter & after calling this procedure with parameters its showing the error like
SQL Statement doesnot return Resultset object.
I'm using the jdbc data source for connection having connection parameters as:
Driver Class: oracle.jdbc.driver.OracleDriver ( v10.2)
Database URL: jdbc:OSracle:thin:@<IP address>:<servicename>
Data source connection is successful.but data set is not at all generating from procedure.
Can antbody suggest me how to do that?

Regards,
vaishnavi

Find more posts tagged with

Comments

Abdel

Hi

can you provide me your "create procedure"? I need to see the how you have declared your parameters.

vaishnavi

Hi,
I've created the procedure like:

CREATE OR REPLACE PROCEDURE ****
(
p_where IN VARCHAR2,
p_****_Cursor OUT SYS_REFCURSOR
)
AS
v_err varchar2(255);
BEGIN
OPEN p_****_Cursor FOR
'SELECT X.description AS Description, Y.datemoved AS Date_Moved, Y.siteid AS From_Site,' ||
'Y.fromloc AS From_Location,Y.fromparent AS From_Parent,Y.tositeid AS To_Site, ' ||
'X.siteid AS Current_Site,Y.toloc AS To_Location,Y.toparent AS To_Parent, ' ||
'X.assetnum AS Asset ,(SELECT 1 FROM xx ' ||
'JOIN yy ON xx.contractnum = yy.contractnum ' ||
'AND xx.revisionnum = yy.revisionnum ' ||
'AND xx.orgid = yy.orgid ' ||
'WHERE X.assetid = xx.assetid) AS isleased ' ||
'FROM Y, X ' ||
'WHERE X.assetid = Y.assetid ' ||
'AND ' || p_where ||
'ORDER BY Y.datemoved DESC';
EXCEPTION
WHEN OTHERS THEN v_err := SQLERRM;
RAISE_APPLICATION_ERROR(-20500,v_err);
END;

And i'm calling it with IN parameter.
do reply me if u've any solution..

regards,
vaishnavi

vaishnavi

Any Suggession??