Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle Stored Proc issues
Is there any way to declare a variable in stored procedure that should
hold --- length of text which is not known at design time.
For ex:
PROCEDURE MUpdate(
inFKey in varchar, inSubFKey in varchar
END MUpdate;
In the above example If I use vDupTxt VARCHAR(---), I have to specify length (1.. 32767)
While executing the stored procedure at runtime, some times I may want to assign longer text.
Appreciate your help!
Thanks Received on Wed Sep 06 2006 - 13:47:07 CDT