Creating relational view for an ODBC result set?

antilog@gmail.com · *nix forums beginner Joined: 21 Jul 2006 Posts: 1

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

Google