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 is global tempory table?

6254


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

1952


List the types of flexfield?

581


Can you explain the difference between architecture followed in 10g & 11g?

637


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

605






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

604


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1545


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

1626


please send me forms, xml pulisher questions,answers

1635


How can you achieve loose coupling in soa framework?

699


What do you understand by a set of books?

626


q)what are the validations in sql*loader

1721


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

2967


Can you define an erp system?

648


Plz anybody send me Technical specification for AP Interface

1976