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

What are the different components of soa suite?

728


How do you register report in oracle apps?

636


What is oracle soa suite?

773


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1694


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

1894






Tell me where we find the status of order information?

675


What is oracle soa suite and what are its different components?

652


Can u give the Documentation of Custom.pll in oracle apps

3000


do you know is it possible to run the interface without using oracle apps?

656


What are the benefits of using soa architecture?

714


how can develope the po variance and po summary report? with tables mandatory columns and query please?

1982


What do you understand by a set of books?

652


what are the different transaction clauses in AR?

1606


How to create a purchase order without a requisition?

636


q)what are the validations in sql*loader

1748