Store procedure will return a value?

Answers were Sorted based on User's Feedback



Store procedure will return a value?..

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

Store procedure will return a value?..

Answer / neel armstrong

Stored procedure will return the values based on the OUT
parameters

Is This Answer Correct ?    12 Yes 1 No

Store procedure will return a value?..

Answer / sravanthi280

A procedure need not return a value always.

Is This Answer Correct ?    4 Yes 0 No

Store procedure will return a value?..

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

Post New Answer

More SQL PLSQL Interview Questions

How do I view tables in sql developer?

0 Answers  


What are all the ddl commands?

0 Answers  


What is meaning of <> in sql?

0 Answers  


how to retrive only second row from table?

31 Answers   IBM,


What is the difference between left join and left outer join?

1 Answers  






what is meant by urlencode and urldocode? : Sql dba

0 Answers  


What is sql lookup?

0 Answers  


What is sqlcommand?

0 Answers  


what are the types of subquery? : Sql dba

0 Answers  


How do you retrieve the last N records from a table?

10 Answers  


Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  


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.

4 Answers  


Categories