Re: Oracle Stored Proc problem


KK wrote:
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

Do not top post.

Yes, it is a 'must' to declare a length.


David Fitzjarrell

.

Relevant Pages

  • Re: Oracle Stored Proc problem
    ... Maxim Demenko wrote: ... 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)
  • Re: Set Excel column names on destination with SSIS pacakge
    ... One way i can see to do this is at design time you go to the advanced editor and change the names of the columns. ... I'm exporting data using SSIS from a stored procedure call to an EXCEL ... I can set the Excel column names to the names of the ... Can any on help on how to set these destination column names? ...
    (microsoft.public.sqlserver.dts)
  • Oracle Stored Proc problem
    ... Is there any way to declare a variable in stored procedure that should ... hold --- length of text which is not known at design time. ... inSubFKey in varchar ... In the above example If I use vDupTxt VARCHAR, ...
    (comp.databases.oracle.server)