-
Select from an object type tables
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
sumit
-
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
sumit
-
Hey
What happened?????????????????????????
Thanks
sumit
-
Originally posted by sumit
Hey
What happened?????????????????????????
Thanks
What Happened where? Constant badgering is unlikely to get you a sensible response.
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
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
I am so sorry. I didn't want to mean anything.
By the way THANKS!!
sumit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|