WHAT IS THE FORWARDREFERENCE IN PL/SQL?

Answers were Sorted based on User's Feedback



WHAT IS THE FORWARDREFERENCE IN PL/SQL?..

Answer / ranjith

If a stored procedure(Function or Procedure) need to be
called inside another stored procedure in the same package
then the called procedure should be declared before the
calling procedure. This declartion is called Forward
Reference.

Example:

CREATE OR REPLACE PACKAGE BODY pkg_FR_Test
.
.
Begin
prc_FR_Procedure(p_P1 NUMBER, p_P2 VARCHAR2);--> FR
.
.
prc_Call_Procedure(p_Param1 NUMBER)
BEGIN
.
.
prc_FR_Procedure(20, 'Account');
.
.
END prc_FR_Procedure;
END

Is This Answer Correct ?    5 Yes 0 No

WHAT IS THE FORWARDREFERENCE IN PL/SQL?..

Answer / raghav

PL/SQL does not allow forward references. You must declare a variable or constant before referencing it in other statements, including other declarative statements.

Is This Answer Correct ?    4 Yes 0 No

WHAT IS THE FORWARDREFERENCE IN PL/SQL?..

Answer / ranjith

The above answer is for "Forward Declaration" and not
for "Forward Reference".

Sorry for the confusion.

Is This Answer Correct ?    2 Yes 1 No

WHAT IS THE FORWARDREFERENCE IN PL/SQL?..

Answer / veera

declaring the procedures or functions in the package
specification before using them in package body.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

List the types of flexfield?

0 Answers  


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,


How many parameters we can pass through pl/sql program in Oracle apps

4 Answers  


what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  


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

2 Answers  


in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

1 Answers   KPMG,


How does accounting occured in Expense Reporting?

1 Answers   Sapient,


what is latest version in reports

8 Answers  


What is invoice?

3 Answers   Murugappa Group,


what u did after ur btech(2009) till now? why did u prefer oracle apps technical?

1 Answers   Intelligroup,


In a Standard form a DFF is disable?How we can Enable it?

5 Answers   Caritor, TCS,


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

0 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • 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)