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:

Ex

we've done this

1.open cursor1 for (select * from XXX)

we want this

2.select * from cursor1 where ..

Report message to a moderator

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
hany
Messages: 40
Registered: May 2004
Member
hi
you can user open cursor with parameter
so you can open cursor several time with deferant criteria

Report message to a moderator

Previous Topic: 6i Error
Next Topic: REP-3000: Internal error starting Oracle Toolkit
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 21:25:00 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.