Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to test whether a procedure is recompiled or not

GaryBaoJul 28 2009 — edited Jul 29 2009
create paceage my_debug is
debug constant boolean := true;
trace constant boolean := true;
end my_debug;
/

create procedure my_proc is
begin
if my_debug.debug then
dbms_output.put_line('Debugging ON');
else dbms_output.put_line('Debugging OFF');
end if;
end my_proc;
/

the manual said: if changing the value of debug to FALSE would cause my_proc to be recompiled without the debugging code. I hv two questions:
1, what does 'without the debugging code' mean?
2, how can I test whether my_proc is recompiled or not?

thanks

Comments

785636

Hello,

I want to learn more about what is the process to contribute to MySQL team as C++ developer, Thanks.

Hello,

I want to learn more about what is the process to contribute to MySQL team as C++ developer, Thanks.

Hello,

so sorry for the delay in responding.

You first need to sign a Oracle Contribution Agreement (OCA) - http://www.oracle.com/technetwork/community/oca-486395.html in order you to get in the list of Oracle's contributors.

You need to create an account in our bug system: https://bugs.mysql.com/ .

Once those two steps are done, you can contribute either by submitting a bug in our bug system of using the GitHub (please provide your GitHub name when you submit the OCA).

These are the process steps, if you have any technical questions, then please share it and I will help you to get an answer.

thank you,

-Lenka

fareed shah

Contributing code to MySQL, which is an open-source relational database management system, serves several important purposes:

1. **Improving MySQL's Functionality and Performance:**

  • By contributing code, developers can enhance the functionality and performance of MySQL. This can include adding new features, optimizing existing ones, or fixing bugs.

2. **Community Collaboration:**

  • MySQL is developed collaboratively by a community of contributors. Contributing code allows developers to actively participate in this community, share their expertise, and collaborate with other like-minded individuals.

3. **Addressing Issues and Bugs:**

  • Open-source projects often benefit from the diverse skills of contributors who can identify and fix issues or bugs. By contributing code, developers help ensure the stability and reliability of MySQL.

4. **Keeping MySQL Up-to-Date:**

  • Technology evolves rapidly, and MySQL needs to stay current to meet the demands of modern applications. Contributing code helps keep MySQL up-to-date with the latest industry standards, best practices, and technological advancements.

5. **Customization and Specialized Features:**

  • Organizations or individuals with specific needs can contribute code to MySQL to implement custom features or functionalities tailored to their requirements. This flexibility is a key advantage of open-source software.

6. **Quality Assurance:**

  • A large and active community of contributors helps in identifying and fixing issues through rigorous testing and quality assurance processes. This collective effort enhances the overall reliability of MySQL.

7. **Learning and Skill Development:**

  • Contributing to an open-source project like MySQL provides developers with valuable learning opportunities. It allows them to work on real-world projects, understand the intricacies of a complex system, and improve their coding skills.

8. **Building a Reputation:**

  • Actively contributing to a widely used and respected open-source project can enhance a developer's professional reputation. It showcases their skills, commitment, and ability to work collaboratively within a community.

9. **Supporting the Open-Source Ecosystem:**

  • Contributing to MySQL aligns with the principles of the open-source ecosystem. It promotes the sharing of knowledge, code, and resources for the benefit of the broader community.

In summary, contributing code to MySQL is not just about adding features or fixing bugs; it's about actively participating in a community-driven effort to create a robust, efficient, and continually evolving database management system. It's a collaborative process that brings together developers with diverse skills and perspectives to improve and maintain a critical piece of open-source infrastructure. CHECK

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 26 2009
Added on Jul 28 2009
#procedure
4 comments
459 views