i declare 4 procedure in package specification but in package
body i write only 3 procedure. is it complie??//w

Answers were Sorted based on User's Feedback



i declare 4 procedure in package specification but in package body i write only 3 procedure. is it..

Answer / jprakash025

no its not compile .wt are the procedure or fun etc..
declare in the specification section .must define in the
package body .

Is This Answer Correct ?    17 Yes 2 No

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it..

Answer / rabindra nath das

i declare 4 procedure in package specification but in package
body i write only 3 procedure. is it complie??//w
------------------------------------------------------
Ans:-It will show you 'Warning: Package Body created with compilation errors.'
PLS-00323: subprogram or cursor'4thpackage name' is declared in a package specification and must be defined in the package body

because in package specification you are define 4 package
so you need to define 4 package under package body.

Is This Answer Correct ?    7 Yes 0 No

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it..

Answer / ayan

Procedures that are defined in package spec are public
procedures but procedures those are in package body but not
in package spec are private procedure. we cannot call
private procedure using
package_name.private_procedure_name.Private procedure
should be called from any public procedure.

Is This Answer Correct ?    1 Yes 2 No

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it..

Answer / jprakash025

yes it s complie

Is This Answer Correct ?    6 Yes 13 No

Post New Answer

More SQL PLSQL Interview Questions

Which is better join or inner query?

0 Answers  


We have a CURSOR then we need BULK COLLECT?

1 Answers  


What does truncate mean in sql?

0 Answers  


why sql is used as interpreter frequently rather than a compile?

1 Answers  


What is orm in sql?

0 Answers  






Explain the rollback statement?

0 Answers  


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  


Where is pl sql used?

0 Answers  


Is sql workbench free?

0 Answers  


can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  


How many types of cursors supported in pl/sql?

0 Answers  


What are the different types of a subquery?

0 Answers  


Categories