Stored Proc to fetch Clob data
Posted on 2004-11-01
I have a clob data type field in one of my oracle8i database tables. My application uses this clob field data to store/fetch info consisting of 24000 characters max.
I need a stored proc which when called from my application will fetch that clob data. Problem is I can't use select statement as it would have it's varchar (4000 characters) limit.
Can any one please help me out with the stored proc which when called would fetch those infomations from the clob data field, by passing empty buffers as arguments.
I need the stored proc.