Re: Oracle with informix - please help

There are two hopes - Bob & No !! What GUI are you using ?? Delphi & VB should be able to execute a stored procedure based on the datasource you create within your app. As far as getting a pl/sql stored procedure from Oracle talking to an Informix database - I can't think of a decent way of doing it. You could write a SPL routine on Informix to unload the information you require to a text file and then write the PL/SQL routine to update it accordingly in new tables within Oracle. Sean Sandra Ward wrote in message <01be2365$62bd8850$15eb78c1@swepc18>... >Is there any way possible for a pl/sql stored procedure to somehow access >data from an informix table. We are running a GUI application which >interacts with an oracle database on NT and we now need to also take data >from an informix table at the oracle stored procedure level. I need urgent >advice on this. >TIA >Sandra >