Re: functions???

From: <steveee_ca_at_my-deja.com>
Date: Thu, 07 Dec 2000 12:27:44 GMT
Message-ID: <90nvnq$7gl$1@nnrp1.deja.com>

Yup,

Sybrand nailed it...create it as a procedure..

Steve

n article <90nr07$r61$1_at_news.comunitel.net>, "J. Luis" <jl.alvarez_at_wanadoo.es> wrote:
> does anybody know why is this function invalid???
> I need to send 2 parameters to the function and this must return me 3
> parameters
>
> CREATE OR REPLACE FUNCTION "ADMIN_TRAFICO"."TRAFICO_LOGIN" (
> ulogin IN varchar2(8),
> upasswd IN varchar2(8)
> )
> return varchar2()
> IS
> LOG varchar2(20);
> PAS varchar2(20);
> PRI varchar2(3);
> BEGIN
>
> select blogin,bpasswd,privilegios into log,pas,pri from users
> u,login_passwd l where ulogin=login and upasswd=passwd and
> u.privilegios=l.privilegios;
> return(log,pas,pri);
>
> END trafico_login;
> /
>
> Thanks
> --
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 07 2000 - 06:27:44 CST