OraFAQ Forum: Forms » Problem to use Clob Field in Forms & Report

Home » Developer & Programmer » Forms » Problem to use Clob Field in Forms & Report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem to use Clob Field in Forms & Report [message #84363]

Mon, 08 March 2004 00:19

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

Report message to a moderator

Re: Problem to use Clob Field in Forms & Report [message #84387 is a reply to message #84363]

Tue, 09 March 2004 02:06

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

Report message to a moderator

Re: Problem to use Clob Field in Forms & Report [message #84427 is a reply to message #84387]

Sun, 14 March 2004 19:16

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

Report message to a moderator

Re: Problem to use Clob Field in Forms & Report [message #237466 is a reply to message #84427]

Mon, 14 May 2007 10:26

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.

Report message to a moderator

Previous Topic:	Inconsistent datatype
Next Topic:	how to view entire value of clob datatype in forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 25 11:13:01 CDT 2025