Interested to Buy Any Domain ? << Click Here >> for more details...
How can I pass the inner procedure value to outer
procedure ?
- 2 Answers
- 7681 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 does postgresql compare to "nosql"?
What is t-sql? : Transact sql
How do I run a sql query in pgadmin 4?
What is primary key sql?
What is a crud api?
Find out the 3rd highest salary?
51 Answers BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,
How to raise user-defined exception with custom sqlerrm ?
Does a join table need a primary key?
How does cross join work?
Is sql easier than java?
What is union, minus and interact commands?
why should required for Indexed by table in pl/sql
-
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)
