Hi,
I declared a variable in my stored procedure as
strSQL VARCHAR2(8000);
Because I have a very long string with select query using 4-5 UNIONs. The length of my string is about 7500
But I am not able to assign it in strSQL.
If we can't declare VARCHAR2 with such a long length, can what is the other solution.
Please help ..
Manoj
I declared a variable in my stored procedure as
strSQL VARCHAR2(8000);
Because I have a very long string with select query using 4-5 UNIONs. The length of my string is about 7500
But I am not able to assign it in strSQL.
If we can't declare VARCHAR2 with such a long length, can what is the other solution.
Please help ..
Manoj