Calling Stored Procedure not working

Question

load( 
 local!spData: executestoredprocedure( dataSourceName: "jdbc/TestDS", procedureName: "TEST_SP", inputs :{{name: "P_ID", value: 135},{name: "S_ID", value: 4}} ) , 
 a!formLayout( label: "Test", firstColumnContents: { a!textField( local!spData.data ) }, validations: {} ) 
 )

nafisk0001 · Accepted Answer

Hi Sauravk, 
 
Could you please provide more details like what is the problem or any error. 
 
Also could you please try using fn!executestoredprocedure. 
 
Actually, even for me executestoredprocedure was not working but when I gave " fn! ", it went fine. 
 
I am not sure what difference fn! will make but you can give it try.

bhanuprakashm · Answer

Hi Sauravk,

Can you please call executestoredprocedure funtion in saveinto of any componet. it will work. 
 
Regards, 
Bhanu.

srikanthm0004 · Answer

Can you please post the error you are getting when you are trying to run the SP. Please try with fn!excecuteStoreProcedure and Execute the SP in DB to check its functionality.