Creating relational view for an ODBC result set?

From: <antilog_at_gmail.com>
Date: 20 Jul 2006 22:56:34 -0700
Message-ID: <1153461394.635774.151780@h48g2000cwc.googlegroups.com>

Hello,

I'm a newbie to Oracle heterogeneous services. I'm trying to create an Oracle relational view (or table) for the data available from the Siebel Analytics server (SAS) query's result set by executing pass through sql. SAS reads from files and multiple other databases to provide the result set.

The query sent to SAS has its own properitary syntax and is not SQL. so, I'm trying to achieve something like this :

create view analytics_wrapper_view as
select * from
<
dbms_hs_passthrough('my custom sql understood by SAS') dbms_hs_passthrough.fetch_rows
>@SASServer

basically, read SAS generated data through an Oracle view.

Cant use a function selecting from dual as there could be several rows returned from this operation. If I retain it as a view, I can avoid data duplication. If this is not possible, a table approach could be considered.

Any thoughts or inputs on this would be highly appreciated. Received on Fri Jul 21 2006 - 00:56:34 CDT