Error Executing Database Query.
|
|
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
|
| |
The error occurred in C:\Inetpub\wwwroot\devmx\Programs\dsp_program.tabbed.cfm: line 141
Called from C:\Inetpub\wwwroot\devmx\Programs\dsp_program.tabbed.cfm: line 125
Called from C:\Inetpub\wwwroot\devmx\Programs\dsp_program.tabbed.cfm: line 110
Called from C:\Inetpub\wwwroot\devmx\Programs\dsp_program.tabbed.cfm: line 1
Called from C:\Inetpub\wwwroot\devmx\Programs\index2.cfm: line 35
Called from C:\Inetpub\wwwroot\devmx\index.cfm: line 82
Called from C:\Inetpub\wwwroot\devmx\Programs\dsp_program.tabbed.cfm: line 141
Called from C:\Inetpub\wwwroot\devmx\Programs\dsp_program.tabbed.cfm: line 125
Called from C:\Inetpub\wwwroot\devmx\Programs\dsp_program.tabbed.cfm: line 110
Called from C:\Inetpub\wwwroot\devmx\Programs\dsp_program.tabbed.cfm: line 1
Called from C:\Inetpub\wwwroot\devmx\Programs\index2.cfm: line 35
Called from C:\Inetpub\wwwroot\devmx\index.cfm: line 82
|
139 : From PROGRAM_FEES_MV_NEW
140 : Where STRM = <cfqueryparam value="#Variables.strm_idx#" cfsqltype="cf_sql_varchar">
141 : AND ACAD_PROG = <cfqueryparam value="#Variables.idx#" cfsqltype="cf_sql_varchar">
142 : AND EFFECTIVE_TO_DATE >= TRUNC(SYSDATE)
143 : AND EFFECTIVE_FROM_DATE <= TRUNC(SYSDATE)
|
|
| SQL |
Select AMOUNT,STRM
From PROGRAM_FEES_MV_NEW
Where STRM = (param 1)
AND ACAD_PROG = (param 2)
AND EFFECTIVE_TO_DATE >= TRUNC(SYSDATE)
AND EFFECTIVE_FROM_DATE <= TRUNC(SYSDATE)
AND ACADEMIC_LEVEL = 1
|
| DATASOURCE |
core_data |
| VENDORERRORCODE |
942 |
| SQLSTATE |
42S02 |
|
|
Resources:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.103.63.16 |
| Referrer |
|
| Date/Time |
20-May-08 03:12 PM |
|