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 prepared statement in sql?

1044


What is auto increment in sql?

1113


What is rownum and rowid?

1027


Write the command to remove all players named sachin from the players table.

1175


Is sql port 1433 encrypted?

1017


What is join view in sql?

942


How to start the command-line sql*plus?

1046


Is inner join faster than left join?

1185


what are the different tables present in mysql? : Sql dba

980


is it possible to pass an object or table to a procedure as an argument?

1123


What is rownum?

972


Which one is faster ienumerable or iqueryable?

930


How can get second highest salary in sql?

979


how to select unique records from a table? : Sql dba

1105


What is the basic structure of an sql?

1098