>I am trying to execute a server side ORACLE procedure and pass it paramters. It is a simple insert statement. I am using SQLEXEC(). When I build the insert statement as:
> SQLEXEC(gnConnHandle,'insert into gps_mtr values (0)')
> ** this works correctly and a record is inserted.
>
>I have a ORACLE procedure name gps_insert stored in the same scheme as the table and used by the ODBC connection.
>
>The SQLEXEC statement for the procedure is:
>
> SQLEXEC(gnConnHandle,'execute gps_insert')
>
>This statement return an ORACLE ORA-00900 error. Invalid SQL statement.
>
>From ORACLE SQL*Plus I can connect as the user and issue the
> execute gps_insert;
>
>This works correclty.
>
>Result:
> I can execute the procedure from ORACLE SQL*Plus
> I am connecting in correct scheme in VFP ODBC
> I can execute sql statements such as UPDATE,INSERT
>
>PROBLEM:
> I CANNOT EXECUTE A ORACLE STORED PROCEDURE!!!
>
>ANY suggestion?
I've no experiance of Oracle, but from my SQL Server experiance, I'd say take the brackets out.
Ian
regards
Ian