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!