Re: Store Procedure

From: Graham Thornton <dangermouse_at_prodigy.nospam.net>
Date: 1997/12/23
Message-ID: <01bd0fd0$979cece0$b0f7c9c7@dangermouse>#1/1

news.is.co.za <wpo_at_saol.co.za> wrote in article <01bd0ab6$6c845760$0b0e25c4_at_karoo>...
> Hi
>
> 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
>

Willie,

You can define a table as

create table mytable( alpha varchar2(10));

... and then in your package use:

procedure myproc( argument1 mytable.alpha%type );

this will then limit the arguement length to 10 chars.

hope this helps.

Graham - typing one handed whilst on the 'phone. :)

---

remove the .nospam from the E-mail address to reply. Received on Tue Dec 23 1997 - 00:00:00 CST