-
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
-
ODBCTEST32 is a simple tool that only accept sql statements and not PLSql statements.
It is ment to test if you are using the right odbc driver and not if you are using the right statement..
Grtx,
Jeroen
-
What do you think about this statement, is it correct for odbc test..
BEGIN pr_authpto3 (552, 570, '2001-07-22', '2001-07-28', 0.00, 8.00, 8.00, 8.00, 8.00, 8.00, 0.00); END;
