koja
Member³
Hi Marco,
I'm trying to get some longstanding wishes working and with some workarounds are almost there:
is as far as I get. Only since I replaced list with default I keep receiving two errors:
Also the [+where="
where "][where] results in a second input form
Is there a way to hide the first 2 results? or another way I can do this?
I'm trying to get some longstanding wishes working and with some workarounds are almost there:
Code:
-- &<name="selowner" type="string" list="select username from dba_users where oracle_maintained='N' order by username" uppercase="yes">.&<name="seltable" type="string" list="select table_name from dba_tables where owner = :selowner order by table_name" uppercase="yes">
Select distinct &<name="colname" type="none" list="select column_name from dba_tab_cols where owner = :selowner and table_name = :seltable order by column_name" lowercase="yes">
from &<name=ownerdeq type="none" list="1" default="select lower(:selowner) from dual" hidden="yes">.&<name="tabledeq" type="none" list="1" default="select lower(:seltable) from dual" hidden="yes">[+where="
where "][where];
is as far as I get. Only since I replaced list with default I keep receiving two errors:
and one for tabledeq.ownerdeq: Error executing SELECT statement:
ORA-01008: not all variables bound
Also the [+where="
where "][where] results in a second input form
Is there a way to hide the first 2 results? or another way I can do this?