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

Which oracle apps version you are very confident in?

0 Answers  


Tell me how to find the custom directory in front end?

0 Answers  


What r the type Models in the system parameters of the report?

1 Answers  


which API to return the parameters & valuesets etc

1 Answers   GE, TCS,


pls send me out bound code of supplers,site,bankiformation code pls as soon as

0 Answers  






in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers   Cap Gemini,


we have 4 managers if one person logon the system automatically displays his siganature and name how?

1 Answers   BirlaSoft,


I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,


Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?

3 Answers   Oracle,


How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,


What is the reason for distribution hold. Why invoices will go on distribution variance hold ??

1 Answers   Oracle,


Can you have two functions with the same name in a pl/sql block?

5 Answers   TCS,


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)