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!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

This is the third post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

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