Hi @Anonymous ,
I have made a test on my side, and don't have the issue that you mentioned.
Based on the issue that you mentioned, I think this issue may be related to your Oracle table rather than PowerApps itself.
The ORA-00604 error occurs while processing a recursive SQL statement. A recursive SQL statement is a statement that is applied to internal dictionary tables.
Please check and see if the following blog would help in your scenario:
https://www.tekstream.com/oracle-error-messages/ora-00604-error-at-recursive-sql-level-1/
Do you define a trigger within your Oracle DB or the specific table within your Oracle DB? If yes, please consider take a try to remove the trigger from your Oracle DB or Oracle table, then re-create a connection to your Oracle data source from your app, check if the issue is solved.
Note: Currently, within PowerApps, we could not create a connection to a Oracle data source which has configured Trigger within it.
In addition, you could also consider take a try to re-create a new database within your Oracle, then create a new table within it. Re-create a new app, then create a connection to your new Oracle DB, check if the issue is solved.
Best regards,
