Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Connect to Informix

Re: Connect to Informix

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 15 Apr 2005 13:38:24 +0200
Message-ID: <d3o8sp$tk4$1@news5.zwoll1.ov.home.nl>


Harish Vamsi Mohan via DBMonster.com wrote:
> Hello,
>
> How can we connect to an Informix database from a Oracle Stored Procedure?
>
> If it is possible, can we a get a sample code?
>
> Any help will be appreciated.
>
>
> Thanks and Regards,
> Vamsi Mohan Harish
>

No.

In fact - you cannot connect from a Stored Procedure to anything. And if you can (using dynamic sql), you should not.

You connect Oracle, and access Informix (data) though a database link, which is part of the query, which may be in a stored procedure. Or function. Preferably packaged.

Look up database link, and ask detailed questions later.

-- 
Regards,
Frank van Bortel
Received on Fri Apr 15 2005 - 06:38:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US