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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center