Your trigger and SP are both trying to access the same table. DB2 uses
table access context rules to identify and resolve conflicts. There is good
explanation in DB2 SQL PL Essential Guide 2nd Ed, chapter 9 look for figure
9.30.

Thanx,

Mark McNary
NPPC MES Database support
(w) 314-982-1389
(m) 314-497-5850




-----Original Message-----
From: sourav
[mailto:db2udbdba-ezmlmshield-x87799593.[Email address protected]
Sent: Friday, January 20, 2006 12:01 AM
To: LazyDBA Discussion
Subject: Cursor in Trigger



Hi All,
when I'm tring to open a cursor within a trigger on after deletion, it was
giving a runtime error. Then I've tried to call a separate SP from the
trigger, which should handle the cursor. But till I'm getting the error.In
that case the following error is given. Anyone can help me out?

Information returned for the error includes SQLCODE "-746",
SQLSTATE "57053" and message tokens
"TL.USP_DELETE_TVACC|SQL060119220019726|READ". SQLSTATE=09000

Thanks
Sourav

Notice: The information contained in this e-mail message and/or attachments
to it may contain confidential or privileged information. If you are not
the intended recipient, any dissemination, use, review, distribution,
printing or copying of the information contained in this e-mail message
and/or attachments to it are strictly prohibited. If you have received
this communication in error, please notify us by reply e-mail or telephone
and immediately and permanently delete the message and any attachments.
Thank you


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page