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

What are different types of keys?

1096


How to move files from one directory to another in pl sql?

1184


how to rename an existing column in a table? : Sql dba

1015


How do I run pl sql in sql developer?

1110


How to convert comma separated string to array in pl/sql?

1173


What is the size of partition table?

1041


Why is the cursor important?

1035


What is multiple columns?

1060


How to make a copy values from one column to another in sql?

1030


how to use myisamchk to check or repair myisam tables? : Sql dba

966


Explain the working of foreign key?

1058


What are the events on which a database trigger can be based?

1179


How do you optimize a stored procedure query?

995


Differentiate between pl/sql and sql?

1143


What is a table partition?

1122