This discussion is archived
4 Replies Latest reply: May 17, 2011 3:41 PM by gaverill RSS

Get REF of object not in table?

406968 Newbie
Currently Being Moderated
This is one of those questions that makes it obvious what a newbie you are :-/

Is it possible to get a REF for a local object that is not in a table (yet)?

If I (could) return the REF from a function and the object leaves scope, does the object persist?

My plan was for a member function to populate a newly-created, empty object, and return a REF to it. The corresponding object would then be INSERTed into an object table.

Is this an assumption of Oracle's implementation of Object Types -- that they will always be stored in a table somewhere?

I have to use a REF because otherwise I have self-reference with no indirection. :-(

  • 1. Re: Get REF of object not in table?
    329549 Newbie
    Currently Being Moderated
    I'm not sure I follow all of what you are trying to achieve but I think I have a couple ideas around it.

    You can get a ref to a local object like this:

    my_obj my_obj_type := my_obj_type (null);
    my_obj_ref ref my_obj_type;
    select ref(my_obj) into my_obj_ref from dual;

    I think what you want is a member function that returns a reference to itself.

    I would expect that you could try something like the above within the member function and return the resulting ref. I have not tried this though.

  • 2. Re: Get REF of object not in table?
    406968 Newbie
    Currently Being Moderated
    Thanks Joe.

    My reading of the docs was that REF expects a correlation variable, not an object. In other words, it needs to be in a table somewhere. :-(

    ie. DEREF(REF(i)) == object != i

    But I will try your suggestion!
  • 3. Re: Get REF of object not in table?
    397384 Newbie
    Currently Being Moderated
    If you are using a PK-REF based object view or table, you can use the MAKE_REF function to get a REF to an object that is not yet persistently stored.

    If you are using system-generated OIDs you cannot get a REF until it is stored in a table.
  • 4. Re: Get REF of object not in table?
    gaverill Journeyer
    Currently Being Moderated
    if you use object views instead of object tables, it's as easy to construct a 'self-reference' attribute as an other REF attribute, use MAKE_REF:
      create or replace view V_My_View
      of TMyObject
      with object identifier (key1, key2, ...)
      select t.key1
      ,        t.key2
      ,        ...
      ,        make_ref(V_My_View, t.key1, t.key2, ...) as selfRef
      ,        ...
      from   T_My_Table t
      where ...
    Hope this helps.