PL/SQL stored procedure parameters?

Answer Posted / ravi soma

Stored Procedure parameters are mainly 3 Types
They are IN
OUT
INOUT.

If we register the procedure in Oracle Apps as concurrent
Program then we have to pass above parameters and
additionally 2 more out parameters.

They Are-errbuf out varcher2
-retcode out Number or Varchar2

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the prerequisites for costing transactions?

2622


please send me forms, xml pulisher questions,answers

1645


tell me the scenarios of the independent in reports

2031


How can you achieve loose coupling in soa framework?

709


Are you familiar with internet architecture of oracle apps 11i?

615






What do you understand by soa and what are the benefits of using this architecture?

611


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

634


What does appl_top directory contain?

630


can we get profile values in report without using user exists is it possible how?

2305


How is choreography different from orchestration?

635


What are do's and dont's of Interface?

1890


How do you register report in oracle apps?

612


how do you describe O2C along with tables

2299


Tell me how to debug the report?

624


can we use look up type instead of a pofile option?or valueset?is it possible how?

1772