Returning a recordset from a stored procedure...

[RobPierre]

Hi,

I have looked around for the answer to this but I haven't found a clear one.

Can a stored procedure return a recordset? I am trying to call a stored procedure from Crystal Reports and print the results but I have been told that stored procs cannot return record sets.

Further down this forum I saw somebody suggest using a ref cursor. Is this the way to do it, or is there another way?

We'll be using Oracle 8.1.6 on an HP Unix box with a WinNT4 client.

Somebody posed this question on the Oracle tech support forum last year and the answer was "it sounds like a crystal reports problem". It seems to me that it has nothing to do with CR.

Thanks in advance for any help.

Rob.

 

[Dagon]

A REF CURSOR is the way to return a record set from a stored procedure. There is no other way apart from writing out to a temporary table or a file. The question is then whether Crystal Reports supports calling stored procedures which return record sets. I couldn't comment on this as I don't know anything about Crystal Reports.