Gert Verheyen
6th July 2004, 12:04
We are running Triton 3.1a with a lot of customizations.
What I would like to do, is to write a query on our Oracle Database, but the fields are non-Triton table fields.
For instance:
select pck.get_info('300') from dual;
where pck is an oracle package, and get_info is the function in that package.
Even if I put an oracle view on top of this, Triton still is searching for the Reference counter fields. So I put 2 extra columns in my view.
Then triton is still searching for an existing Triton table. Is there a way to bypass the triton table definition and domain definitions?.
As far as I know, Triton only allows to query inside Triton Tables, known in the Triton DD. Right?
My purpose is to query data outside the Triton tables.
What I would like to do, is to write a query on our Oracle Database, but the fields are non-Triton table fields.
For instance:
select pck.get_info('300') from dual;
where pck is an oracle package, and get_info is the function in that package.
Even if I put an oracle view on top of this, Triton still is searching for the Reference counter fields. So I put 2 extra columns in my view.
Then triton is still searching for an existing Triton table. Is there a way to bypass the triton table definition and domain definitions?.
As far as I know, Triton only allows to query inside Triton Tables, known in the Triton DD. Right?
My purpose is to query data outside the Triton tables.