Re: trigger problem

<nitin_kaul_at_rediffmail.com> a écrit dans le message de news:1113631640.615416.169050_at_f14g2000cwb.googlegroups.com...
| hi to all
| well the replication jobs are in repadmin users job queue.So they have
| access to v$session view. Dan the exact error i was gettin was
|
| ORA-12012: error on auto execute of job 71
| ORA-04088: error during execution of trigger 'SYS.BLOCK_TOAD_FROM_PROD'
| ORA-01403: no data found
| ORA-06512: at line 4
|
| The job 71 is replication job .
|
| regards
|

So the message is quite clear: your select on v$session returns no row (maybe audsid is 0 when a job starts, i never check that). You just have to add an exception block to handle that case.

Regards
Michel Cadot Received on Sat Apr 16 2005 - 02:11:53 CDT