471,316 Members | 946 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,316 software developers and data experts.

pasted sqlplus script no longer running

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
3 4914
amitpatel66
2,367 Expert 2GB
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
draffe
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
2,367 Expert 2GB
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.

Similar topics

4 posts views Thread by tommy | last post: by
2 posts views Thread by massimo874 | last post: by
reply views Thread by tyousaf | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.