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 is recursive stored procedure?
What are the most important ddl statements in sql?
Does access use sql?
Is null operator in sql?
Is pl sql better than sql?
What is the difference between inner join and outer join?
Which software is used for pl sql programming?
What are the operators used in select statements?
What is cursor explain with example?
How to return multiple rows from the stored procedure?
what are dynamic queries in t-sql? : Transact sql
how can we submit a form without a submit button? : Sql dba
Enlist some predefined exceptions?
How do I find sql profiler?
Is postgresql a nosql database?