If you have to declare procedure1,procedure2 in package
specification and if you have to declare
procedure1,procedure2 and procedure3 in package body? is it
compilation or not and execute or not? what type of error
is given please
Answer / rajesh venati
No, error will occur, because you declared procedure1 and
procedure2 in specification, those are must and should be
define in the package body, other wise it raise an error.
We can declare any no of procedures in body, with out
declared in specification, those are accessible only local.
| Is This Answer Correct ? | 10 Yes | 0 No |
what are the different tables present in mysql? : Sql dba
what is check constraint? : Sql dba
Can a commit statement be executed as part of a trigger?
What is character functions?
Which command is used to delete a trigger?
What are different methods to trace the pl/sql code?
Is sql a microsoft product?
Who is the owner of mysql database?
Can we create non-clustured index on a clustered index ?
How many types of database triggers can be specified on a table ? What are they ?
Is left join inner or outer by default?
Can a select statement fire a trigger?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)