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???
do a select, click enter twice, write ed, dleete everything in text, paste the function now
close text editior
try to set high buffer value
set buffer 999999
set buffer doesn't help, it still stop at line 99 in SQL Plus
Could you elaborate your suggestion a little , I don't get it
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
save comple function in .sql file and run that file in SQL*Plus
Click Here to Expand Forum to Full Width