GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle Apps
Go To First  |  Previous Question  |  Next Question 
 Oracle Apps  |  Question 31 of 61    Print  
What is the value of retcode mandatory parameter in oracle apps procedures?

  
Total Answers and Comments: 3 Last Update: January 24, 2007     Asked by: vijay bhaskar 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
September 15, 2006 09:04:06   #1  
Shruti        

RE: what is the value of retcode mandatory parameter i...

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

where

0 - Success

1 - Success with wanings

2 - Error


 
Is this answer useful? Yes | No
September 20, 2006 05:15:09   #2  
ram        

RE: what is the value of retcode mandatory parameter i...
there is another parameter for apps procedure errbuff
 
Is this answer useful? Yes | No
January 23, 2007 23:32:01   #3  
ratnakar        

RE: What is the value of retcode mandatory parameter i...
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

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape