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

Which is better trigger or stored procedure?

0 Answers  

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

How many types of literals are available in pl sql?

0 Answers  

What is a field in a database?

0 Answers  




What does seeding a database mean?

0 Answers  

What is rtm in testing?

0 Answers  

When is the explicit cursor used ?

0 Answers  

Can we use views in stored procedure?

0 Answers  

Types of joins ?

11 Answers   Polaris, TCS,

how to create a database in oracle?

3 Answers  

How much does a sql dba make? : SQL DBA

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories