I am getting "ORA-02089: COMMIT is not allowed in a subordinate session" when I used below query in Stored procedure in Oracle.
execute immediate 'truncate table xxx';
Actually, when I ran stored procedure with above query in SQL developer, it is working fine. But, when I triggered from Java code, it is giving "ORA-02089: COMMIT is not allowed in a subordinate session" issue.
Can someone help me on this?