topic Re: Run Oracle PL/SQL script with input and output parameters from DB Connect in Getting Data In

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

altink — Sat, 05 Mar 2022 18:13:39 GMT

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

Re: Run Oracle PL/SQL script with input and output parameters from DB Connect

venkatasri — Wed, 03 Nov 2021 00:43:45 GMT

Hi @altink

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

Re: Run Oracle PL/SQL script with input and output parameters from DB Connect

altink — Sat, 05 Mar 2022 17:40:00 GMT

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

Re: Run Oracle PL/SQL script with input and output parameters from DB Connect

venkatasri — Thu, 04 Nov 2021 00:18:49 GMT

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

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

Re: Run Oracle PL/SQL script with input and output parameters from DB Connect

altink — Fri, 05 Nov 2021 20:44:58 GMT

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

Re: Run Oracle PL/SQL script with input and output parameters from DB Connect

altink — Mon, 15 Nov 2021 20:38:25 GMT

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/