WHAT IS THE FORWARDREFERENCE IN PL/SQL?
- 4 Answers
- 9114 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What are the Import Programs We need to run after creating Interface table for all modules
While running the concurrent program we will get the status, we have to change the status. How it will be done.
How relation will be made between modules in oracle financial?
In support project one ticket alloted which steps follows manualy tell me ?
Where we can write a PL/SQL code in report triggers?
What are file in oracle.
what is the need of registering table in apps?
In hierarchical structure of a database? we have write query from where we should start?
How to move the one file from one instance to another instance? And your scripts also?
How will you get the concurrent program output as email?
What are the different components you should consider while defining a responsibility in oracle apps?
where is setup of business group done?
Oracle Apps Technical 
