Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can an Oracle forms trigger update a SQLServer database table?
I guess, EXEC_SQL package can help in doing this. This package is
useful to connect to multilple databases and work with them from Oracle
Forms at the same time. With this package, you can connect to a Oracle
DB and get the data & then connect to SQLSERVER for other processing.
Some time back, i implemented the same with Oracle and MS Access. I
believe, there is some documentation (exec_sql.pdf) on this package in
demos directory.
Ram.
Paul Mitchell wrote:
> Hi,
> we have an Oracle forms application which needs to:
>
> 1) Select data from the Oracle Database.
>
> 2) Update a SQLServer table with that data.
>
> Can this be done directly from the trigger? If so how.
>
> If not what is the best way to do do it.
>
> Thanks in advance
>
> Paul Mitchell
> (remove the obvious to reply)
> paulm_at_nospamforme.gb.unisys.com
Received on Fri Nov 05 1999 - 07:46:29 CST