I am connected to an oracle database and am trying to run a procedure on uipath. It performs well, but after this query I execute another one that gives a select in this procedure, but an error is generated saying that the string is not in the correct format
The String is in the correct format.
I’ve been taking a look at the behavior of the program and realized that the error is generated because somehow after executing the first query (procedure) it is deleted or the database closes or something.
I come here to see if anyone has passed through this experience or know how to solve the problem.
Hello friend, I took the first query, but getting only the second it generates an empty dataTable, and I’m not passing parameters. Would it be possible for me to pass the second query as a parameter of the first one?
This is the sql that I need to execute (it is not possible to execute it all. It has to be the procedure first and then the select):
sinagro.fluxo_pagar_sinagro (TO_DATE(‘01/08/2012’, ‘DD/MM/YYYY’), TO_DATE(‘26/03/2019’, ‘DD/MM/YYYY’), TO_DATE(‘26/03/2019’, ‘DD/MM/YYYY’));
SELECT * FROM sinagro.FLUXO_PAGAR ORDER BY 1,2,6,12
Thank you very much for replying, I await your return.
I am also working on a similar project where I need to call a ORACLE stored procedure from UiPath which is already deployed in the target database and get output as a data table for further processing.
The procedure will take manager id as a input parameter and outputs all employees names, employee id’s reporting him/her. Although it is a simple select query we are planing it to implement through stored procedures.
I can implement this in My SQL database but in Oracle I am unable to do it.
Can you help me by showing how the procedure should look like in Oracle so that it should give an output as datatable. Any sample file would be much helpful
Sorry Emman, that is not the answer he was expecting and neither am I because it doesn’t answer the problem. Looking on the forum I can see multiple questions on this topic but NO valid answer.
Can someone post a sample xaml that does this?
Here is a sample stored proc that I created please use this:
PROCEDURE Get_Operator (
in_org_id IN VARCHAR2,
inret_data IN OUT sqlcur)
SELECT 123 as ORG_ID
, ‘test1’ as ORG_NAME
SELECT 456 as ORG_ID
, ‘test2’ as ORG_NAME
SELECT TO_NUMBER(in_org_id) as ORG_ID
, ‘test3’ as ORG_NAME