Parameters passing in packages in Interfaces
Hi Everyone,
In Oracle Apps, in inbound interafaces this is the mandatory to pass two OUT variables in the main procedures of the package. Please let me know the requirement of using these two variable :-
1)RETCODE
2)ERRBUF.
Thanks and regards,
Nishank Jain
Re: Parameters passing in packages in Interfaces
[QUOTE=nishank31;31650]Hi Everyone,
In Oracle Apps, in inbound interafaces this is the mandatory to pass two OUT variables in the main procedures of the package. Please let me know the requirement of using these two variable :-
1)RETCODE
2)ERRBUF.
Thanks and regards,
Nishank Jain[/QUOTE]
Using these variables in the code is optional nishan. For Concurrent program these are the two mandatory parameters but in the program there is no need to use. If you want to use also you can use these variables. These are used mainly for handling exceptions.
Re: Parameters passing in packages in Interfaces
if any error is comming in ur programming through ur procedure then
these two parameter errbuff and retcode will do following functions.
errbuff: it will provide the buffer memory to error message and write into log and out files
retcode: return the code into buffer memory and write into log and outfiles