Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: passing parameters to PL/SQL block.
Datatypes for PL/SQL procedures/functions must be unconstrained - you cannot define the size of the datatype. Well, not directly anyway. You can do the following:
create procedure test1(name out mytable.name%TYPE,...
where the column name in the table mytable is char(50). I haven't actually tried this to see if it constrains the parameter or not, but it may be worth a try.
Mike
bigrez_at_mail.hughes.net
morella3253_at_my-deja.com wrote in message <8fvgok$jsv$1_at_nnrp1.deja.com>...
>Hi,
>
>Why can't I use a parameter of type CHAR(50) in a parameter
>list of procedure I am trying to compile.
>
>Ex: create procedure test1(name out CHAR(50),...)...
>
>
>Thanks
>More.
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri May 19 2000 - 00:00:00 CDT