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


Please Help Members By Posting Answers For Below Questions

What is recursive stored procedure?

812


What are the most important ddl statements in sql?

745


Does access use sql?

750


Is null operator in sql?

792


Is pl sql better than sql?

717






What is the difference between inner join and outer join?

712


Which software is used for pl sql programming?

677


What are the operators used in select statements?

771


What is cursor explain with example?

733


How to return multiple rows from the stored procedure?

714


what are dynamic queries in t-sql? : Transact sql

742


how can we submit a form without a submit button? : Sql dba

723


Enlist some predefined exceptions?

797


How do I find sql profiler?

683


Is postgresql a nosql database?

791