How to reset a DBMS_UTILITY.UNCL_ARRAY variable?

Posted on 2009-02-16
Last Modified: 2012-05-06
In a PL/SQL stored procedure I am using the folllowing variable:
minnie DBMS_UTILITY.uncl_array;

In the procedure, I do many assignments:

minnie(0) := '1';
minnie(1) := '3'
... and so on.

How can I reset this DMBS_UTILITY.UNCL_ARRAY variable?
Question by:hc2342uhxx3vw36x96hq
    LVL 28

    Accepted Solution

    try something like

    minnie := DBMS_UTILITY.uncl_array();

    or if the above does not work...

    in the declaration section....

    minnie DBMS_UTILITY.uncl_array;
    dummy DBMS_UTILITY.uncl_array := DBMS_UTILITY.uncl_array();

    in the executable section after the assignments...
    minnie(0) := '1';
    minnie(1) := '3'

    minnie := dummy;
    LVL 73

    Assisted Solution

    by "reset"  do you mean remove all the elements?

    LVL 1

    Author Closing Comment

    Perfect solution, many thanks ;-)
    LVL 28

    Expert Comment

    but which one did exactly work for you because i gave you two options... just got curious as to which one you have used.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
    Note: You must have administrative privileges in order to configure lead or case queues. ( is a cloud-based customer relationship management (CRM) system. It is widely used around the world by sales and ma…
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now