Re: Store Procedure

From: Lothar Armbruester <lothar.armbruester_at_rheingau.netsurf.de>
Date: 1997/12/18
Message-ID: <659.291T689T13203092@rheingau.netsurf.de>#1/1

On 17-Dez-97 09:27:00 news.is.co.za wrote:
>Hi

Hello!

>is it posisble to use fixed length input varaibles in a Oracle Store
>Procedure like
>this :

>Procedure SP_TEMPDATA
> ( P_Name IN CHAR(30),
> P_Tel IN CHAR(30)
> IS
>BEGIN
> INSERT INTO TEMPDATA
> (NAME, TEL)
> VALUES
> (P_Name, P_Tel);
> COMMIT;
>END;

>Thanks
> Willie Prinsloo

I think it is possible to define some types inside of a package. THen you could use these type in your procedure.

Hope that helps,
Lothar

--
Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |

Received on Thu Dec 18 1997 - 00:00:00 CST