Hello, We have an oracle database schema with mutiple tables. All these tables have a column called idversion, and each has a view that shows only the version that was specified into the table sesio_te. So the expected way to work with these tables is to INSERT INTO "XXXX"."SESIO_TE" (sessionvalue, usuario, version_actual) VALUES ('test version', 'splunk', 21) and then SELECT * FROM "XXXX"."PRESU_IN_AUD_VI" WHERE ... What I want to achieve is a dashboard that shows some data in these tables on demand from the DB. Not indexed data. So if I have multiple users watching this dashboard and they are asking for different versions I need to update the version before quering the views. But if you try to do INSERT INTO "XXXX"."SESIO_TE" (sessionvalue, usuario, version_actual) VALUES ('test version', 'splunk', 21);
SELECT * FROM "XXXX"."PRESU_IN" WHERE ... ; in the same dbxquery command it fails saying java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended. Any ideas how to do this? Thank you in advance.
... View more