Little PL/SQL. 100% DBAs HIT DELETE

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Thu, 9 Nov 2000 04:22:33 -0800 (PST)
Message-Id: <10675.121549@fatcity.com>

Hi !!

One of my developer wants to fetch some ids from the table (currently in the orders of 100s at a time..may go upto 1000) and after checking some condition, and if it is satisfied, wants to concat these ids in to a string and passon to the front end (to a web page) .

If it is direct fetch and return a ref cursor can be used. How to concat these ids to a string separated by commas(since varchar is blowing the limits)and return to the frontend?

Tried using DBMS_LOB (with a return datatype LOB) but APPEND does not allow to use comma separated string.

Am I missing something obvious ?

Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ Received on Thu Nov 09 2000 - 06:22:33 CST