Stored Procedure using JDBC lookup.

[former_member187587]

Did anyone tried this?

does the DataBaseAccessor supports this type of call?

cheers.

Nimrod.g

[prateek]

It could be used to insert the data into database but this approach is not recommended at all. It may lead to inconsistencies in database.

Regards,

Prateek

[Former Member]

Hi,

DatabaseAccessor does not support Stored Procedure...

Have a look:

http://help.sap.com/javadocs/NW04/current/pi/com/sap/aii/mapping/lookup/DataBaseAccessor.html

It say's: The accessor does not support transactional behaviour. Therefore, the method should not be used to execute insert or update statements on the database which can lead to inconsistencies. The accessor should only be used to read data from a database table.

Regards

[Former Member]

HI

SP works with JDBC lookup.

Thanks

Gaurav

[VijayKonam]

Why dont you try and tell us? As long as your stored procedure retuns a recordset.. it should be working..!!

VJ