Yes Below are my parameters list, the usecase is Activity Log & Change Log of my application. StoredProcedureQuery storedProcedure = manager.createStoredProcedureQuery("insertActivityLog") .registerStoredProcedureParameter(1,String.class,ParameterMode.IN) .registerStoredProcedureParameter(2,String.class,ParameterMode.IN) .registerStoredProcedureParameter(3,Date.class,ParameterMode.IN) .registerStoredProcedureParameter(4,String.class,ParameterMode.IN) .registerStoredProcedureParameter(5,String.class,ParameterMode.IN) .registerStoredProcedureParameter(6,String.class,ParameterMode.IN) .registerStoredProcedureParameter(7,String.class,ParameterMode.IN) .registerStoredProcedureParameter(8,String.class,ParameterMode.IN); storedProcedure.setParameter(1,userId()) .setParameter(2,getActivity()) .setParameter(3,getActivityTime()) .setParameter(4,getStatus()) .setParameter(5,getModule()) .setParameter(6,getSubModule()) .setParameter(7,getSource()) .setParameter(8,getMethod()); storedProcedure.execute(); My SP -> INSERT INTO activity_log (officer_serial_no ,activity_type ,activity_done_on ,status ,module_id ,sub_module_id ,source) VALUES (@officer_serial_no,@activity_type,@activity_done_on,@status, (SELECT module_id from module_info where module_name= substring(@module,charindex(@module, module_name),datalength(module_name)+1)), (SELECT sub_module_id from sub_module_info where sub_module_url=@sub_module and sub_module_method=@method), (SELECT item_id from managed_list_items where item_value=@source)) In This we are not expecting any out parameters. My SP does insert data. |