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:-
SQL*Plus: Release 220.127.116.11.0 Production on Tue Aug 14 22:59:39 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect sys/Bel29072012 as SYSDBA
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.