how to a sp returning ref cursor to generate crystal report????????????????? [message #88057] |
Tue, 29 January 2002 23:26 |
Neeti
Messages: 7 Registered: November 2001
|
Junior Member |
|
|
CAN I USE A STORED PROCEDURE,WHICH IS USING A REF CURSOR TO GENERATE CRYSTAL REPORT.IF YES, THEN HOW CAN I USE IT.WHEN I AM USING STORED PROCEDURE 'CRYSTALTEST' IN CRYSTAL REPORT, ERROR COMES :- WRONG NUMBER OR TYPE OF ARGUMENTS IN CALL TO 'CRYSTALTEST'.
SP IS LIKE:-
CREATE OR REPLACE PROCEDURE CRYSTALTEST
(rc1 out pkg_ebill.rct1)
as
begin
open RC1 FOR
SELECT * FROM TEST;
END;
CREATE OR REPLACE PACKAGE PKG_EBILL AS
TYPE RCT1 IS REF CURSOR;
END;
|
|
|
|