Store procedure will return a value?

Answer Posted / raji_4u

stored procedure can not return a value using the return
statement. though a stored procedure can contain a return
statement but should not return a value.simply "return".

in a manner,stored procedure can return values to the
calling block through the OUT,INOUT parameter modes.

Is This Answer Correct ?    20 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define union, minus, union all, intersect ?

556


Can you join a table to itself?

544


Why do we go for stored procedures?

524


Can a foreign key have a different name?

515


Explain table and field in sql?

585






How to read/write files from pl/sql?

582


what are the different functions in sorting an array? : Sql dba

583


What are different types of statements supported by sql?

609


What is sql in java?

545


how mysql optimizes distinct? : Sql dba

555


How do you optimize a query?

538


What is a call statement? Explain with an example.

551


What is the difference between nested table and varray?

523


How to take user input in pl sql?

705


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

527