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

Can we insert data into materialized view?

0 Answers  

What is sql prepared statement?

0 Answers  

Is sql sequential or random?

0 Answers  

What are the events on which a database trigger can be based?

0 Answers  

What are character functions?

0 Answers  




What is lexical units in pl sql?

0 Answers  

differentiate between float and double. : Sql dba

0 Answers  

What is meant by truncate in sql?

0 Answers  

what are local and global variables and their differences? : Sql dba

0 Answers  

what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

0 Answers  

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories