1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / neo

Answers were Sorted based on User's Feedback



I have 2 packages A and B. Now package A references Package B and Package B references Package A. ..

Answer / nitin

With the use of forward declaration we can call other package

Is This Answer Correct ?    11 Yes 3 No

I have 2 packages A and B. Now package A references Package B and Package B references Package A. ..

Answer / subha

First compile package A and B spec then compile package body of both A and B.

Is This Answer Correct ?    4 Yes 1 No

I have 2 packages A and B. Now package A references Package B and Package B references Package A. ..

Answer / ss

i know sql so here A and B are two tables which both having Primary and foreign Key so from A's PK is referring in to B and B's PK referring in to  A 
OR select * from A inner join B on (A.id=B.AID)

Is This Answer Correct ?    3 Yes 1 No

I have 2 packages A and B. Now package A references Package B and Package B references Package A. ..

Answer / nitin

Forward declaration can be implemented for procedure only.In one package you can create inter-dependency but for package it is not possible.

Is This Answer Correct ?    3 Yes 2 No

I have 2 packages A and B. Now package A references Package B and Package B references Package A. ..

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

More SQL PLSQL Interview Questions

explain what is mysql? : Sql dba

0 Answers  

How many commands are there in sql?

0 Answers  

What is a package ? What are the advantages of packages ?

2 Answers   Symphony,

What is pl sql package?

0 Answers  

What is a system versioned table?

0 Answers  




Why is sharding used?

0 Answers  

What is online transaction processing (oltp)?

0 Answers  

how to write utl file pkg in SQL

1 Answers   Oracle,

while loading data into database how can u skip header and footer records in sql*loader

1 Answers   Oracle,

What is the difference among union, minus and intersect?

0 Answers  

What are the two types of cursors in pl sql?

0 Answers  

Is sql a programming?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories