Splunk Search

Problem executing ORACLE subquery in DB Connect...

Adam_Marx
Explorer

I'm running into a problem when executing a subquery in DB Connect.

When the query is executing through SQL Developer it executes fine but when executed in SQL Explorer in DB Connect I get an error message "java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis".

I've narrowed it down to essentially the subquery portion of the query... is this a known issue, any work arounds?

     SELECT * FROM (
       SELECT c."Name" AS ItemName, LTRIM(p."Name",'_') AS ItemProperty, TO_CHAR(p."Value") AS Value, 
            CASE c."Type"  
                    WHEN 2 THEN 'View'
                    WHEN 8 THEN 'Canvas'
             END AS Type
       FROM "CATALOGITEM" c, "PROPERTY" p
       WHERE 
       p."ItemID" = c."ID"
       AND LENGTH(p."Value") > 0        --check for blank CLOB
        AND c."Name" = 'AL'
       AND c."Type" = 2
            OR c."Type" = 8 
       AND p."Name" = 'DateModified'
             OR p."Name" = 'DateAccessed'
             OR p."Name" = 'UserAccessed'
             OR p."Name" = 'AccessCount'
             OR p."Name" = 'Database'
) Tmp
Tags (1)
0 Karma

Adam_Marx
Explorer

Just a follow up in case someone else runs into this.. removing the comment "--check for blank CLOB" fixed the issue.

AND LENGTH(p."Value") > 0 --check for blank CLOB

Adam,

0 Karma

p_gurav
Champion
0 Karma

Adam_Marx
Explorer

The query executes fine in ORACLE so I'm not understanding the error

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

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

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...