Search code examples
notepad++sqlplusnppexec

NppExec SqlPlus how to check for errors?

I'm running Notepad++ with NppExec plugin.

When I press F6 i enter a script that connects to my database

set ORA_USER=USER
set ORA_PASS=password
set ORA_SID= DBSID
npp_save
cmd /c copy /y "$(CURRENT_DIRECTORY)\$(FILE_NAME)" "$(SYS.TEMP)\$(FILE_NAME)" >nul 2>&1
cmd /c echo. >> "$(SYS.TEMP)\$(FILE_NAME)"
cmd /c echo exit >> "$(SYS.TEMP)\$(FILE_NAME)"
sqlplus $(ORA_USER)/$(ORA_PASS)@$(ORA_SID) @"$(SYS.TEMP)\$(FILE_NAME)"

If my package doesn't compile, how do I check for errors with "show errors"?

Solution

  • A workaround at the moment would be to add "show errors;" a the end of the package.