about stored procedure in oracle

[2002 JI Open Discussion]

By: Zhiqing Li - lizhiqing

about stored procedure in oracle

2003-12-01 01:06

hi,

 

I must use stored procedures instead of sql query string in my jasperreport. But, in oracle, I know that stored procedures can't directly return multiple lines in the form of a recordset like MS SQLServer do. What should I do then.

 

 

 

 

 

By: Glenn Owen - grubincan

RE: about stored procedure in oracle

2003-12-02 09:13

What version of oracle are you using?

You can do this from version 9 and up.

 

Prior to v9, you would need to populate a temporary table using your stored proc. and then select the data from that.