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

From: Cobalt Blue '99 <Bragul_at_hotmail.com>
Date: Sun, 05 Dec 1999 21:25:44 +0800
Message-ID: <384A67D7.B3B98C5B@hotmail.com>

I think you've got to use the '&' or passing parameters by reference in the calling program of your VB app to the stored procedure/function..

Dana Jian wrote:

> 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
Received on Sun Dec 05 1999 - 07:25:44 CST