Re: functions???

In 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
> --
>
>

What is the definition of a function? A function can only return *BY DESIGN* one single value.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.