Error connecting to Oracle DB table

JoeS

We've created a new table in our content database and we're trying to pull in the values into a DCT drop-down:

[size=1][color=#0000ff]<[/color][/size][size=1][color=#800000]item[/color][/size][size=1][color=#ff0000] name[/color][/size][size=1][color=#0000ff]="[/color][/size]FirmName[size=1][color=#0000ff]">[/color][/size][size=1]
[size=1][size=1][color=#0000ff]<[/color][/size][size=1][color=#800000]select[/color][/size][size=1][color=#ff0000] required[/color][/size][size=1][color=#0000ff]="[/color][/size]f[size=1][color=#0000ff]"[/color][/size][size=1][color=#ff0000] multiple[/color][/size][size=1][color=#0000ff]="[/color][/size]f[size=1][color=#0000ff]"[/color][/size][size=1][color=#ff0000] size[/color][/size][size=1][color=#0000ff]="[/color][/size]10[size=1][color=#0000ff]">[/color][/size]
[size=1][color=#0000ff]<[/color][/size][size=1][color=#800000]inline[/color][/size][size=1][color=#ff0000] command[/color][/size][size=1][color=#0000ff]="[/color][/size]/iw-home/httpd/iw-bin/mfs/populate_select.ipl TITLE_NONE select ID, NAME from CM_OWNER.FIRM_TYPE[size=1][color=#0000ff]"/>[/color][/size]
[size=1][color=#0000ff][/color][size=1][color=#800000]select[/color][/size][size=1][color=#0000ff]>[/color][/size]
[size=1][color=#0000ff][/color][size=1][color=#800000]item[/color][/size][size=1][color=#0000ff]>
[/color][/size]
However we're getting the following error when we open the DCR:
Root cause:
DBD:racle::db prepare failed: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 30 in 'select ID, NAME from CM_OWNER.<*>FIRM_TYPE') [for Statement "select ID, NAME from CM_OWNER.FIRM_TYPE"] at /iw-home/httpd/iw-bin/mfs/populate_select.ipl line 43. Can't call method "execute" on an undefined value at /iw-home/httpd/iw-bin/mfs/populate_select.ipl line 44.
[/size][/size][/size]
[/size]

Adam Stoller

We've created a new table in our content database and we're trying to pull in the values into a DCT drop-down: [size=1][color=#0000ff]<[/color][/size][size=1][color=#800000]item[/color][/size][size=1][color=#ff0000] name[/color][/size][size=1][color=#0000ff]="[/color][/size]FirmName[size=1][color=#0000ff]">[/color][/size][size=1] [size=1][size=1][color=#0000ff]<[/color][/size][size=1][color=#800000]select[/color][/size][size=1][color=#ff0000] required[/color][/size][size=1][color=#0000ff]="[/color][/size]f[size=1][color=#0000ff]"[/color][/size][size=1][color=#ff0000] multiple[/color][/size][size=1][color=#0000ff]="[/color][/size]f[size=1][color=#0000ff]"[/color][/size][size=1][color=#ff0000] size[/color][/size][size=1][color=#0000ff]="[/color][/size]10[size=1][color=#0000ff]">[/color][/size] [size=1][color=#0000ff]<[/color][/size][size=1][color=#800000]inline[/color][/size][size=1][color=#ff0000] command[/color][/size][size=1][color=#0000ff]="[/color][/size]/iw-home/httpd/iw-bin/mfs/populate_select.ipl TITLE_NONE select ID, NAME from CM_OWNER.FIRM_TYPE[size=1][color=#0000ff]"/>[/color][/size] [size=1][color=#0000ff][/color][size=1][color=#800000]select[/color][/size][size=1][color=#0000ff]>[/color][/size] [size=1][color=#0000ff][/color][size=1][color=#800000]item[/color][/size][size=1][color=#0000ff]> [/color][/size] However we're getting the following error when we open the DCR: Root cause: DBD:racle::db prepare failed: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 30 in 'select ID, NAME from CM_OWNER.<*>FIRM_TYPE') [for Statement "select ID, NAME from CM_OWNER.FIRM_TYPE"] at /iw-home/httpd/iw-bin/mfs/populate_select.ipl line 43. Can't call method "execute" on an undefined value at /iw-home/httpd/iw-bin/mfs/populate_select.ipl line 44. [/size][/size][/size] [/size]

As the error might indicate - the problem is occurring within the inline script, populate_select.ipl, which we don't have, and cannot run within your environment to debug -- I think you'll have to do a bit more work on this one.