How to invoke .xsjs service via stored procedure

[former_member273900]

Hi,

Does anyone knows how to invoke .xsjs service from stored procedure? I have a service which I need to call from a stored procedure and pass parameter like company code. Is it feasible to do?

Regards,

Kam

[mantrishekar]

Hi,

Below is the piece of code which is used to call Stored Procedure from XSJS Service.

query = 'CALL SYSTEM.getAllDetails3(?,?,?,?,?,?,?)';

Here getDetails is my procedure and i have 7 inputs for my storedprocedure.

Regards,

Shekar.

[former_member273900]

Hi Shekar,

The scenario you described is to call stored procedure from XSJS. My scenario is exactly opposite whereby I want to call XSJS service from stored procedure.

Regards,

Kam

[mantrishekar]

Hi,

What is your main objective?Are you using any front end UI?