How to give very long string data in string type variable of PL/SQL

[manush]

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

 

[GJParker]

Whre does crystal reports come into this problem ?

Gary Parker
MIS Data Analyst
Manchester, England

 

[manush]

My stored procedure is being called from the crystal report and hence I am getting the problem.

My code is very big and to explain it in a simpler way, I skipped something which might confuse you people.

Hope, you would now like to suggest something.

Manoj