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
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 |
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 |
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 |
What is the best strategy to use COMMIT in a pl/sql loop?
explain the difference between bool, tinyint and bit. : Sql dba
Why do we go for stored procedures?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
What is diff between bulk collect and forall
What is db journal file?
What is assignment operator in pl sql?
What does <> sql mean?
what is the difference between delete and truncate commands? : Sql dba
What is the maximum database size for sql express?
How to read/write files from pl/sql?
how can we destroy the cookie? : Sql dba