oracle-databasestored-proceduresplsqloracle-data-integrator

Calling Oracle PL/SQL stored procedure form ODI


I am going to call a PL SQL stored procedure from ODI which I have created it before. To achieve this matter, by performing a thorough search on this subject on the Internet, I have found that I am supposed to do the following steps:

  1. Create a ODI procedure.
  2. Put code begin schema.myproc(with param) end; in a task of that.
  3. Add this created procedure to an ODI package and run.

So, it is:

begin 
my_schema.procedure_name(20200701)
end;

Now, after doing all above steps, the below error is occurred by which I have got confused what to do, as I have been unable to find a solution.

ODI-1228: Task Procedure-test-task1 fails on the target connection PHY_PARSDB.
Caused By: java.sql.SQLException: ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
:= . ( % ;

So, can anyone help me with this issue?


Solution

  • You forgot a ;

    Correct code is:

    begin 
    my_schema.procedure_name(20200701);
    end;