I just finished installing ODTwithODAC112012 (Oracle Developer tool for Visual Studio ODT) on my system . Now I am trying to deploy dbmsclr.plb as SYSDBA from SQLPLUS

But I am getting the error SP2-024 nothing to change.

Here is the command window:-

C:>sqlplus /nolog

SQL*Plus: Release Production on Tue Aug 14 22:59:39 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> connect sys/Bel29072012 as SYSDBA
SQL> C:\app\thoshiba\product\11.2.0\dbhome_1\RDBMS\ADMIN\dbmsclr.plb
SP2-0024: Nothing to change.
SQL> select count(*) from all_objects where object_name='DBMS_CLR';


SQL> select count(*) from all_objects where object_name='DBMS_CLR' AND owner='SYS';



Please let me know how to overcome this issue.


I was missing the @ sign in command line , the following command line resolved the issue:-
SQL> @C:\app\thoshiba\product\11.2.0\dbhome_1\RDBMS\ADMIN\dbmsclr.plb

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.