what is mean by forward declaration and where we'll use it.
Answers were Sorted based on User's Feedback
A forward declaration looks like the package definition
part but is inside the bode.
e.g.
procedure A is
begin
B;
end A;
procedure B is
begin
null;
end B;
will not work, because during call to B B is still unknown
(1 Step compiler) therefore we need a forward declaration:
procedure B;
procedure A is
begin
B;
end A;
procedure B is
begin
null;
end B;
now we can compile
| Is This Answer Correct ? | 30 Yes | 2 No |
Answer / guru
Forward Declaration means.. If you are defining a package
body having two procedures , If u want to use second
procedure in the definition of first procedure.. You have to
declare the second package with its arguments (if have)
before using in the definition of first procedure. It’s
labeled as forward declaration
OR
EX1:
DECLARE
PROCEDURE P1 IS
BEGIN
dbms_output.put_line('From procedure p1');
p2;
END P1;
PROCEDURE P2 IS
BEGIN
dbms_output.put_line('From procedure p2');
p3;
END P2;
PROCEDURE P3 IS
BEGIN
dbms_output.put_line('From procedure p3');
END P3;
BEGIN
p1;
END;
Output:
p2;
*
ERROR at line 5:
ORA-06550: line 5, column 1:
PLS-00313: 'P2' not declared in this scope
ORA-06550: line 5, column 1:
PL/SQL: Statement ignored
ORA-06550: line 10, column 1:
PLS-00313: 'P3' not declared in this scope
ORA-06550: line 10, column 1:
PL/SQL: Statement ignored
Ex2:
DECLARE
PROCEDURE P2; -- forward declaration
PROCEDURE P3;
PROCEDURE P1 IS
BEGIN
dbms_output.put_line('From procedure p1');
p2;
END P1;
PROCEDURE P2 IS
BEGIN
dbms_output.put_line('From procedure p2');
p3;
END P2;
PROCEDURE P3 IS
BEGIN
dbms_output.put_line('From procedure p3');
END P3;
BEGIN
p1;
END;
Output:
From procedure p1
From procedure p2
From procedure p3
Thanks
Guru
| Is This Answer Correct ? | 22 Yes | 1 No |
Answer / 6/8/07
Forward declaration is used in declaring subprograms that
can be used in packages.
eg: procedure query_emp(empno number,empname varchar);
--procedure is declared.
we should define the procedure next..
the basic idea is :declaration first and definition later.
| Is This Answer Correct ? | 8 Yes | 1 No |
Procedure which allows for Special Sub-program declaration
is nothingbut " Forward Declaration".
| Is This Answer Correct ? | 3 Yes | 0 No |
How do I run a sql trace?
What is embedded sql what are its advantages?
what is recursive stored procedure? : Sql dba
What makes a good primary key?
i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject
what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
5 Answers HCL, JPMorgan Chase,
What are the two types of periodical indexes?
what is the bond code in materialized view?
Find out the 3rd highest salary?
51 Answers BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,
Is stored procedure faster than query?
What is denormalization in a database?
what is commit? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)