It is because 'A' is a record type so your statement should be

insert into tbl3 values ( A.clmnA );

Regards

Stephen

-----Original Message-----
From: Achilli Christian
[mailto:oracledba-ezmlmshield-x82547502.[Email address protected]
Sent: 01 September 2006 11:50
To: LazyDBA Discussion
Subject: expression is of wrong type

Hi All,

I have:

cursor foo is
select clmnA from tbl1
minus
select clmnA from tbl2;

clmnA from tbl1 and tbl2 are from the same type;

for A in foo loop
insert into tbl3 values ( A );
end loop;

tbl3 is one column table of type clmnA from tbl1 (or tbl2).

At compile time, at insert command line, I get "PLS-00382: expression is
of
wrong type".

Any idea?

Thanks in advance, Chris





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page