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 / susila

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

}
end <procedure_name>;

exec <procedure_name>(10,y);

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between table function and pipelined function?

967


Is sqlite good enough for production?

948


Why do you partition data?

965


what is a constraint? : Sql dba

1105


What is scope of pl sql developer in future?

949


Can procedure in package be overloaded?

1028


What are the features of pl sql?

1013


How to return an array from java to pl/sql?

1061


how do you know if your mysql server is alive? : Sql dba

1024


What is percent sign in sql?

1213


What are inner outer left and right joins in sql?

964


What is sql and also describe types of sql statements?

994


what is uncommittable transactions? : Transact sql

953


What are keys in sql?

944


What is dba in sql? : SQL DBA

997