Hi Can anyone explain what this mean? I have practise PL/SQL about REF obj_type, my codes are: CREATE or REPLACE TYPE home_type AS OBJECT (street VARCHAR2(50), city VARCHAR2(20), state VARCHAR2(20), zipcode VARCHAR2(6), owner VARCHAR2(10));/CREATE TABLE homes OF home_type;INSERT INTO homes VALUES ('300 Regina St', 'WATERLOO', 'ON', '010010', 'HFWANG');INSERT INTO homes VALUES ('301 Regina St', 'WATERLOO',...

priti

• Nov 11th, 2019

Kindly let me know what do you want in result using ref cursor? here you ref cursor as a table which is not exists in system. that is what it is giving error

krishnaveni_g

 Profile Answers by krishnaveni_g Questions by krishnaveni_g

• Jul 15th, 2008

I checked the code it's working fine.

Answer Question  Select Best Answer