2 doubts in JDBC receiver

[Former Member]

HI,

1. While creating JDBC receiver data type, is it necessary to create a node "access"? The data is being inserted to DB using a stored procedure.

2. While using stored procedure to insert data in DB, for action attribute, I mapped EXECUTE. Is this correct or not.

Please share ur ideas.

Thanks,

Anil.

[Former Member · Accepted solution]

Hi

1) For stored procedures: action node in not required.

2) ACTION=EXECUTE for stored procedures.

Regards

Monika

[former_member200962]

I mapped EXECUTE

For stored procedure access node is not required.....and the action should be EXECUTE (as you have mapped)

Regards,

Abhishek.

[Shabarish_Nair]

>

> HI,
> 
> 1. While creating JDBC receiver data type, is it necessary to create a node "access"? The data is being inserted to DB using a stored procedure.
> 
> 2. While using stored procedure to insert data in DB, for action attribute, I mapped EXECUTE. Is this correct or not.
> 
> Please share ur ideas.
> 
> Thanks,
> Anil.

http://help.sap.com/saphelp_nwpi71/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

and

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417300)ID2044216150DB12410233167314983393End...

the above are excellent references. do make use of the same.

[Former Member]

Hi,

<access> is normally not needed for stored procs, as field for input/output are specified in <param> tags ... And the corresponding action is EXECUTE, you're right :

<StatementName5>

<storedProcedureName action=u201D EXECUTEu201D>

<table>realStoredProcedureeName</table>

<param1 [isInput=u201Dtrueu201D] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

Rgds

Chris