Splunk Search

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

gajananh999
Contributor

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

Ayn
Legend

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

0 Karma

gajananh999
Contributor

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

0 Karma

gaikarmayur
New Member

use below format

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

use command dbxquery remove ( ,) after dbxquery

0 Karma

Ayn
Legend

Exactly how does your complete search string in Splunk look?

0 Karma

gajananh999
Contributor

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

0 Karma
Get Updates on the Splunk Community!

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...

From Alert to Resolution: How Splunk Observability Helps SREs Navigate Critical ...

It's 3:17 AM, and your phone buzzes with an urgent alert. Wire transfer processing times have spiked, and ...