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;    ... View more

CREATE OR REPLACE PROCEDURE BSDTADLS.DMS_Main (Query_type in varchar, query_id in varchar, outResults out sys_refcursor ) as BEGIN IF upper(Query_type) = 'F' THEN open outResults for select distinct A.J_BACI, A.J_BAGT, A.J_BAZC, A.J_BBS_,A.J_BAJ8,A. J_BAO8, B.J_MBTI , c.J_NOHT from J_COM A left join J_CLMS B ON A.J_BACI = B.J_MBXI inner join J_CTUN c on A.J_crpi = c.J_NOGI and c.J_NOFC = '02' WHERE A.J_BACI = query_id; ELSIF upper(Query_type) = 'L' END IF ; END DMS_Main; open outResults for SELECT distinct A.J_MBTI ,A.J_MEE_,A.J_MCFC,A.J_MCI8,A.J_MCJ8,B.J_Mvfi, B.J_MVGT from J_CLMS A Inner join J_CUPI B ON A.J_MBWI = B.J_MVAI WHERE A.J_MBTI = query_id; ELSIF upper(Query_type) = 'A' ... View more

Hi Team i'm new in splunk,  I need to Monitor programs that executing on task manager whether is successfully or Not. I will appreciate to see a sample  Thanks!!   ... View more