how to get explain plan from pl/sql function call?
0
votes
1
answer
150
views
consider this working pl/sql block:
declare
o_result boolean;
io_error varchar2(30000);
tab1 someTable1;
tab2 someTable2;
begin
tab1(1).col1 := 'str';
tab1(1).col2 := 1;
tab2(1).col1 := 'str';
tab2(1).col2 := 0.5;
tab2(1).col3 := 6;
o_result := some_function(io_error, 2,'str', 5, to_date('01-JAN-23','DD-MON-YY'), to_date('31-DEC-23','DD-MON-YY'), 4, 'A', tab1, tab2, 'str', 'B', 'str');
end;
how to get the explain plan for pl/sql function calls where its inputs are dates and custom types?
Asked by gabriel119435
(119 rep)
Feb 20, 2024, 07:44 PM
Last activity: Jul 18, 2025, 02:02 PM
Last activity: Jul 18, 2025, 02:02 PM