PL/SQL stored procedure parameters?

Answer Posted / manju

Hi All,

we can use the PL/SQL stored procedure using the parameters
(in,out,in-out)and
suppose our stored procedure register into the Oracle apps
then we will using the 2 mandatory parameters those are
(errbuf ,retcode)

Errbut : error buffer will be used to get back to the error
message.
Retcode: give the error code & compilation status.
0- successful execution .
1- success with warning.
2- Error.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

please send me forms, xml pulisher questions,answers

1658


What are the benefits of using soa architecture?

711


What does appl_top directory contain?

650


How is choreography different from orchestration?

654


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2097






Explain oracle apps architecture.

767


How can we import the data into a database using sql * loader?

682


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1761


How to move the one file from one instance to another instance? And your scripts also?

617


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1657


what is pay run id ?

1712


What is sca and how is it useful?

663


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

1892


how to print multi lay outs,muti currency,muti language in xml publisher

10749


what are the prerequisites for costing transactions?

2635