1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Problem to get ref of table of objects with nested table

Discussion in 'SQL PL/SQL' started by bytec0d3, Mar 2, 2013.

  1. bytec0d3

    bytec0d3 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    i've a table of objects with a nested table. If i query for a ref of object inside that table i receive a null ref....why???

    I can't post code: i get this error from the forum "Oops! your Post seems to be a SPAM! If you are posting live links, you need to have made at least 5 Posts as required by the administrator. Please edit your post or contact the administrator."

    Thx in advance and sorry for my english :p
     
  2. dariyoosh

    dariyoosh Forum Advisor

    Messages:
    118
    Likes Received:
    19
    Trophy Points:
    260
    And without seeing any code, in your opinion, how someone might guess what you have done?
    Which seems to be a good solution before passing to the main problem.
     
  3. bytec0d3

    bytec0d3 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    You're right, sorry.
    The code is here: pastebin[dot]com/EQ90VeeD

    the result of first select is: imageshack[dot]us/photo/my-images/441/resgh.png/
    and the second one is: imageshack[dot]us/f/145/resquery.png/
     
  4. bytec0d3

    bytec0d3 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    no one knows why i get a null ref? :confused::(