Select from an object type tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Select from an object type tables

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    Unhappy 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

  2. #2
    Join Date
    Dec 2001
    Posts
    203
    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

  3. #3
    Join Date
    Dec 2001
    Posts
    203

    Question

    Hey

    What happened?????????????????????????


    Thanks
    sumit

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  5. #5
    Join Date
    Dec 2001
    Posts
    203
    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
  •  


Click Here to Expand Forum to Full Width