Re: Determining fields of a variable cursor

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 16 Jul 2004 16:21:53 -0700
Message-ID: <1090020133.524572@yasure>

Oracle Newbie wrote:

> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1089958832.514561_at_yasure...
>

>>Oracle Newbie wrote:
>>
>>>How is it possible to determine the fields of a cursor variable that is
>>>passed to a procedure thru code
>>>
>>>
>>>CREATE OR REPLACE PROCEDURE myProc ( crs cur_var )
>>>BEGIN
>>>            /* Code that determines the fields of cursor variable crs.
>>>                Is it possible? */
>>>
>>> END;
>>
>>Read the code.
>>
>>Daniel Morgan
>>

>
>
>
> There is no code, Actually I have to write the code that determines the
> fields/columns of the cursor variable. I want to know if it is possible.

Nonsense.

If I write:

OPEN ref_cursor FOR
SELECT col1, col2, col3
FROM mytable;

I know the answer to the question, so do you, so does everyone.

You can'be writing it and not have code to read unless you write your code in braile.

Daniel Morgan Received on Fri Jul 16 2004 - 18:21:53 CDT