OraFAQ Forum: SQL & PL/SQL » How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va

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)

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

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

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

Report message to a moderator

[Message index]

		How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va By: Piranava on Mon, 10 June 2019 05:29
		Re: How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va By: Michel Cadot on Mon, 10 June 2019 05:44
		Re: How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va By: cookiemonster on Mon, 10 June 2019 05:57
		Re: How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va By: Bill B on Thu, 13 June 2019 07:24

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 02:59:00 CDT 2024