Hi all,
I have an Object type table, named CUST_LEV_OT. When I am querying like
select * from CUST_LEV_OT;
I am getting ORA 04044 Procedure,Function,package or type is not allowed here.
How to select those table?
Thanks
Printable View
Hi all,
I have an Object type table, named CUST_LEV_OT. When I am querying like
select * from CUST_LEV_OT;
I am getting ORA 04044 Procedure,Function,package or type is not allowed here.
How to select those table?
Thanks
It's wonder me , that I am yet to get any reply.
Any way I am giving you more inputs...
I have created an object type as
create type xxx as object
( city varchar2(10),
street varchar2(10));
ANd then created a table.... as
create table stud
( roll number,
address xxx);
In such case I can insert and select from stud as follows...
1. insert into stud values(1,xxx('LA','12 NC lane'));
But How to insert and select directly from the object XXX without taking reference of any table.
Shall I have to CAST the same .... using PL/SQL ??????????
Thanks
Hey
What happened?????????????????????????
Thanks
What Happened where? Constant badgering is unlikely to get you a sensible response.Quote:
Originally posted by sumit
Hey
What happened?????????????????????????
Thanks
AFAIK it's not possible to enter data directly to the TYPE definition or select from it with referencing via a table.
http://support.oracle.co.uk/metalink...T&p_id=69467.1
Regards
I am so sorry. I didn't want to mean anything.
By the way THANKS!!