Hi all,
From SAP BODS script i am calling a Stored Procedure where with 5 parameters. Out of Which 1 parameter is Int Type. I have stored these values in a Global Variables and the Int type is declared as 'INT'. But while calling the SP i can see i...
Hi all,
I am trying to call a store procedure from SAP BODS . Below is the script that i am using
sql('LEX_AURORA_DS','exec .cdm_ops.PE_SYNC_DELETE');
the stored proc is written in mysql developer
<<
DELIMITER $$
CREATE DEFINER=`cdm_ds`@`...
Hi all,
I am trying to call a store procedure from SAP BODS . Below is the script that i am using
sql('D365ReplicaDB','exec hsl.usp_LEGACY_REPORTING_FEED_BeginProcess');
the stored proc is written in mysql developer
<<
DELIMITER $$
CREA...
Hi All,
I am working with a Stored Proc which is like below
CREATE PROCEDURE hsl.usp_LEGACY_REPORTING_FEED_BeginProcess
(
@inExecutionMode nvarchar(50) = null
)
i want to execute this store procedure in BODS with @inExecutionMode this ...
joseph_muiruri please find the screenshot as you can see the integer 2 is coming in quotes . I tried replace_substr before hand even after this the parameter is getting passed as string in the Stored Procedure. I don't have write access in back end...
joseph_muiruri is the below syntax is correct to call the sp with parameters which i am storing in global variables.sql('LEX_AURORA_DS','CALL cdm_ops.PE_SYNC_DELETE(\'$GV_reference_record_id\',\'$GV_attribute_name\',\'$GV_attribute_to_value\',\'$GV_...
i tried with the below codesql('LEX_AURORA_DS','CALL cdm_ops.PE_SYNC_DELETE(123456,"FI","John Doe","Customers",89012,"Orders","CustomerID","OrderDetails","OrderID")');even with this i am getting error likeas you can see i am passing 9 parameters that...
