Execute call procedure using Execute callable statement
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
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?