Interested to Buy Any Domain ? << Click Here >> for more details...
Store procedure will return a value?
- 4 Answers
- 11469 Views
- eMids, I also Faced
- E-Mail Answers
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 |
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
How do I install sql?
What are different types of statements supported by sql?
What is ttitle and btitle?
What is input buffer in sql*plus?
What are the types of index in sql?
What is the difference between nvl function, ifnull function, and isnull function?
Can two tables have same primary key?
What do you understand by case manipulation functions?
What is the advantage of index in sql?
How can we link a sql database to an existing android app?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
