Stored Proc for CLOB to recordset of varchar2(4000)

From: Caroline <caroline_doidge_at_hotmail.com>
Date: 31 Mar 2003 09:36:21 -0800
Message-ID: <770d94cb.0303310936.3ef9df3b@posting.google.com>

If this is simple please forgive me.

With the oracle and connection which has been installed for my website, I am unable to obtain a CLOB from the database. Therefore the solution is creating a stored procedure which gets the CLOB and converts it into a recordset of chucks of varchar2(4000).

My knowledge of stored procs is souly based on sql server. So how can this be done in Oracle.

Also is there a reference for stored procedures for oracle?

Very very grateful

Caroline Received on Mon Mar 31 2003 - 11:36:21 CST