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
Is sql pronounced sequel or sql?
What is sql entity?
What are all different types of collation sensitivity?
What is null in pl/sql?
What is the difference between alter trigger and drop trigger statements?
What is the difference between rename and alias?
What is sql character function?
What sql does db2 use?
Can a foreign key be null?
Explain exception handling in pl/sql?
What is the least restrictive isolation level? : Transact sql
what is uncommittable transactions? : Transact sql
What is the cause of mutating table error and how can we solve it?
What is trigger explain with example?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba