SQL plus question

Hi all,

If i have a long function and I want to create this function in the database. What I did was copy and paste it in SQL plus, and it stop at line 99.

what command in SQL plus I need type before I can copy and paste the whole thing to SQL Plus???

Thanks

do a select, click enter twice, write ed, dleete everything in text, paste the function now

close text editior

run

try to set high buffer value

eg ..
set buffer 999999

prakash43,

set buffer doesn't help, it still stop at line 99 in SQL Plus



Pando,

Could you elaborate your suggestion a little , I don't get it

thanks all

well when you write a query you can edit it afterwards right by writing ed right?

then just do that write any query then edit the file and paste the text there

or simple...

save comple function in .sql file and run that file in SQL*Plus

SQL> @myfunc.sql;