Home » SQL & PL/SQL » SQL & PL/SQL » Ref Cursors - Query (Oracle 9i)
Ref Cursors - Query [message #354139] Thu, 16 October 2008 09:36 Go to next message
sivaram2006
Messages: 7
Registered: October 2008
Location: chennai
Junior Member
Hi all,

I have a complex Query for all.

I have an existing stored procedure developed in Oracle 9i.
This will return a set of rows using a Ref Cursor to the front end (asp.net page). That ref cursor uses some complex query.

Now my problem is,

That ref cursor returns a set of records to the front end.
Now my requirement is that, based on a condition (Some flag called private) a record in that set of records should display all the columns as "Private".

For example, if that refcursor gives five tickets t1,t2,t3,t4,t5 and
if t3 is private, then all the columns in that ticket t3 should show as private.

How can this be done ?

Thanks....
Re: Ref Cursors - Query [message #354150 is a reply to message #354139] Thu, 16 October 2008 10:40 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Define "Show as private"
Previous Topic: How to Split a date (Merged)
Next Topic: Multiple Row insert into a single insert query
Goto Forum:
  


Current Time: Sat Feb 15 00:55:02 CST 2025