Re: Oracle Stored Proc problem

Is it a must to declare length?

Maxim Demenko wrote:
KK schrieb:
Is there any way to declare a variable in stored procedure that should
hold --- length of text which is not known at design time.


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


PL SQL variables are limited to 32K (i.e. you can't assign a longer
value to pl sql variable).

Best regards

Maxim

.

Relevant Pages

  • Re: Oracle Stored Proc problem
    ... hold --- length of text which is not known at design time. ... While executing the stored procedure at runtime, ... PL SQL variables are limited to 32K (i.e. you can't assign a longer ...
    (comp.databases.oracle.server)
  • Re: Oracle Stored Proc problem
    ... hold --- length of text which is not known at design time. ... While executing the stored procedure at runtime, ... PL SQL variables are limited to 32K. ...
    (comp.databases.oracle.server)
  • RE: I am dead with ado rs.Find("Code Like E*)
    ... Check if you have Recordcount> 0 before executing the Find method. ... the record pointer to the first position using MoveFirst method. ... "Manish Sawjiani" wrote: ... > This works during design time without problem but after i execute compiled ...
    (microsoft.public.vb.database.ado)