OraFAQ Forum: SQL & PL/SQL » Crystal Report Support for Ref

Home » SQL & PL/SQL » SQL & PL/SQL » Crystal Report Support for Ref_Cursors

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Crystal Report Support for Ref_Cursors [message #36425]

Tue, 27 November 2001 04:51

Keshav Tripathy
Messages: 30
Registered: November 2001

Member

I have written a Stored Procedure which is returning the REF_CURSORS.
Can I pass the paremeters or take the parameters of the same ref_cursors from crystal reoport. Which version of Crystal report will support this.
Thanks and Regards.
Keshav
keshav_tripathy@satyam.com

----------------------------------------------------------------------

Report message to a moderator

Re: Crystal Report Support for Ref_Cursors [message #36429 is a reply to message #36425]

Tue, 27 November 2001 10:58

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

you can pass ref_cursors to crystal reports.but you have to use crystal reports ODBC driver (not oracle supplied ODBC driver).

----------------------------------------------------------------------

Report message to a moderator

Re: Crystal Report Support for Ref_Cursors [message #36434 is a reply to message #36429]

Tue, 27 November 2001 19:25

Keshav Tripathy
Messages: 30
Registered: November 2001

Member

But Which version of Crystal Report will support Ref_cursors in the oracle SP.

----------------------------------------------------------------------

Report message to a moderator

Re: Crystal Report Support for Ref_Cursors [message #36444 is a reply to message #36429]

Wed, 28 November 2001 03:13

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

as far as i know crystal reports 7 & 8 definitely support. for other versions check at crystal reports website.

----------------------------------------------------------------------

Report message to a moderator

Re: Crystal Report Support for Ref_Cursors [message #39747 is a reply to message #36425]

Wed, 07 August 2002 00:45

Amit kulshrestha
Messages: 2
Registered: August 2002

Junior Member

ya it will support , since crystal report require single query input. So ref cursor is required.
u have to use Crystal ODBC driver for that...
CRORACLE8 and dont forget to Check the option procedure return result under advance Tab.
Thanks

Report message to a moderator

Previous Topic:	Finding a column name of a column you know the value of.
Next Topic:	Use of COMMIT for DML Sql queries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 20:10:05 CDT 2024