Copy/Paste Truncate in SQL Plus

[dbomrrsm]

Probably a dead eary one for you experts but I am trying to paste a large piece of code into SQL Plus and it keeps truncating the text at line 90.

What do I need to do to be able to paste in large code blocks ?

TIA

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[sem]

Open editor (type ed) and paste yor text there. Then close your editor.

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

In addition to Sem's fine solution (which creates a re-used file named AFIEDT.BUF), if you have that much code to paste into the SQL*Plus prompt, I'm wondering why you would not want to same it all to an explicit file (so that you can re-use and re-edit the code), and run it from the SQL*Plus prompot as "@file_name".

Let us know.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.