问题描述:

I have a SP that contain 3 input parameters and 4 outputs. inputs are NUMBER, the outputs one is a VARCHAR(descResponse) and the others are NUMBER.

In java, when I log the response:

logger.info("Out["+res.getCodResponse()+"]["+res.getDescResponse()+"]");

the print is:

Out[-1861][ORA-01861: literal does not match format string]

The map between java attributes with the SP parameters are the same type (number : Integer/Double, varchar: String).

the problem is when i use sql developer with the same parameters the response is ok. So i don't know if my WS is not working or the SP.

网友答案:

I hava distinct NLS settings on my sql devoloper than my DB so I change the NLS settings on my sql devoloper and i could detect the wrong date reference and fix it.

相关阅读:
Top