Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: functions???

Re: functions???

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Thu, 07 Dec 2000 12:57:55 -0500
Message-ID: <3A2FCFA3.76FA2628@Unforgetable.com>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US