I have a problem that I don't know where to look to understand the problem.
I have a function that I first select to get a table name followed by
another select into on that table name. If someone could tell me where to
look to solve this problem I would appreciate it.
It is something like
DECLARE rec1 Record;
rec2 Record;
SELECT aName INTO rec1 FROM tableA WHERE new.xxx = ?;
IF FOUND THEN
SELECT * INTO rec2 FROM rec1.aName where new.xxx = ?;
Thanks