Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Get Data from SqlServer via HTTP
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
rc wrote:
> I need to query an SS2k database - FROM package in 10gR2/Unix - result set
> mostly is just ***one single record***.
> This is not a heavy-traffic OLTP application
>
> I'm thinking of getting around all the "Gateway", "ODBC", "Generic Service",
> "this/that Client" crap (it's quite confusing)
> by getting that string of data via HTTP ---
>
> so a few lines of SQL + ASP(or whatever Win guy decides on) on SS2K/Win
> end and I can read in the string via UTL_HTTP
>
> What do you think...is this feasible ? do you see anything wrong with this
> approach ?
>
> thanks
Received on Mon Nov 20 2006 - 15:47:19 CST