I have a scenario, where I have to call a procedure within a function.
Procedure has DML's in it, which at the end inserts into a table.
After procedure is run, based on data changed we select values for function.
As we can't have DML in a function, I tried to add pragma autonomous_transaction in procedure code.
However, I still can't select from that function.
If we use it in a select statement (select function from dual),I get the result as null ,even if it does everything (DML from proc call's).
Is there any way I can still invoke it from a select statement?
Begin
Function
Procedure
select ....
End