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.