I want to execute a piece of code before calling a procedure. How to achieve it?
Answer Posted / abhisekh
we can call a procedure using 2 ways
1.using exec <procedure>
2.using anonymous block< begin <procedure> end;
now coming to ur questions answer. crate a anonymous block and add the statements u wanted to execute first then call the procedure.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the uses of sysdate and user keywords?
Explain the the delete statements in sql?
Is sql a scripting language?
Can I join the same table twice?
What is the difference between nested table and varray?
What are different methods to trace the pl/sql code?
Is record in pl sql?
What is pl/sql table? Why it is used?
What is a design view?
Does sql between include endpoints?
How can use stored procedures in sql?
What is dml with example?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Define select, insert, create, delete, update, drop keywords
How do I create a sql script?