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

What is the example of procedure?

910

---

What is meant by truncate in sql?

1046

---

What is a table partition?

1106

---

What is trigger price?

962

---

How do you know if a relationship is 2nf?

926

---

What is an exception in pl/sql?

1055

---

What is trigger and stored procedure in sql?

1017

---

Is pl sql better than sql?

1009

---

What is on delete set null?

1071

---

Explain normalization and what are the advantages of it?

938

---

What is primary key and unique key?

1098

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1117

---

What sql does db2 use?

962

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2209

---

i have some prob lem to tell me about my self in interview first round ...

2151

---