SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can oracle PLSQL program communicate to VFP (Visual Foxpro) Database.

rkpMar 3 2010 — edited Mar 3 2010

Hello All,

I am using dataabse 9i in windows 2003 - 32 bit server.

I have couple of application in forms and Visual Foxpro(VFP). The VFP program can commucate to the oracle database.

when I am inserting/updating/deleting some data to the oracle database it should insert/update/delete the record in VFP database.

For this I have created triggers in the oracle tables so that when DML oreration are happening in the database it can triggered and same time the VFP tables can be updated by the oracle triggers. But my problem is I am not able to connect to the VFP table from the Oracle.

Any body have any idea on it, Please suggest.

Thanks,
SUN

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2010

Added on Mar 3 2010

1 comment

597 views