It works fine if I execute the procedure in SQL Plus. It also works if I execute the following code in a command window in PL/SQL Devloper:
EXEC DBMS_PROFILER.START_PROFILER(run_comment => 'Test');
EXEC MyProcedureUsingDistributedTransaction();
ROLLBACK;
EXEC DBMS_PROFILER.STOP_PROFILER();
I am referencing a table via a database link. It seems there is a problem with using the profiler (in PL/SQL Developer) while executing a prodedure that initiates a distrubuted transaction. The autonomous transaction issued by the profiler is not allowed. If I create a script where I start...
I am using version 5.1.4.728 of PL/SQL Developer and I am having problems with the profiler. After running my test script, I receive the following error:
Error stopping Profiler
Result = 2
The DBMS_PROFILER package has been installed on the server and my account has access to it. I was...