 Sql Plus keeps crashing when I open Notepad [message #401227] |
Sat, 02 May 2009 23:05  |
sandriac
Messages: 1
Registered: May 2009
|
Junior Member |
|
|
|
I am very new to Oracle and SQL Plus. I am trying to type my insert statements in a file I open in SQL Plus by typing the command edit temp.sql. Notepad opens and I type my commands and then save it and close notepad. Then I always get a message that SQL Plus is not responding. I have to close it and sign on again to SQL plus and type start temp.sql. The command runs and creates the rows. But I have to do this every time. Any ideas why SQL Plus would keep crashing? Is it just a bad connection to the server? Thanks for any help!
|
|
|
|
|
|
| Re: Sql Plus keeps crashing when I open Notepad [message #402284 is a reply to message #401227] |
Fri, 08 May 2009 07:34  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Are you certain that you're exiting Notepad?
SQL*Plus passes control over to Notepad, and will stay unresponsive for as long as Notepad is open.
If you're just editing a piece of SQL, rather than a specific Sql script, you can just type 'ED' and when you save and exit notepad, it will copy the code you were working on straight into SQL*Plus.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
