Home » SQL & PL/SQL » SQL & PL/SQL » CLOB DATA TYPE PROBLEM
CLOB DATA TYPE PROBLEM [message #259127] Tue, 14 August 2007 08:41 Go to next message
abhijit_saha
Messages: 1
Registered: August 2007
Location: MUMBAI
Junior Member
I have written a program where the code goes like the following:

cursor_name := dbms_sql.open_cursor;
dbms_sql.parse(cursor_name,l_stmt,dbms_sql.native);
rows_processed:=dbms_sql.execute(cursor_name);
dbms_sql.close_cursor(cursor_name);

initially, l_stmt was of type long. after that I have changed to CLOB. But, still I am getting the same kind of length problem. I think the max limit of CLOB is not getting used. Is there any specification for CLOB for specifying the size.

can anyone please help me on this?
Re: CLOB DATA TYPE PROBLEM [message #259149 is a reply to message #259127] Tue, 14 August 2007 09:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_sql does not use LOB until 11g. 32K is the limit.

Regards
Michel
Re: CLOB DATA TYPE PROBLEM [message #259286 is a reply to message #259149] Tue, 14 August 2007 23:12 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Michel Cadot wrote on Wed, 15 August 2007 00:20
dbms_sql does not use LOB until 11g. 32K is the limit.

Regards
Michel


Fixed in 11g (apparently)
Re: CLOB DATA TYPE PROBLEM [message #259672 is a reply to message #259127] Thu, 16 August 2007 04:20 Go to previous message
pandya
Messages: 7
Registered: August 2007
Junior Member
Abhijit,

Couold you please eloberate your proble ,I guess i had somewhat similar kind of problem,so may be i could help you out.Better if you could give any error message details or catched exception details

Previous Topic: Count without time stamps
Next Topic: Pivot Query
Goto Forum:
  


Current Time: Mon Dec 05 06:34:49 CST 2016

Total time taken to generate the page: 0.22854 seconds