pasted sqlplus script no longer running

[draffe]

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.

[amitpatel66]

i am not able to understand your issue. Are you not able to run the sql script after copy paste from wordpad to sqlplus?

[draffe]

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.

[amitpatel66]

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