Difference in behaviour of /* on SQLPLUS and SQLPLUS via RCU

user10296291

I am trying to create a repository (schema) by using the Repository Creation Utility (RCU). At one point during the creation, I have coded the RCU to load a series of objects into the schema. These objects are all in the from of .sql files. The SQL files themselves have SQL code as well as a lot of comments. A master SQL file loads the collection of SQL files into the schema by taking an SQLPLUS connection. Each file execution is separated from the other by a separator i.e. slash /.

A typical SQL file starts thus

/*

Comments

Comments

Comments

*/

SQL CODE

/

The various SQL files are inconsistent in their usage of / at the end of the files. Some files have a / at the end. There are other files which do not. In order to ensure that the SQLPLUS does not wait for the user to press a carriage return (ENTER), the call is individual SQL is separated by a /.

However at times this separator gets treated as a command in itself, resulting in unnecessary errors in the RCU logs. To circumvent this problem, we have disabled the command / in the product_user_profile table.

However, now the SQL files that have comments right at the top as shown above, do not execute correctly with the error message as "SP2-0544: Command "/*" disabled in Product User Profile"

I am unable to understand why the RCU has interpreted that /* as a single command /.

The irony is that via a direct SQLPLUS connections, things work perfectly and the error message above is not encountered.

Please help.

EdStevens

http://www.orafaq.com/forum/t/194510/

KayK

Is this a new trend ? Post your questions in all forums you have access ?