Hi,
I am trying to run a procedure inside a package in an Oracle Database, but I keep getting errors. The action i am using is a custom database command in easymorph.
What I am Trying to run is:
exec apps.HRVIEW_PKG.set_start_date(‘1-Apr-20’);
which is a custom made procedure made inside the database that uses a date parameter (here 1-apr).
The error I get is ORA–00900 invalid SQL statement.
Then I tried changing the “exec” for “Call”, but I got another error (ORA-00911)
How can I run a custom procedure in an Oracle Database? Has anyone else encountered a similar issue?
Thanks in advance !