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...

how do u call in & out parameters for stored procedures?

Answer Posted / sangeetha

create or replace procedure <pocedure_name>(x in number,y
out varchar) is begin
{
executable statements;

}
end <procedure_name>;

exec <procedure_name>(first_parameter,second_parameter);

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the best free sql database?

1054


How to look at the current sql*plus system settings?

1149


What is dml statement?

957


What is type and rowtype in pl sql?

1017


Explian rowid, rownum?

1012


What are primary key and foreign key and how they work?

978


What is sqlcontext?

1086


Why do we use function in pl sql?

1065


Give the order of sql select?

1137


How do I truncate a sql log file?

1075


Which are the different character-manipulation functions in sql?

1065


Why is sql*loader direct path so fast?

1104


How much does sql cost?

1007


What is sql architecture?

1049


Why join is faster than subquery?

1113