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: Get Data from SqlServer via HTTP

Re: Get Data from SqlServer via HTTP

From: klabu <klabu_at__oracle_dot_com>
Date: Mon, 20 Nov 2006 17:23:46 -0500
Message-ID: <12m4anjaips42e6@corp.supernews.com>


> Hi,
>
> That'll should work assuming the result set in question is reacheable
> via HTTP (i.e.,exposed as a Web component). Fwiw, I have described in
> my book a working example of how to get data from SqlServer using JDBC
> from within the Oracle database; the JDBC calls can be wrapped for use
> by SQL or PL/SQL. There also is a more standard (than UTL_HHTP) use of
> HTTP callout example in the book.
>
> Kuassi
> http://db360.blogspot.com/2006/08/oracle-database-programming-using-java_01.html

thanks Kuassi
quick q...what needs to be done on the MSSS/Win side ? any thing to install ?

thanks
rob Received on Mon Nov 20 2006 - 16:23:46 CST

Original text of this message

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