Re: How can I change the size of a varchar2 argument in the declaration of a stored procedure?

In article <8fghba$bl5$1_at_nnrp1.deja.com>,   dorutanasa_at_my-deja.com wrote:
> Hello all,
>
> This is my first post so please forgive I do some mistakes.
> My problem is the following. I have a stored procedure with an out
> argument of type varchar2. I want to know what is the maximum size of
> this parameter and how can I modify this size.
>
> TIA,
> Doru
>

In pl/sql for ver 7 & 8 the size of a varchar2 can be from 1 to 32767 bytes or null. When a parameter is defined as varchar2 you do not worry about how large it is in the parameter list but you want to make sure the receiving variable, if any, is large enough to hold the value passed in or out.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.