Store procedure will return a value?
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
parameters
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 |
How do I view tables in sql developer?
What are all the ddl commands?
What is meaning of <> in sql?
how to retrive only second row from table?
What is the difference between left join and left outer join?
what is meant by urlencode and urldocode? : Sql dba
What is sql lookup?
What is sqlcommand?
what are the types of subquery? : Sql dba
How do you retrieve the last N records from a table?
Can a view be updated/inserted/deleted?If Yes under what conditions?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.