#11 Synonyms not created

[Jean Detoeuf]

When launching install, synonyms where not installed. Actually, during synonym creation, grant commands where performed. This was because the temp spool script used for synonym creation was overwritten by the grant spool script before it was executed. I guess this is due to multithreading. A workaround is to use different names for these spool scripts.

Diff with correction can be obtained here https://bitbucket.org/thebignet/utplsql/commits/cfcf75724386827b6823d93b0bb756e26f593b45/raw/

[Paul Walker]

I'm not sure what happened in this case. The install procedure explicity does the synonyms before grants...

The ut_i_install.sql calls ut_i_synonyms.sql which builds then executes ut_i_spool_temp.sql to create the synonyms.

Then ut_i_install.sql calls ut_i_grants.sql which builds then executes ut_i_spool_temp.sql to add the grants.

There is no multi-threading during the install - it is just a simple step-by-step script.

I'm going to close this ticket as it is more of a support issue. If you're still having problems, log it as a Support Ticket and we will work with you to try to identify what's going wrong.