Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cross Platform Question
Ian Martin wrote:
> Does anyone reading this newsgroup have experience of initiating
> Mainframe procedures from an Oracle application on NT?
>
> We are currently developing an Oracle Database on Windows NT 4.0 and
> will be developing applications using Designer/Developer 2K, all of
> which is new to us. We have a requirement to trigger updates to
> CICS/VSAM files on an IBM Mainframe from these applications. The
> Mainframe updates do not necessarily have to be synchronised with
> Database updates, but any failures must be notified to the user via
> the
> Oracle applications.
>
> The most obvious answer seems to be using messaging software such as
> MQSeries (or MSMQ when developed?) but I have no idea as to whether
> these can be initiated from PL/SQL.
>
> Any experiences, views or comments would be gratefully received!
>
> --
You should consider the Oracle Procedural Gateway for APPC. This product runs on Windows/NT and allows your PL/SQL stored procedures to directly execute CICS transactions. If your VSAM files are defined as CICS recoverable resources then you will have two-phase commit between Oracle database updates and VSAM updates made via CICS transactions.
Visit http://www.oracle.com/products/gateways/html/procedural.html for more information.
Dave Dargo
ddargo_at_us.oracle.com
Received on Sat Aug 30 1997 - 00:00:00 CDT