OraFAQ Forum: Reports & Discoverer » How to handle a string of 10,000 chars in oracle reports

Home » Developer & Programmer » Reports & Discoverer » How to handle a string of 10,000 chars in oracle reports (oracle reports, 6i)

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

How to handle a string of 10,000 chars in oracle reports [message #307712]

Wed, 19 March 2008 11:45

rajesh4851
Messages: 89
Registered: January 2007

Member

Hi,
here i have a problem with the report query.
I have to generate the SQL query dynamically based on the input parameter.
I am storing this dynamic query in a variable which is declared as LONG.
After the query generated, i am assigning it to one parameter.
Here i am facing the problem, that dynamic query is lenght of 10,000 chars are generating, but it is not able to store in that parameter.
Please help me to solve this problem.
Thanks.

Report message to a moderator

Previous Topic:	How to duplicate a folder in EUL keeping the same folder name
Next Topic:	reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 15:34:58 CDT 2024