What is the various Return codes in the registration of PL/SQL concurrent program?Trouble shooting in Interfaces and various Oracle Application modules?

  • Interview Candidate
  • 2
  • 11545

Showing Answers 1 - 2 of 2 Answers

Vijay Gurme

  • Jun 21st, 2006
 

There are two two types of codes that arereturn while registering the PL/SQL procedure

These are

1) errbuf

2)retcode

  Was this answer useful?  Yes

rahul.gatade

  • Apr 13th, 2008
 

For Registering any PL/SQL stored Procedure as a concurrent program we need to include two mandatory parameters for that procedure,
1) ERRBUF    OUT VARCHAR2
2) RETCODE OUT NUMBER

The 1st parameter is used by apps to store the error messages(if any) after the execution of the concurrent program
The 2nd parameter is used to return the code of the status of the concurrent program
The possibl;e values are
0 -> successful execution(no error)
1 -> completed with warnings
2 -> Completed with error

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions