By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,456 Members | 1,742 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,456 IT Pros & Developers. It's quick & easy.

pasted sqlplus script no longer running

P: 2
This is not a sqlplus script problem per se but I don't know where else to go with my problem.

I use wordpad to record my sqlplus script, then copy and paste it into the sqlplus prompt. I've run many scripts successfully. All of a sudden, instead of stopping and running my script, the script is read all the way to the end with no download. If I e-mail it to someone else they can run it fine. I retyped it once today and succeeded. Then it wouldn't run again. I have the same problem on my laptop. What could have changed/failed? Something about my setup? I'm mystified.
Nov 17 '08 #1
Share this Question
Share on Google+
3 Replies


amitpatel66
Expert 100+
P: 2,367
i am not able to understand your issue. Are you not able to run the sql script after copy paste from wordpad to sqlplus?
Nov 18 '08 #2

P: 2
i am not able to understand your issue. Are you not able to run the sql script after copy paste from wordpad to sqlplus?
Exactly! Though if I e-mail the script to someone else, t hey can run it fine.
Nov 18 '08 #3

amitpatel66
Expert 100+
P: 2,367
I suppose you are trying to copy paste the code directly in sql plus window which is not the right way.

Do one thing:

1. Connect to sql plus
2. Just type SELECT; in SQLPLUS
Eg:

SQL> SELECT;

This would give you some error. This step is just to write a data to a buffer so that when you use the below command it opens an editor for you to paste your code

3.

SQL> ed

This command should open a window with the text (SELECT;) that you entered in step 2. Just remove that data and paste your actual code after copying it from your wordpad. Save the data and close the editor window. Then run the code from SQL PLUS. This should work
Nov 19 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.