| using product_user_profile [message #623972] |
Wed, 17 September 2014 00:38  |
 |
viveksn
Messages: 4
Registered: September 2014
Location: India
|
Junior Member |
|
|
Hi
I would like to disable the command / ( which causes the last SQL statement in the buffer to be executed again ). I have achieved this by adding an entry in the product_user_profile (PUP) for the specific user. It works perfectly. However, I face the following problem.
I have a collection of SQL files that are required to be run in sequence. A master SQL file runs this collection of SQL plus via an SQLPLUS connection to the database. This SQLPlus connect is taken via the Repository Creation Utility (RCU, part of Oracle 11g middleware).
Some of these SQL have comments in them starting with /* and end with */.
Unfortunately, these comments are NOT getting recognized as comments. Instead the /* is treated as a COMMAND and the RCU log file displays the message "SP2-0544: Command "/*" disabled in Product User Profile". The subsequent lines of comments, each of them is executed as a command and everything just fails.
The amazing part is that - if I take a direct SQLplus connection and execute the master SQL file, the same problem does not occur.
Can anyone help?
Regards
|
|
|
|
|
|
| Re: using product_user_profile [message #623990 is a reply to message #623972] |
Wed, 17 September 2014 02:21  |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
viveksn wrote on Wed, 17 September 2014 11:08
Some of these SQL have comments in them starting with /* and end with */.
Since you have been successful in disabling the in-built use of "/", you are now left with line-by-line commenting, you could do that in two ways :
SQL> -- this is a comment
SQL> -- OR
SQL> REM even this is a comment
SQL>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
