Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

pl/sql in out types.cursortype

user12198870Mar 20 2017 — edited Mar 20 2017

Hi,

I created an object type as:

CREATE OR REPLACE TYPE HPOWNER.T_WEBMATERIALS AS TABLE OF O_WEBMATERIALS;

and then a TABLE of the object:

CREATE OR REPLACE TYPE HPOWNER.O_WEBMATERIALS AS OBJECT

(

  PRODUCTNUMBER VARCHAR2(32),

  PRODUCTTYPE VARCHAR2(60),

  PRODUCTVARIANT NUMBER(1)

)

The procedure call is

CREATE OR REPLACE PROCEDURE PRODUCTS (RESULTS IN OUT TYPES.CURSORTYPE)  IS

How to send values in and get values from the procedure?

Please give the syntax.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2017
Added on Mar 20 2017
3 comments
414 views