Assign Cursor a value in Oracle Procedure?

From: <josheastburn_at_hotmail.com>
Date: Fri, 09 Feb 2001 15:47:15 GMT
Message-ID: <9613e0$2oc$1@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 - 09:47:15 CST