Advertisement

07.11.2007 at 06:09AM PDT, ID: 22688601
[x]
Attachment Details

Issue with Ref Cursor with CLOB - Oracle

Asked by pras_gupta in Oracle 10.x, Databases Miscellaneous, Oracle Database

Tags: cursor, clob, oracle, ref

Hi,

We are using Oracle 10g. We have an SP that returns a ref cursor with a CLOB column in it. The issue that we face is that whenever the data in the CLOB column exceeds 4000 chars, the column itself is not being selected and ref cursor holds only the other columns.

Have anyone of you faced a similar problem? Can you tell us the reason and solution for this?

Thanks in advance.
Start Free Trial
[+][-]07.12.2007 at 03:03AM PDT, ID: 19470095

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.18.2007 at 12:13PM PDT, ID: 19516450

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 10.x, Databases Miscellaneous, Oracle Database
Tags: cursor, clob, oracle, ref
Sign Up Now!
Solution Provided By: paulnamroud
Participating Experts: 3
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32