I have a procedure in a procedure. The inner procedure
contains out parameter. How I can call the inner procedure
in the out procedure and send the inner procedure parameter
value(out parameter value) into out procedure?
Answers were Sorted based on User's Feedback
Answer / naren
i think by this code u may understand
create or replace procedure p1(a out number) as
begin
a:=10;
end;
/
create or replace procedure p2 as
b number;
begin
p1(b);
dbms_output.put_line('value of inner pro paramter is:'||b);
end;
/
this code work successfully and pass a(out param of p1)
into b(variable of p2).
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / bhavani sharan singh
Hi,
If i am correctly understand your question then solution is
given below,
Suppose the Inner procedure is
Prc_inner(pov_out_param OUT varchar2 )
and Outer Procedure is
Prc_outer( pov_out_paaram2 OUT varchar2)
as
lv_out_param VARCHAR2(SIZE)
begin
Prc_inner(lv_out_param );
--Assiging the inner value to outer procedure paramaeter
pov_out_param := lv_out_param ;
EXCEPTIOn
when others then
NULL;
END
Is This Answer Correct ? | 1 Yes | 0 No |
Does inner join remove duplicates?
Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?
What is an invalid partition table?
Advantages and disadvantages of stored procedure?
What is rownum?
Does sql require a server?
Is id a reserved word in sql?
how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing
how to convert character strings to numeric values? : Sql dba
SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.
What is procedure explain with example?
How many clustered indexes can you have?