DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ODBC test 32 error

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    318
    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
    Sonali

  2. #2
    Join Date
    Jul 2001
    Location
    Netherlands (Utrecht)
    Posts
    21
    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
    J.Jongman - DBA

  3. #3
    Join Date
    Jan 2001
    Posts
    318
    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;

    Sonali

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width