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

Answer Posted / mohana sundaram

create or replace procedure p_name(p_no in out number)
is begin
{
executable statement
}
end p_name;
/

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's the difference between inner join and left join?

606


What is dml and ddl?

609


What are the types pl/sql code blocks?

700


Is pl sql different from sql?

614


How to read/write files from pl/sql?

666






Why is sharding used?

635


What is sql trigger example?

644


What is audit logout in sql profiler?

671


What are different categories of sql commands?

719


Which sql statement is used to delete data from a database?

559


what is 'mysqld'? : Sql dba

625


How do I save a stored procedure?

618


what is a join? : Sql dba

666


What is gpt format?

604


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

762