Getting Data In

Oracle anonymous PL/SQL block with input and output parameters from Splunk DB Connect

altink
Builder

Can DB Connect execute an Oracle anonymous PL/SQL block, with input parameters, and get the output parameters (for indexing)?

An anonymous PL/SQL block - and not a stored procedure. The later must first be created on the Oracle server. The anonymous PL/SQL block exists on the client side - Splunk - only.

Is this possible with Splunk DB Connect and Oracle jdbc ?

ora_script.png

 



best regards
Altin

0 Karma

altink
Builder

17) When is a declare statement required?

DECLARE statement is used by PL SQL anonymous blocks such as with stand alone, non-stored procedures. If it is used, it must come first in a stand alone file.

https://yoursbhasoracleguide.blogspot.com/2020/ 

0 Karma

venkatasri
SplunkTrust
SplunkTrust
0 Karma

altink
Builder

Hi @venkatasri 

The link's topic talks about running statements (single commands) and stored procedures. The later is something stored inside Oracle database.

I am asking for running an Anonymous PL/SQL block (script), which is not a stored procedure and does not exist inside Oracle.

best regards
altin

0 Karma

venkatasri
SplunkTrust
SplunkTrust

What do you mean by PL/SQL script  / which DB ?

the DB could be anything as long as DBConnect supports it.

0 Karma

altink
Builder

I am not talking about the DB being anything, but for Oracle only.

PL/SQL script differs from the Stored Procedure because the later must be created as persistent object (procedure/function/package) inside Oracle, while the prior (script) is not, and exists on client side (this time Splunk) only.

The documentation talks on running (single) SQL commands or calling Procedures only

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 ...