79675

About Program Codę Stored in the Database

Oracle Database offers the ability to storę program codę in the database. Developers write program codę in PL/SQL or Java, and storę the codę in schema objccts. You, as the DBA. can use SQL Dcvcloper to manage program codę objects such as:

■PL/SQL packagcs, procedurcs, functions, and triggers ■Java source codę (Java sources) and compiled Java classes

The actions that you can perform include crcating, compiling, creating synonyms for, granting privileges on, and showing depcndencies for these codę objects. You can also Sec Also:

■ "About Vicws" on page 8-24 See Also:

■"About Views" on page 8-24 Managing Program Codę Stored in the Database 8-28 Oracle Database 2 Day DBA

edit and debug PL/SQL codę objects using SQL Developer. You access administration pages for these objects by clicking links in the Programs section of the Schema subpage.

Notę that creating and managing program codę objects is primarily the responsibility of application developers. However, as a DBA you might have to assist in managing these objects. Your most frequent task for program codę objects might be to revalidate (compile) them, because they can become invalidated if the schema objects on which they dcpend change or are deleted.