I am creating DB inputs in the Splunk DB Connector 3.0.2. I would like to run 2 sql statements or possibly more in some instances . When I use a semi column to separate in the Choose and Preview with the editor version sql I get
java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option
Here is an example:
alter session set currentschema=test;
Any help appreciated.
Thanks. That is what I have done so maybe this is a bad example. I guess the ultimate question is does it support multiple sql statements or do I have to combine into one? I have looked for the answer but did not find anything in the docs.
In your example why not just use:
Some databases might allow multiple queries via JDBC statements (where JDBC statements are what the DB input is really running) but by default most will not.