I'm a new textpad user. It's a great tool but since we work much with oracle 9.2 here, I need to know if I can make it work easily with it before choosing it as my sql editor ( I hate sqlplus worksheet ... )
I saw some topics on how to got sqlplus 3.3 to work with textpad ... but I can't find the DOS version of sqlplus
I work with 5 developers and we all use TextPad for our PL/SQL coding. By setting up TextPad Tools to do our compiling and using its regular expression matching on the output to give us links back to errors, we are quite happy. The DOS version of sqlplus should be in the same directory (\oracle\ora92\bin in my case) as the Windowed version, just called sqlplus.exe instead of sqlplusw.exe. I've configured my "compile" tool in the following manner:
With this setup you can just run the tool on your code and it will get executed in SQL*Plus. By capturing the output and doing the regular expression matching, I am able to double-click on errors in the output and be taken back to that line and column in the source file where it believes the error is. Very cool!
Almost all the time, my databases are never on the same box. I have the Oracle client software installed on the TextPad machine and am using SQL*Net to connect to the databases. As long as my Windows-client SQL*Plus (SQLPLUSW) can connect to the database, so can the command-line and thus TextPad. Works great!