Archive
Highlighted

Splunk - DB Connect 3.1.3 EXEC Stored Procedure

New Member

Hello to you,

I have been trying for a few days to run a store procedure with DB Connect 3.1.3.

I'm trying with dbxquery:

     | dbxquery connection = TEST_CONNECT procedure = "{call ps_store_procedure_name ('2018-01-01', '2018-04-30')}"

Unfortunately it still tells me no results found

I also tried with an INPUT directly in data lab with the following command

      SET NOCOUNT ON
      EXEC STOREPROCEDURE_NAME

I have values that appear but they are wrong

Do you have any ideas ?

thank you very much

0 Karma
Highlighted

Re: Splunk - DB Connect 3.1.3 EXEC Stored Procedure

New Member

without "SET NOCOUNT ON" it does not work

0 Karma

Re: Splunk - DB Connect 3.1.3 EXEC Stored Procedure

New Member

Anybody have a solution ?

0 Karma