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 IS CUSTOM VIEW AND CUSTOM COMPONENT?

2599


testing tools?

1755


Tell me where we find the status of order information?

669


How can you achieve loose coupling in soa framework?

726


What is the concept of soa governance?

776






What is sca and how is it useful?

663


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

619


What are the different components you should consider while defining a responsibility in oracle apps?

647


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

1891


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

1787


In sequence i want to 11 and 15th values how we will write?

1573


In oracle application how do you debug or trace errors?

639


What is a flexfield? List out its types.

669


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2130


please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3083