Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dependency tracking for sqplus scripts

Status
Not open for further replies.

slayland

Programmer
Feb 17, 2002
1
US
Has any body out ther had any luck using dependency manager for sqlplus scripts? We have quite a few reports that are generated using sqlplus scripts. The default sql parser doesn't work very well. It will not analyze both sql and plsql in the same file, and chokes on sqlplus commands. It also chokes if you have the "unrecoverable" keyword in any of your create table statements. Supposedly, you could write a custom parser. Unfortunately, there is not enough documentation on how to do this. Also, writing a parser is not the trivial activity that Oracle seems to think it is.




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top