When using the Generate Schema Script utility to export an object to .SQL file, the output file Toad creates has 2 extra lines at the end of it,
This can cause issues with an SVN compare process because normally original scripts had no extra empty line.
Steps to replicate:
1. Run the following function in the editor:
CREATE OR REPLACE function test123 (a IN varchar2)
return varchar2
is
out_char varchar2 (255);
begin
out_char := a || ' test';
return out_char;
end;
/
2. Go to Database | Export | Generate Schema Script
3. Select to export just Functions (filter by name if required)
4. Only choose to export to file & use otherwise default options
5. Check export file.
This has been addressed in the 12.6 beta version.
http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/default.aspx
Please Note, the file must have one extra empty line at the end, so the file can stand on its own if run in sql*plus - so the command is sent after the '/' is entered.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center