Calling procedures from PL/SQl functions (called from a SQL stmt)

Hi,

This is a bit convoluted but:

• I am using an application that can only execute SQL statements
• The SQL statement can call user defined functions
• The function in turn can call procedures

However, I noticed that the procedure that is called cannot do any updates, inserts or deletes. Is there a trick to get past this ?

select myfunc(parent) from dual;

Function myfunc
.....
bom_exploder(parent) <---- this proc does a BOM explosion which inserts

records into a temp table.

End;

Thanks,
AR Received on Fri Jan 01 1999 - 11:21:44 CST