topic Re: Why am I getting errors writing a query after installing Splunk DB Connect and connecting to Oracle database? in Splunk Search

Why am I getting errors writing a query after installing Splunk DB Connect and connecting to Oracle database?

gajananh999 — Tue, 26 Aug 2014 11:40:28 GMT

Hello,

I have installed splunk db connnect app and connecting to oracle database i am trying to write query
select * from etl_job;
i am getting this error can anyone please help me

command="dbquery", A database error occurred: ORA-00911: invalid character

Thank

Gajanan Hiorji

Re: Why am I getting errors writing a query after installing Splunk DB Connect and connecting to Oracle database?

Ayn — Tue, 26 Aug 2014 11:54:32 GMT

I imagine the semicolon (;) shouldn't be there?

Re: Why am I getting errors writing a query after installing Splunk DB Connect and connecting to Oracle database?

gajananh999 — Tue, 26 Aug 2014 12:29:48 GMT

I have tried that also but no luck here is the another error
command="dbquery", A database error occurred: ORA-00923: FROM keyword not found where expected

Re: Why am I getting errors writing a query after installing Splunk DB Connect and connecting to Oracle database?

Ayn — Tue, 26 Aug 2014 12:47:08 GMT

Exactly how does your complete search string in Splunk look?

Re: Why am I getting errors writing a query after installing Splunk DB Connect and connecting to Oracle database?

gajananh999 — Mon, 28 Sep 2020 17:24:21 GMT

I am doing a database query in database Query tab. and my query is "select process_flag from etl_job"

Re: Why am I getting errors writing a query after installing Splunk DB Connect and connecting to Oracle database?

gaikarmayur — Thu, 23 Nov 2017 11:56:37 GMT

use below format

| dbxquery query="(your db query)" connection="(nameof DB Connection)"

use command dbxquery remove ( ,) after dbxquery