Hi there,
I noticed the ORAOCI (8 and 9) plug-in have changed in DS v6.
When I use an ODBC or ORAOCI stage to select data from a table, I always use a parameter for the table owner. In v6, it seems not to be possible anymore to replace the table owner by a parameter (or I haven't found a way to do this yet).
Did other face this problem? Did you solve it?
Thanks.
DS v6: changes in ORAOCI plug-in
Moderators: chulett, rschirm, roy
Luca,
It *is* different, but still perfectly doable. Assuming you are not going the User Defined SQL route...
I end up using the 'Column-generated SQL query' option. You do everything after clicking on the 'Build' button. In the 'FROM clause (table name)' section, simple put your parameters and text like 'normal' - #Owner#.Tablename - and you'll be fine.
The 'Fully generated' option brings up a new Query Builder, which I find very cumbersome to use and I believe you are right in that there is no place there to include the Owner as a parameter. Maybe by manipulating the metadata in the Manager? [shrug] Heck if I know. Perhaps it's buried in there somewhere, but I don't think it's worth the effort to uncover it. [}:)]
-craig
It *is* different, but still perfectly doable. Assuming you are not going the User Defined SQL route...
I end up using the 'Column-generated SQL query' option. You do everything after clicking on the 'Build' button. In the 'FROM clause (table name)' section, simple put your parameters and text like 'normal' - #Owner#.Tablename - and you'll be fine.
The 'Fully generated' option brings up a new Query Builder, which I find very cumbersome to use and I believe you are right in that there is no place there to include the Owner as a parameter. Maybe by manipulating the metadata in the Manager? [shrug] Heck if I know. Perhaps it's buried in there somewhere, but I don't think it's worth the effort to uncover it. [}:)]
-craig