Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PL/SQL stored procedure parameters?

Answers were Sorted based on User's Feedback



PL/SQL stored procedure parameters?..

Answer / niranjan

Procedure/function (ERRBUF OUT
RETCODE OUT
???????.)
ERRBUF :- Used to write the error message to log
or request file.
RETCODE :- Populate log request file with program
submission details info.

Is This Answer Correct ?    15 Yes 2 No

PL/SQL stored procedure parameters?..

Answer / sreenivasula reddy.bhumireddy

errbuf----> it is used for displaing userdefined message
or system defined message
retcode----> to dispaly the status of the program whether
it is 0--normal
1-->warning
2-->error

Is This Answer Correct ?    9 Yes 2 No

PL/SQL stored procedure parameters?..

Answer / 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

PL/SQL stored procedure parameters?..

Answer / 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

PL/SQL stored procedure parameters?..

Answer / tathagat

CREATE OR REPLACE Procedure/function
<Procedure/function_NAME) (ERRBUF OUT NUMBER,RETCODE OUT
VARCHAR2 number ,PARAMETER1 IN <DATATYPE>,..,) AS
BRGIN
........;
........;
END;

ERRBUF :- Used to write the error message to log
or request file.
RETCODE :- Populate log request file with program
submission details info.

Is This Answer Correct ?    4 Yes 7 No

PL/SQL stored procedure parameters?..

Answer / badari

Addition to above answer

Parameters will be classified as follow:

IN
OUT
IN OUT

Is This Answer Correct ?    7 Yes 11 No

PL/SQL stored procedure parameters?..

Answer / sreenivasula reddy.bhumireddy

Diifferent select statements can be associated in a single
cursorname based on one or more tables

syn: type <typename> is refcursor --weak refcurrsor
type <typename> is refcursor with return type ---strong

Is This Answer Correct ?    1 Yes 7 No

Post New Answer



More Oracle Apps Technical Interview Questions

P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?

9 Answers   CSC, IBM, KPIT, Oracle,


in one report using two layout models.if yes how to do

2 Answers  


what are the match approvals in PO?

3 Answers  


types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,


What is the interface?

3 Answers  






What are the different components of soa suite?

0 Answers  


What is procedure?

3 Answers   IBM,


HOW CAN U KNOW TABLE IS REGISTERD IN APPS?

3 Answers  


what are the functions you are used in utl_file at the time of transferring the data?

2 Answers   Oracle,


what is organization id

2 Answers   Wipro,


Can functions be overloaded ?

2 Answers  


What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)