Unanswered: return multiple variables from function via DBLINK
I've created a function for use by another database through a dblink.
I created the function to return a ref cursor but
have since found out that this is not allowed so i'm looking for
Assuming I want to keep the function on our database (for maintainability reasons) what other options do i have?
Two suggestions i've got are 1) to return a ',' delimited string
or to have a number of OUT parameters. Is there any reason
why either of these would not work or would be preferable to the other?
Thanks for reading, any help much appreciated.
BTW i'm new to PL/SQL so feel free to dumb it down.
CREATE OR REPLACE FUNCTION "GET_SCHEME_DETAILS"
IN_BRANCH IN VARCHAR2,
IN_AGENCY IN VARCHAR2,
IN_PRODUCT_SUFFIX IN VARCHAR2,
IN_TERM IN INTEGER,
IN_LOAN_START_DATE IN DATE
RETURN sys_refcursor AS TYPE RESULTSET IS REF CURSOR;