Home » Developer & Programmer » Forms » Alternative for varchar2? (Form6i,oracle9i)
Alternative for varchar2? [message #401428] Mon, 04 May 2009 23:13 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi,
I have developed a screen that is used to print an SQL output to forms and export the result in excel.
In this module i am just sending the sql, based on the report selection from a list box. The selection list has become too long. I am planning to generate the list based on user level permissions. To do this I have to store the SQL in a table as different rows. There seems to be a limitation of varchar2(4000) for storing an SQL. Is there an alternative ? Is it possible using BLOB data type ? If yes, how do I store and retrieve data in BLOB data type ?

kanish
Re: Alternative for varchar2? [message #401494 is a reply to message #401428] Tue, 05 May 2009 04:07 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
You definitley don't want to use BLOB - it stores binary data - try a CLOB.
Re: Alternative for varchar2? [message #401496 is a reply to message #401428] Tue, 05 May 2009 04:29 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Any limition for clob, if yes, how many char i can store in that field

kanish
Re: Alternative for varchar2? [message #401499 is a reply to message #401428] Tue, 05 May 2009 04:47 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Lots

The documentation is a wonderfull thing - if you use it.
Previous Topic: Simple Loop does not populate the block correctly
Next Topic: Run Report with parameter
Goto Forum:
  


Current Time: Fri Dec 09 17:25:30 CST 2016

Total time taken to generate the page: 0.32238 seconds