Shruti

• Sep 15th, 2006

 

Retcode is an OUT parameter. It can have 3 values (0/1/2)

where

0 - Success

1 - Success with wanings

2 - Error

ram

• Sep 20th, 2006

 

there is another parameter for apps procedure errbuff

ratnakar

• Jan 23rd, 2007

 

While registering procedure as concurent program there we need to declare two mandatary OUT parameters in procedure.

1.Errbuf

2.Retcode



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



Ratnakar Reddy