don't know whether this is even possible.
I have a data set that is not possible to achieve using a native SELECT statement.
I've written what I need into a FUNCTION (or PACKAGE function) that returns a record.
How do I get the data row returned by the FUNCTION in the "Data Model"
SELECT * from
FZ_SEC_SCHOOL
p_term_code_key);
SELECT
FZ_SEC_SCHOOLp_term_code_key)
FROM dual;
Program Unit:
FUNCTION CF_SEC_SCHOOL
RETURN SZRSECS_TEMP%ROWTYPE
IS
BEGIN
RETURN SZKSECS.FZ_SEC_SCHOOLp_term_code_key);
END;
I have a data set that is not possible to achieve using a native SELECT statement.
I've written what I need into a FUNCTION (or PACKAGE function) that returns a record.
How do I get the data row returned by the FUNCTION in the "Data Model"
SELECT * from
FZ_SEC_SCHOOL
p_term_code_key);SELECT
FZ_SEC_SCHOOL
p_term_code_key)FROM dual;
Program Unit:
FUNCTION CF_SEC_SCHOOL
RETURN SZRSECS_TEMP%ROWTYPE
IS
BEGIN
RETURN SZKSECS.FZ_SEC_SCHOOL
p_term_code_key);END;