Re: passing parameters to PL/SQL block.

From: Ninja <lbo_ninja_1999_at_yahoo.com>
Date: 2000/05/18
Message-ID: <8g04sc$1dkf$1@buty.wanadoo.nl>#1/1

A parameter is always define only with the type and without lenght. That's the PL/SQL syntax.

create procedure test1(name out char) will work

Luc Bosman
DEV/2000 Software Engineer
Database and Network Administrator
IILE-SRI
rue Ransonnet, 5
B-4020 LIEGE
BELGIUM
l.bosman_at_wanadoo.be
ICQ 37011625 http://users.skynet.be/kobukai/

|  -°)                                          (°-  |
|  /\\  Linux the choice of the GNU generation  //\  |
| _\_v                                          v_/_ |
 ----------------------------------------------------

morella3253_at_my-deja.com a écrit dans le 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 Thu May 18 2000 - 00:00:00 CDT