Re: functions???

"J. Luis" 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;
> /

If you really, really must do something like this then you should return success/failure via the Return statement and pass back the values in OUT parameters. However, I agree with everyone else - this really should be a stored procedure because it really is the wrong type of thing to perform with a function. Received on Thu Dec 07 2000 - 11:57:55 CST