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:
begin schema.myproc(with param) end;
in a task of that.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?
You forgot a ;
Correct code is:
begin
my_schema.procedure_name(20200701);
end;