Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 are the uses of sysdate and user keywords?

1149


Explain the the delete statements in sql?

1116


Is sql a scripting language?

1086


Can I join the same table twice?

1095


What is the difference between nested table and varray?

1052


What are different methods to trace the pl/sql code?

1171


Is record in pl sql?

1013


What is pl/sql table? Why it is used?

1079


What is a design view?

978


Does sql between include endpoints?

1060


How can use stored procedures in sql?

1191


What is dml with example?

1155


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1134


Define select, insert, create, delete, update, drop keywords

1094


How do I create a sql script?

1142