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
- 19558 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
How to run sql functions in pl/sql?
What is inner join in sql?
Why use triggers in sql?
What are the types of join and explain each?
How many unique keys can a table have?
How can a function retun more than one value in oracle with proper example?
What are the three forms of normalization?
What is package in pl sql?
What is the process of debugging?
Which operator is used in query for pattern matching?
What is an invalid partition table?
How can a pl sql block be executed?
Is sql scripting language?
How much does a sql dba make? : SQL DBA
How do you get column names only for a table (sql server)?
