How to get value cursor OUT SYS_REFCURSOR return from store procedure oracle in Uipath

[jnfantasy4]

I have this store procedure it’s have 2 parameter out: rs (NVARCHAR2) and cursor(SYS_REFCURSOR).

this my procedure:

      CREATE OR REPLACE NONEDITIONABLE PROCEDURE PR_TABLE1(
         RS OUT NVARCHAR2,
         CURSOR OUT SYS_REFCURSOR
      )
      AS 
      
      BEGIN
             OPEN CURSOR FOR
                SELECT * FROM EXAM;  
           RS:='SUCCESS!';
        COMMIT;
       
      END PR_TABLE1;

when I test on pl/sql is ok.But It’s error on UiPath like this.

Run query-Withtext: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to ‘PR_TABLE1’
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

And this’s my configExcecuteQuery in UiPath

Can any one help me please.
Thank you.

[Anil_G (Anil Gorthi)]

@jnfantasy4

Datatable is not the second output type I believe

If you need a table instead of cursor get the table and send the table out

Cheers

[jnfantasy4]

Do you know a second output type? because in UiPath don’t have a SYS_REFCURSOR type like procedure so I use the datatable type to receive it from procedure.
And about send the table out from procedure now I only know use SYS_REFCURSOR to return it.I don’t know another way. Can you give me example?

[Anil_G (Anil Gorthi)]

@jnfantasy4

If you use select * from table you can get the whole table right

Cheers

[Marcelo_Guimaraes (Marcelo Guimarães)]

You need to assign the proper type in the arguments: