Home » Developer & Programmer » Forms » Problem to use Clob Field in Forms & Report
Problem to use Clob Field in Forms & Report [message #84363] Mon, 08 March 2004 00:19 Go to next message
Syed Ferhat
Messages: 20
Registered: January 2004
Junior Member
Dear All

 

I have field BD_DESC having clob data type. Its working fine when i used it from sql plus environment but when i am trying to use the same field through form (developer 6i) it will not display the data of the same field . Plz help me in the same .

 

Thanks
Re: Problem to use Clob Field in Forms & Report [message #84387 is a reply to message #84363] Tue, 09 March 2004 02:06 Go to previous messageGo to next message
Jeslie
Messages: 26
Registered: April 2003
Junior Member
Syed

You should use the DBMS_LOB package to manipulate CLOB columns in forms/Reports.

Thanks
Jeslie
Re: Problem to use Clob Field in Forms & Report [message #84427 is a reply to message #84387] Sun, 14 March 2004 19:16 Go to previous messageGo to next message
Syed Ferhat
Messages: 20
Registered: January 2004
Junior Member
Thanks Jaslie,

I really appriciate your response, but would u give me some example of the same, if u can.

Thanks
Ferhat
Re: Problem to use Clob Field in Forms & Report [message #237466 is a reply to message #84427] Mon, 14 May 2007 10:26 Go to previous message
lavallee_g
Messages: 22
Registered: May 2005
Location: Quebec
Junior Member
Hi,
Instead of doing manipulations with dbms_lob package, you can also use a long field in forms based on your clob. The only catch, its that you can only have a maximum of 32767 characters...

Forms will manage all the rest.
Previous Topic: Inconsistent datatype
Next Topic: how to view entire value of clob datatype in forms 6i
Goto Forum:
  


Current Time: Mon Dec 05 23:57:24 CST 2016

Total time taken to generate the page: 0.06245 seconds