Member Avatar for sujimon

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 11.2.0.1.0 Production on Tue Aug 14 22:59:39 2012

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

SQL> connect sys/Bel29072012 as SYSDBA
Connected.
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';

COUNT(*)
     0

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

COUNT(*)
     0

SQL>

Please let me know how to overcome this issue.

Regards

  • 1 Contributor
  • 1 Reply
  • 598 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by sujimon
Member Avatar for sujimon

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, networking, learning, and sharing knowledge.