Jump to content
Changes to the Jaspersoft community edition download ×

about stored procedure in oracle

Recommended Posts

By: Zhiqing Li - lizhiqing

about stored procedure in oracle

2003-12-01 01:06



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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...