sybperl-l Archive

From: "Wechsler, Steven" <Steven dot Wechsler at mtvstaff dot com>
Subject: Parsing stored proc/sql code
Date: Feb 25 2005 3:12PM

I've been asked to write a script to examine new stored procedures to see if
they do any writing (i.e. delete, insert, update) to the database, or,
recursively, if they call any stored procs that write to the database. I
can't just do a simple grep but also have to ignore comments and quoted
strings.

Before I embark on this task, I wonder if anyone's ever done anything like
this (even part of it); I'd hate to reinvent the wheel.

Thanks,

Steve