0

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
2
Views
5 Years
Discussion Span
Last Post by sujimon
1

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.