What are the mandatory parameters for Procedures used in Executable?

Oracle Apps Interview Questions › Category: Oracle Apps Basics › What are the mandatory parameters for Procedures used in Executable?
0 Vote Up Vote Down
Questions Master asked 10 years ago
1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago
  1.  Errorbuf: It is used to returns the error messages and sent it to the log file.
  2.  Retcode: It is used to show the status of the Procedure with 0,1,2

0 for Completed Normal
1 for Completed Warning
2 for Completed Error
 
For detailed explanation on Errbuf and Retcode, read this article: http://oracleappsdna.com/2012/03/information-on-errbuf-and-retcode-parameters/