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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple question on Oracle stored procedure/function---HELP!!

Re: Simple question on Oracle stored procedure/function---HELP!!

From: Lee Kyoung Rok <tunnel_at_hananet.net>
Date: Sat, 4 Dec 1999 16:28:04 +0900
Message-ID: <up324.2058$sI3.73398@news.hananet.net>

Dana Jian <djian_at_trasa.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ news:38482277$0$80452_at_news.choice.net¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> Hello,
>
> I'm a new user of PL/SQL in Oracle8, I have two questions as following:
>
> 1) Can function in Oracle server return more than one value? how?
>
> I was trying to use OUT type of parameters in a function on the Oracle
> server, but I got NULL(VB program as front-end) returned from that
function.
>
> Anyone knows the reason?
>
> 2) Can function in Oracle server return a recordset--multiple rows with
> multiple columns? How??
>
> I really appreciate the help!!!
>
> Dana Jian
> dan_jian_at_hotmail.com
>
>

I knew that Oracle function returned only one value. Funcation couldn't OUT variable.
And return type is only for normal SQL type like (number, Varchar2, Char, etc...).
*^^* Received on Sat Dec 04 1999 - 01:28:04 CST

Original text of this message

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