Hi there i am using Oracle Connector P220.127.116.11.. to call a stored procedure..
For procedure without parameter, it suceeds. Unfortunately, it fails if the procedure has input parameter..
it seems that the parameter is not sent to the procedure.. because there is error wrong arguments or type... and if i define the procedure without parameter, it works...
Thank you in advance,,
If i'm not mistaken, if you have a parameter called "myInput" you will need to pass a record with an attribute called "myInput", if you have more inputs just add attributes to the record.
Important notes: you need to pass ToObject(Record) and the attributes must have the same name as the input.
Nuno Rolo wrote:
tq, but it still does not work..
CREATE OR REPLACE PROCEDURE pkg.myproc(pid in varchar2) AS tot_emps NUMBER; BEGIN DELETE FROM OSADMIN.IBOXUSER employees WHERE employees.id = 1; commit; END;/
here is the struct.. alias record?
here is the local variable of type that struct:
and here is the parameter to call:
here is the action flow:
here is my input widget:
and here is the error:
it works..tq struct different with record: