Home » SQL & PL/SQL » SQL & PL/SQL » How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va (oracle 11g)
How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va [message #676459] Mon, 10 June 2019 05:29 Go to previous message
Piranava
Messages: 1
Registered: June 2019
Junior Member
How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated value .Currenly we used varchar2 but it will fails when values more than 4000 are passed in.


The input is my order number where all order number are separated with (,)t .Order number is varchar2 here.

Apart from CLOB is there any other way.Please guide
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to build a query that gets its values from a file
Next Topic: Using the Sql query to find employees who were recruited on the same day or on neighboring days.
Goto Forum:
  


Current Time: Fri Aug 14 06:52:38 CDT 2020