Improve company productivity with a Business Account.Sign Up

x
?
Solved

dbms_utility.active_instances

Posted on 2001-07-16
3
Medium Priority
?
681 Views
Last Modified: 2008-01-09
I am trying to determine the instance name using dbms_utility.  I get following error:

PLS-00306: wrong number or types of arguments in call to 'ACTIVE_INSTANCES'

Any suggestions. Code snippet below:


TYPE instance_record is RECORD
(
       inst_number number,
      inst_name   varchar2(60)
);
     

TYPE instance_table is TABLE OF instance_record INDEX BY BINARY_INTEGER;

inst_tab instance_table;
inst_count number;

BEGIN      
 DBMS_UTILITY.ACTIVE_INSTANCES(inst_tab, inst_count);
END;
0
Comment
Question by:curtjenk
  • 2
3 Comments
 
LVL 5

Expert Comment

by:ser6398
ID: 6287427
try declaring your variable as follows:

inst_tab   DBMS_UTILITY.instance_table;



0
 
LVL 3

Expert Comment

by:UsamaMunir
ID: 6288450
SQL> declare
  2  inst_table DBMS_UTILITY.INSTANCE_TABLE;
  3  INST_NUM NUMBER;
  4  BEGIN
  5  DBMS_UTILITY.ACTIVE_INSTANCES(INST_TABLE,INST_NUM);
  6  END;
  7  /

PL/SQL procedure successfully completed.

I HOPE IT HELPS

Regards
Usama Munir
0
 
LVL 5

Accepted Solution

by:
ser6398 earned 100 total points
ID: 6288511
DECLARE

inst_tab     DBMS_UTILITY.instance_table;
inst_count   number;

BEGIN      
  DBMS_UTILITY.ACTIVE_INSTANCES(inst_tab, inst_count);
END;
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question