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
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...