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!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...