Interested to Buy Any Domain ? << Click Here >> for more details...
How can I pass the inner procedure value to outer
procedure ?
- 2 Answers
- 7588 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / som
1. Declare a variable as the datatype of the out parameter
of the inner procedure.
2. Call the inner procedure with the input/output
parameters- input parameter values and output parametr as
the variable declared.
3. After the inner procedure gets executed, the output
parameter will be accessible to the outer procedure.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / s.syam sundar
first declare a variable globaly
and next create inner procedure with in(if need or u can
set defult parameters) and out parameters
and next result of inner procedure is assigned to global
variable
and next in outer procedure u can get the result from global
variable
regads
S.syam sundar
| Is This Answer Correct ? | 1 Yes | 0 No |
How do I count records in sql?
Can sql developer connect to db2?
Explain ddl statements in pl/sql?
can a stored procedure call itself or recursive stored procedure? : Sql dba
Compare SQL and PL/SQL.
We have a CURSOR then we need BULK COLLECT?
What is mutating error?
What is a join query?
What is cascade in sql?
Explain how procedures and functions are called in a PL/SQL block ?
Is ms sql is free?
What are all ddl commands?
-
Oracle (3259) - 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)
