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

[altink]

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 ?

best regards
Altin

[altink]

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/ 

[venkatasri]

Hi @altink 

This link would help - https://docs.splunk.com/Documentation/DBX/3.6.0/DeployDBX/Commands

[altink]

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

[venkatasri]

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

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

[altink]

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