Answers were Sorted based on User's Feedback
Answer / 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|
Answer / neel armstrong
Stored procedure will return the values based on the OUT
|Is This Answer Correct ?||12 Yes||1 No|
Answer / sravanthi280
A procedure need not return a value always.
|Is This Answer Correct ?||4 Yes||0 No|
Answer / adarsh katiyar
Iin a manner,stored procedure can return values to the block when found any error in the block. Then block exit out and stop all transction immediate.
|Is This Answer Correct ?||0 Yes||0 No|
what are the differences between binary and varbinary? : Sql dba
What is a rank in sql?
How can we implement rollback or commit statement in a trigger?
How can a function retun more than one value in oracle with proper example?
What are the types of operators available in sql?
Can we use more than one null value for unique key?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
Why is pl sql needed?
how to select unique records from a table? : Sql dba
Can function return multiple values in sql?
what is the sql query to display current date? : Sql dba
Explain unique key in sql.