|
| oracle trigger |
 |
Mon, 17 Mar 2008 20:31:11 +000 |
exception {"ORA-20002: Cannot INSERT TS_DAILY_ACTV because
TASK_WRK_ORDR_DTL does not exist.\nORA-06512: at
\"DGELLE1.TI_TS_DAILY_ACTV\", line 43\nORA-04088: error during
execution of trigger 'DGELLE1.TI_TS_DAILY_ACTV'\n"} System.Exception
{System.Data.OracleClient.OracleException}
can anyone help me on this
i dont understand what is this error related to.
|
| Post Reply
|
| Re: oracle trigger |
 |
Mon, 17 Mar 2008 22:07:05 +000 |
Hi
The error message is not very descriptive of the problem. It just says that
there is a problem in the database trigger DGELLE1.TI_TS_DAILY_ACTV. You may
want to take a look at the trigger definition. Do a SELECT * FROM ALL_TRIGGERS
WHERE TRIGGER_NAME LIKE '%TI_TS_DAILY_ACTV%'. It looks like the trigger is
unable to find an object TASK_WRK_ORDR_DTL, which was likely supposed to be a
table.
Hope this helps.
|
| Post Reply
|
| Re: oracle trigger |
 |
Tue, 18 Mar 2008 00:46:22 +000 |
yes u r correct.thanq
|
| Post Reply
|
|
|
|
|
|
|
|
|
|