Unanswered: Need a tool to debug .sql and .pch files
We work on lots of .sql files which in turn calls .pch files.
These .pch files will have DML/DDL statements.
We dont have any proper tool to write these scripts and debug them.We use notepad to write the script and run on sqlplus which does not give the error line numbers properly.
Hence if you know any tool using which we can write these scripts and debug pl. reply.
There are plenty of tools which can debug pl/sql blocks,but I need a tool which can debug sql file,and the file has calls to .pch files.the debugger should be able to go to these .pch files when debugging