On 6/13/07, Jasbinder Singh Bali <jsbali@xxxxxxxxx> wrote:
Hi, I have a Pl/Perlu function in which I have written an insert statement in tbl_xyz. If there's not foreign key in this table, insert works fine. As soon as i make one of its fields refer to tbl_abc i.e field a in tbl_xyz refering to field a in tbl_abc, insert fails. Now the problem is, I can't see the actual error, i mean the place where it fails. Is there any way by which I can include a few lines of code that would log any error in a file whenever the insert fails.
Hmmm ... write debug output to a file in ~/tmp or whatever as you would in any other perl program? Syslog if you're tidy ;D
Thanks, ~Jas
Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm