Note: Technical Talk being moved to:
www.nazimcricket.com/wiki


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
OK

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.

2 comments:

Anonymous said...

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


SQL*Plus: Release 11.2.0.1.0 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 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
Tool completed with exit code 1

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

Thanks
V$

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 (nazim@nazimcricket.com) and we'll discuss it further.