How to Call Store Proc from SQL server.?

[Former Member]

Dear Pals:

I used the BPM to call store proc.

I check with sxmb_moni and the process was finished.

But DB store proc never been excuted.

Not sure what's going on.

I want to call Store Proc without parameters or with parameters.

what's different between these two when i configure it in IR?

Regards

Jack Lee

[Former Member]

thanks for all your help.

[Former Member]

Hi Jack,

In your structure , try to give the stored procedure name in the place of 'procedure'

Execute_Statement = ' '

SPXXXXXXX

action = 'EXCUTE'

table = 'test'

KUNNR = 'Just a test string'

isInput = 'true'

type = 'VARCHAR'

If it doesn't works then try to give as

table = 'SPXXXXX'(your stored procedure name)

regards,

Pradeep

[Former Member]

Hi~

actually i trid this before..but no used.

Execute_Statement = ' '

sp_Jack_Test

action = 'EXCUTE'

KUNNR = 'Just a test string'

isInput = 'true'

type = 'VARCHAR'

but i'm not sure what is table for?

table = 'SPXXXXX'(your stored procedure name)

coz i saw others scenario data struture put the SP name in table field.

and the 'Procedure' node only name Procedure.

and them can run but i can't

regards,

Jack Lee

[Former Member]

HI,

Refer

follow the steps which are mentioned in SIVA MARANANI

stored procedures

by siva

jdbc sender(theory)

JDBC receiver

Thanks

Swarup

[Former Member]

hi...

i did the same thing as this sample below.

stored procedures

by siva

but my SP still not being trigger.

and I find out there is another way to call SP.

i mean different data type structure.

my setting like this. but the SP still not running...

can any one tell me what's going on?

Execute_Statement = ' '

Procedure = ' '

action = 'EXCUTE'

table = 'test'

KUNNR = 'Just a test string'

isInput = 'true'

type = 'VARCHAR'

[Former Member]

Hi,

1) First get the File data into BPM ( thru Sender File Adapter and the BPM is the Receiver)

2) then send the this file data into SQL server thru JDBC Reciever Adapter. Make it synchronus call. Once you get the response from the SQL server,

Your BPM steps will be

1) Recieve the file message

2) Send the file message into the JDBC system - Sync Send step

3) Get the response back and send this response into 2 ftp severs with 2 send steps.

Assuming Mapping is done outside the BPM.

Refer these blogs

Refer this Article

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5dfec390-0201-0010-b1b0-d8c7c160...

Regards,

Suryanarayana

[Former Member]

hi,

DB store proc never been excuted.

did you assign the EXECUTE To action atttribute check it out

regards

kummari

[Former Member]

yes....i did set the action=EXECUTE

and the test store proc i created has one parameter call KUNNR,and i also set a field call KUNNR as well.

and give a type attribute VARCHAR.

below is my store proc.

ALTER PROCEDURE [xiuser].[sp_Jack_Test]

@KUNNR varchar(200)='sp_Jack_Test'

AS

INSERT INTO test(KUNNR) VALUES(@KUNNR)

please tell me what kind of data type or structure should be.

and do i need to give the attribute isIput or isOutput = true or false?

Regards

Jack Lee