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!

ORA-30732 table contains no user-visible columns

lzhwxyJun 3 2004 — edited Jun 3 2004
I have following piece of sample code, and got 'ORA-30732 table contains no user-visible columns' when I run it, can anyone help me to figure out what the problem is?
( following is just a testing code to validate something, the logic makes no sense here.)

CREATE OR REPLACE TYPE Old_New_Obj AS OBJECT (Old_Id int, New_Id int);
/
CREATE OR REPLACE TYPE Old_New_TB AS TABLE OF Old_New_Obj;
/
Create table ttt(old_id int, new_id int);
/
declare
result int;
tb Old_New_TB;
tb1 Old_New_TB;

begin
select Old_New_Obj(1,2)
bulk collect into tb
from dual;


select Old_New_Obj(1,4)
bulk collect into tb1
from dual;

insert into ttt (new_id )
select b.new_id
from table(tb) a inner join table(tb1) b on a.old_id = b.old_id
where rownum = 1;

select new_id into result from ttt where rownum =1;

dbms_output.put_line(result);
end;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2004
Added on Jun 3 2004
4 comments
1,673 views