I am trying to execute a stored procedure using oracle odbctest 32 and it keeps giving me error:
"Invalid SQL Statement"
, why do I have to change the syntax for odbc test, this runs fine through worksheet, but it was failing thro' our application which uses odbc so I was trying to filter causes by running this using odbc test. Any idea how to do this ?
execute pr_authpto1 (552, 570, '2001-07-22 00:00:00', '2001-07-28 00:00:00', 0.00, 8.00, 8.00, 8.00, 8.00, 8.00, 0.00);

Dates passed in to this procedure are as varchar2 and not date datatype....

thanks
Sonali