DB function - Procedure with output

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, kevinmiller

Post Reply
D4vidrim
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 58
Joined: Fri May 31, 2013 9:32 am

DB function - Procedure with output

Post by D4vidrim » 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.

D4vidrim
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 58
Joined: Fri May 31, 2013 9:32 am

Re: DB function - Procedure with output

Post by D4vidrim » Tue Jun 21, 2016 7:06 pm

Hi,
does anybody have any advice to give me?

Please!

:P

sphere
Posts: 814
Joined: Sat Sep 27, 2014 10:32 am
Location: Earth

Re: DB function - Procedure with output

Post by sphere » Wed Jun 22, 2016 9:31 pm

maybe you can use this as a start
and build the rest yourself
http://forums.livecode.com/viewtopic.php?f=12&t=27521
2018 Worldwide Mobile Market share: Android 84.4% !!!, iOs 15.1%, others 0.1%

Post Reply

Return to “Databases”