Re: Assign Cursor a value in Oracle Procedure?

That you can't do as your value, a string, is incompatible with the cursor type.
You can however use an extra out parameter of type boolean.

Hth,

Sybrand Bakker, Oracle DBA

<josheastburn_at_hotmail.com> wrote in message news:9613e0$2oc$1_at_nnrp1.deja.com...
> I am in the process of writing an Oracle procedure within a package.
> Here is my package declaration:
>
> create or replace package slw as
> type cursorType is ref cursor;
> procedure login ( user_id in varchar2, password in varchar2,
> cursorType out results );
> end slw;
>
>
> Within the procedure body, is it possible to assign the cursor
> (results) to a value? I want to send back "TRUE" or "FALSE". Is there
> a way to do something like:
> results := "TRUE"; ??????
>
>
> Thanks,
> Josh
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Feb 09 2001 - 11:13:48 CST