Home » Developer & Programmer » Reports & Discoverer » How to select from a ref cursor
How to select from a ref cursor [message #89535] Thu, 06 May 2004 03:34 Go to next message
valentin tudorica
Messages: 1
Registered: May 2004
Junior Member
We insert in  before report trigger a ref cursor. We want to use the result of this cursor in another query:


we've done this

1.open cursor1 for (select * from XXX)

we want this

2.select * from cursor1 where ..
Re: How to select from a ref cursor [message #89584 is a reply to message #89535] Wed, 26 May 2004 07:30 Go to previous message
Messages: 40
Registered: May 2004
you can user open cursor with parameter
so you can open cursor several time with deferant criteria
Previous Topic: 6i Error
Next Topic: REP-3000: Internal error starting Oracle Toolkit
Goto Forum:

Current Time: Mon Mar 04 12:31:44 CST 2024