Alternative for varchar2? [message #401428] |
Mon, 04 May 2009 23:13 |
mm_kanish05
Messages: 493 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
|
|
|
|
|
|