Try initializing OUT variable prior to executing the PL/SQL block.
(i.e. v_out=0, or some other number that works for you)

Regards,
Afzal Chaudhry


-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed]
Sent: Sunday, December 29, 2002 9:57 PM
To: LazyDBA.com Discussion
Subject: Reg :- Ora





Hi,

I am getting the following error and the solution is also given here .
My
problem is i have an procedure that will insert the data into table and
return status as number data type and i am calling the procedure from
my
.Net application. I like to know how to increase the buffer size in my
procedure .


ORA-01458: invalid length inside variable character string


Cause: An attempt was made to bind or define a variable character string
with a buffer length less than the two-byte minimum requirement.


Action: Increase the buffer size or use a different type.



Regards

Jayaprakash.


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page