VB/Oracle ADO Error: -2147217900 ORA-00900 Invalid SQL statement
Posted on 2003-03-17
We have a VB project that was created by someone who is no longer with the company. His original code called an Oracle stored procedure that deleted data from Table A.
With our project expanding, a trigger has been added on the oracle side to that table. When the stored procedure deleted a record from Table A, a record from Table B also has to be deleted. The trigger utilizes the database link object. So, in the trigger, we have something like this:
Delete from Table B@dblink select * from Table A......
Now, when we run the VB project, we are receiving the below error message:
Error: -2147217900 ORA-00900 Invalid SQL statement
Somehow the dblink code in the trigger is causing this error and I am not sure why because ADO executes the stored procedure. The trigger is hanging off of the table being referenced in the stored procedure. The VB code is not passing the dblink code.
Anyone seen this before? Any thoughts would be appreciated. Thanks