Got error 6550 in FDPSTP when stored procedure was submitted as a concurrent request.
I installed PL/SQL procedure, XXBS_PROCESS_NEWDAY, as a concurrent program ( Concurrent > Program > Executable & Define). This procedure has no parameters. It’s function is to update a non-Oracle Application’s table; i.e., a custom table. Also, this procedure is not part of a package.
=========================================================
CREATE or REPLACE PROCEDURE xxbs_process_newday IS
BEGIN
UPDATE xxbs_process_table
set status_now = 'NEW DAY',
todays_date = sysdate
where process_name = 'Exchrate Load and Recovery';
--
COMMIT;
--
END xxbs_process_newday;
=========================================================
I tested it successfully in the SQLPLUS environment. However, when the stored procedure was launched as a concurrent request, it terminated in error. The log file showed the following error message: