how to disable a function?

Posted on 2012-08-20
Last Modified: 2012-08-20
I have a script for creating a function in oracle. There is no specification for the function. Instead, in the script, it's something like below

create or replace


Now , I want to disable the function but I don't want to comment out or delete the entire function because it's a long function with a lot of comments.

Is there an easy way to do that?
Question by:wasabi3689
    1 Comment
    LVL 73

    Accepted Solution

    there is no "disable function" command.

    you'll have to edit the function or drop it

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    Oracle Multiple Union 7 43
    Help on Oracle SQL queries 2 52
    SSN Format in Oracle 2 36
    Bulk insert into global temporary table 2 24
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    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.  â€¦
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    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

    12 Experts available now in Live!

    Get 1:1 Help Now