A long string as a Input parameter in procedure

gjain12

Newbie

Join Date: Jun 2008

Posts: 18

#1: Sep 17 '09

Hi All,
I want to create an Input Parameter in my procedure which can take a long string of 3000 or more characters.
The strored procedure then use this input parameter as clob type to a function which would do further processing.
But I am not able to find how to create input parameter for such a long string haivng 3000 or more characters.
Any pointers would be very helpful.

Thanks,
Abhishek Chowdhury

Similar DB2 Database bytes

Pass large amounts of text to a stored procedure written in java (answers)
Asynchronous Stored Procedure Never Returns - Help? (answers)
ADO.net Select with multiply value for a parameter? (answers)
stored procedure takes too much time to execute (answers)

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.