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.

For ex:

PROCEDURE MUpdate(
inFKey in varchar,
inSubFKey in varchar
)
IS
vCount NUMBER NOT NULL DEFAULT 0;
vDupTxt ---
BEGIN
vDupTxt := "---"

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

.

Relevant Pages

  • 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 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. ... inSubFKey in varchar ... In the above example If I use vDupTxt VARCHAR, ...
    (comp.databases.oracle.misc)
  • Re: Any way to keep TADOStoredProc parameters
    ... connect the TADOStroedProc component to the database at design time. ... I only type in the name of the stored procedure into the box. ...
    (borland.public.delphi.database.ado)
  • 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)
  • SQL Paging with VS2005
    ... I don't know why All my stored Procedure which provide custom pageing don't ... @WhereCriteria varchar = NULL, ... DECLARE @WHEREWord varchar ... IF @PageIndex!= 0 ...
    (microsoft.public.dotnet.framework.aspnet)