Re: informix and oracle

In article <74jokv$2hs$1@news.xmission.com>, Sandra Ward <sandraw@peregrine.ie> wrote: > > Hi all, > just regarding my recent query - I want to make an amendment . = > Apparently, what we really need to do is fire an informix stored = > procedure from SQL*Plus or a pl/sql stored procedure if possible. Any = > ideas on this. > Thanks > Sandra > > If you can execute a system command from sqlplus you could retreive the data through an unload. This would produce an ascii file that would have the fields delimited with a "|". the command to extract the data on the informix side would look like this; isql dbname<<+ unload to /tmp/datafile select * from table where feild = value+ Then you would have to transfer the datafile to the oracle server and import the data. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own