DB function - Procedure with output
Posted: Thu Jun 16, 2016 7:08 pm
Hi,
I'm looking for a way to launch PL/SQL procedures and functions returning values to my LC app.
My DB is an Oracle DB.
For example a procedure like this one:
PROCEDURE PROCESSO_OPEN(p_user VARCHAR2, p_id_proc OUT mac000_processi.MAC000_ID_PK%TYPE);
I'm able to launch procedures, but I have no idea how to get the output variable p_id_proc: is there a way?
Same problem with functions:
FUNCTION getVATcode(p_vat_descr VARCHAR2) RETURN NUMBER;
How can I call an Oracle function and return its value?
Thank you for any advice.
I'm looking for a way to launch PL/SQL procedures and functions returning values to my LC app.
My DB is an Oracle DB.
For example a procedure like this one:
PROCEDURE PROCESSO_OPEN(p_user VARCHAR2, p_id_proc OUT mac000_processi.MAC000_ID_PK%TYPE);
I'm able to launch procedures, but I have no idea how to get the output variable p_id_proc: is there a way?
Same problem with functions:
FUNCTION getVATcode(p_vat_descr VARCHAR2) RETURN NUMBER;
How can I call an Oracle function and return its value?
Thank you for any advice.