Hi All,
I have a requirement, where I have to insert records into a temp table via a function. This function returns a table type object. The reason, I have to use functions is because the application which we are using doesn't support calling procedures. So, in order to make the function enable DML, I'm planning to use Autonomous_Transaction. The data will be inserted into the temp table.
Please note, this is a standalone function (meaning it is not calling any other functions/procedures etc in it,), and it only inserts data into temp table which gets deleted after the session.
Are there are any issues in using Autonomous_Transaction in a function? Like performance issue/dead-lock etc?
Thanks.