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.