Calling a query or proc in splunk

[mlindokuhle]

Hi all, I'm testing a connection that i have created using orcale db acccount, so i need to call or execute this query below.

so that i will be able to create a dashboard.

DECLARE 
v_cursor SYS_REFCURSOR; 
faID varchar(12);
despriction varchar(50);
currency varchar(3);
amount number ;
startD varchar(8);
endD varchar(8);
loID varchar (12);
Unit varchar(50);
begin 

TM_MAIN('B','00024657', v_cursor);
 
LOOP 
FETCH v_cursor 
INTO facility_ID,despriction, currency , amount , startD, endD ,loId, Unit; 
EXIT WHEN v_cursor%NOTFOUND; 
DBMS_OUTPUT.PUT_LINE(faID ||  ' | ' || despriction || '  ' || currency || '  ' || amount || ' ' || startD || ' ' || endD || ' ' || loId || ' | ' || glUnit );

END LOOP; 
CLOSE v_cursor; 
END;