Oracle eBS經驗分享

If we need write Oracle PL/SQL Program for concurrent program using.

We need create procedure (ex. xx_procedure)

This xx_procedure need has base two parameter.(errbuf out varchar2,retcode out number).

• Errbuf : Errbuf is one the paramter which will define in pl/sql to store procedure to get error messges into log file.
• Retcode: this parameter will be used to get the status of the concurrent program. It will give the values
  - 0 for sucess
  - 1 for warning
  - 2 for errors