where to define a type ref cursor in Designer

From: Oxmard <shankeyp_at_no-spam.comcast.net>
Date: Thu, 13 May 2004 06:47:12 -0500
Message-ID: <Nd2dnetRtKIKwj7dRVn-uQ_at_comcast.com>



[Quoted] Using Designer 9.0.2.84.2

I'm creating a procedure. The procedure uses a ref cursor type, For example:

type rc is ref cursor;
my_cursor rc;

Where would I define this type in Designer. I've tried using 'Oracle Object Types' & 'Oracle Collection Types' containers. I'm not sure if I was not using the tool correctly.

Next, I assume I would need to be using 'Declarative' for the selection 'How the PL/SQL will be defined' then use the DATA tab to reference the type? or would I put the type rc in the Sub Program Units folder of the procedure I'm working on?

Thanks
Ox Received on Thu May 13 2004 - 13:47:12 CEST

Original text of this message