Note: Technical Talk being moved to:

Wednesday, 23 May 2012

Run sqlplus from Textpad

For people who use the product "Textpad". If you wish to run sqlplus scripts direct through Textpad, you can set it up as follows:
In Textpad navigate to:
Configure > Preferences > Tools
Add Program
Browse and select sqlplus

Then navigate to
Configure > Preferences > Tools > sqlplus
and in the right hand pane, in the field marked Parameters add:
/nolog @$File

This will essentially invoke sqlplus /nolog and if the SQL script you have opened in Textpad contains the line connect username/password@database you can use the shortcut key (in my case ctrl-1) to execute the SQL through Textpad.


Anonymous said...

Hi Nazim..
I tried to connect textpad to sqlplus.. I am getting an error

SQL*Plus: Release Production on Sat Dec 15 00:52:41 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Tool completed with exit code 1

Can you help me to connect using textpad ? I did ever step you described ..


nazimcricket said...

It's been a very long time since I last used textpad with sqlplus. I hope I can help answer your question.

Does your sql script file contain the string "connect username/password@dbname"?

send me an email ( and we'll discuss it further.