Home » SQL & PL/SQL » Client Tools » using product_user_profile (Oracle 11g)
using product_user_profile [message #623972] Wed, 17 September 2014 00:38 Go to next message
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 #623982 is a reply to message #623972] Wed, 17 September 2014 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you disable "/" how do you execute any PL/SQL code, anonymous block, CREATE PROCEDURE/FUNCTION/PACKAGE...?

Re: using product_user_profile [message #623990 is a reply to message #623972] Wed, 17 September 2014 02:21 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
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>


Re: using product_user_profile [message #624006 is a reply to message #623990] Wed, 17 September 2014 03:54 Go to previous messageGo to next message
viveksn
Messages: 4
Registered: September 2014
Location: India
Junior Member
I do not want to change my source files. There are far too many source files to change.
Disabling the / has been done, because I would like to use the / only as a separator and not as a command. and it works perfectly on SQLPLUS Window. I am stumped as to why SQLPLUS Direct is able to execute fine - But using SQLPLUS via the RCU causes the /* to be treated as a command, rather than a comment.
Re: using product_user_profile [message #624013 is a reply to message #624006] Wed, 17 September 2014 04:16 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I think you should open a SR to Oracle to get the reason (if any exists).

Re: using product_user_profile [message #624021 is a reply to message #624013] Wed, 17 September 2014 04:51 Go to previous messageGo to next message
viveksn
Messages: 4
Registered: September 2014
Location: India
Junior Member
Any idea how one can do that?
Re: using product_user_profile [message #624028 is a reply to message #624021] Wed, 17 September 2014 05:31 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
Go to My Oracle Support site and log a SR. And do let us know the feedback if you get any.
Re: using product_user_profile [message #624050 is a reply to message #623972] Wed, 17 September 2014 07:47 Go to previous messageGo to next message
EdStevens
Messages: 888
Registered: September 2013
Senior Member
https://community.oracle.com/thread/3609150
Re: using product_user_profile [message #624101 is a reply to message #624050] Wed, 17 September 2014 14:48 Go to previous messageGo to next message
viveksn
Messages: 4
Registered: September 2014
Location: India
Junior Member
@EdStevens

There must be a reason (use-cases) why it is supported. In any case, I did not intend to disable the / permanently. It was only for the duration of the RCU running during which time the repository gets created.

I see no reason why ONLY the SQLPLUS invoked via the RCU should recognize the "/*" itself as a command and shout out that "Command /* is disabled in the product user profile".
Re: using product_user_profile [message #624106 is a reply to message #624101] Wed, 17 September 2014 14:58 Go to previous message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I see no reason why ...


This is why we tell you to open a SR.

Previous Topic: Formatting the result set
Next Topic: Toad Error
Goto Forum:
  


Current Time: Fri Jan 19 23:51:35 CST 2018

Total time taken to generate the page: 0.02493 seconds