Casting table records into a collection
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Casting table records into a collection

  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Casting table records into a collection

    I have created a user defined type( 91 attributes)( and then created a nested table collection of that type. In the type I have creatd a constructor to override the deafult constrcutor which allows me to create an instance of the object w/o all the attibute values(28 attrs ).

    I can use standard pl sql block to declare and construct the object type successfully. BUt what I really want to do is select rows from a table and use cast(multiset(select ...)..) to populate the collection with data, using the constructor that I created to accept 28 values. When I attempt this , I get a compile time error : ORA-02315 incorrect number of arguments for default constructor


    I there anyway to bulk populate a collection w/o using defrault constructor. or is this an oracle limitation.

    thx

  2. #2
    Join Date
    Oct 2003
    Posts
    2
    one more piece of Info:
    I am using oracle 9i ( 9.2.0.1.0) on win xp pro

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