AFX connector: How can we write multiple sql queries in a single capability
example : EBS createAccount () capability will do 3 work ,
1) Register the person in oracle EBS using a stored procedure.
2) Select the person_ id using select query.
3) Using the same person id call the stored procedure to create user.
Please provide me the solution.
I have a database connector to execute multiple SQL statements / stored procedure on MS SQL.
The example below is for create account