DB function - Procedure with output

[D4vidrim]

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.

[D4vidrim]

Hi,
does anybody have any advice to give me?

Please!

[sphere]

maybe you can use this as a start
and build the rest yourself
http://forums.livecode.com/viewtopic.php?f=12&t=27521