Interested to Buy Any Domain ? << Click Here >> for more details...
I have 2 packages A and B. Now package A references Package B
and Package B references Package A. How do you compile such
inter-dependent objects in PL/SQL
- 5 Answers
- 19262 Views
- Doyensys, Infosys, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / anil
I assume this question as:
") I have 2 programs A and B. Now program A references Program B and Program B references Program A. How do you compile such inter-dependent objects in PL/SQL"
ANS:We can compile mutually referencing programmes using FORWARD declaration(specifying the declaration of one program in beginning of package body) inside a PACKAGE.
Example:
CREATE OR REPLACE PACKAGE test_pack
IS
gvar NUMBER:=0;
--PROCEDURE p1; --we can also achieve like this
END;
/
CREATE OR REPLACE PACKAGE BODY test_pack
IS
PROCEDURE p1; --forward declaration
PROCEDURE p2
IS
BEGIN
P1;
END;
PROCEDURE p1
IS
BEGIN
p2;
END;
END;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are tuples in sql?
Where can I learn sql for free?
Define the select into statement.
How to move files from one directory to another in pl sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is sql constant?
What is set transaction?
What do you mean by rowid?
What are commit, rollback, and savepoint?
What is multiple columns?
How to use transactions efficiently : transact sql
what are numeric data types? : Sql dba
Do we need to rebuild index after truncate?
What does seeding a database mean?
Inline the values in PL/SQL, what does it mean.?
