All Apps and Add-ons

Sequential queries in DB connect

fralcalde
Explorer

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.

 

Labels (3)
Tags (3)
0 Karma
*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!

Review:





Or Learn More in Our Blog >>