Execute call procedure using Execute callable statement

0
Hi team! I want to call a stored procedure from our external database “sybase” and I used the Database connector module and “Execute callable statement” action. after many tests, I end up with the below error. com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.sql.SQLException: There is no host variable corresponding to the one specified by the PARAM datastream. This means that this variable '@as_user_id' was not used in the preceding DECLARE CURSOR or SQL command.     at MyFirstModule.GetiMalProcedure (JavaAction : 'Execute callable statement')   The below is the parameter that I’m having error on it   The below is statement setup   Thanks in advance for your support
asked
1 answers
0

Would you mind posting your set-up as a screenshot? I did the “execute callable statement”. Do I need the Position attribute in the Parameter objects? 

I get this Error now: “...SQLServerException: String or binary data would be truncated.” Any idea?

answered