I'm having trouble returning the results of the following query, where I put the & month variable, if I put '01 -sep-2017 'would bring the results I need, but in the dialog box I wanted the user is typed with the patterns used for date, being the correct '01 / 09/2017 ', however entering that date is presented the error ORA-01858: a non-numeric character was found where numeric was expected
Select a.pro_st_alternativo,
a.pro_st_descricao,
mgadm.adm_pck_estoque.F_SALDO_QTDE(20,21,a.pro_pad_in_codigo,a.pro_in_codigo,1,null,null,to_char(to_date(&mes), 'dd/mm/yyyy'),'AN')Saldo_mes,
a.uni_st_unidade,
a.pro_bo_controlalotes,
a.pro_st_cestoque,
a.pro_st_defitem,
A.PRO_CH_DEFFISCALITEM,
A.PRO_ST_ORIGEM
From mgadm.est_produtos a
Where A.PRO_PAD_IN_CODIGO = 4;