Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


how to disable a function?

Posted on 2012-08-20
Medium Priority
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 74

Accepted Solution

sdstuber earned 880 total points
ID: 38313230
there is no "disable function" command.

you'll have to edit the function or drop it

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

580 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