I have an oracle procedure, which i call like that:
DECLARE
ID NUMBER := 12345;
Var1 NUMBER := NULL;
Var2 NUMBER := NULL;
BEGIN
PKG_A.GET_ACCOUNT_VALUES(
ACCOUNT_ID => ID,
SOMEVALUE1 => Var1,
SOMEVALUE2 => Var2
);
END;
ID param is IN/OUT, Var1 and Var2 - OUT.
It's an external system, I can`t change this procedure. How can I get this three values with the help of database/sql library (oci8 driver)? Can I bind somehow, to this Params, or maybe get them with DBMS_OUTPUT some way. Thanks for your help.