tags:

views:

69

answers:

0

Hey, I need some help ;)

I got an Object object1 of the Type (id, ob1 REF object2, ob2 REF object2). These objects2 Types already exists, and I have to create a new object1 with references to the two differen object2 things.

What I am trying right now:

DECLARE
  t_ref REF object2;
  t_ref2 REF object2;

BEGIN
  SELECT REF(*) INTO t_ref FROM tab tt WHERE (tt.id = 1);
  INSERT INTO tab VALUES (object1(5,t_ref, t_ref));
END;

But it won't work, because I don't get an reference to the "object2"s but a number...

What to do/how to achieve my goal?

Thanks a lot!