Projects tagged ‘oracle’ and ‘plsql’

TOra is a Toolkit for Oracle which aims to help the DBA or developer of database application. It features an SQL worksheet with PL/SQL block parsing, a PL/SQL debugger and editor with syntax ... [More] highlighting, a Schema browser, UNICODE support, printing, and a full suite of DBA management tools. [Less]

Goal of oraschemadoc is "JavaDoc" style detailed documentation for all objects in schema covering Oracle specific features. Result of execution of oraschemadoc is set of static XHTM files mainly - more output formats in progress.

This is a TextMate bundle for editing Oracle PL/SQL files, though it may be useful elsewhere, too. It is based on the bundle created by Jesper Hvirring Henriksen. This bundle does not rely on the ... [More] standard TextMate "SQL" bundle and includes: A reasonable syntax (which is designed to make it easy to customise for your own needs). Identification of PACKAGE, FUNCTION and PROCEDURE names in the symbol selector in the status bar. Folding of BEGIN, IF and LOOP sections. Indentation which seems to work ok. A number of useful code snippets to help insert BEGIN, IF and LOOP constructs. Templates for package spec and body. Ability to jump to the implementation code of the function or procedure at the cursor if it is in the current project. There are also a few snippets which I find useful in my coding which add FUNCTION and PROCEDURE stubs, reference to logging function I use and also conditionals based on success or failure of a procedure or function call. These can easily be customised to fit with your own coding standards. See the Installation Guide and User Guide for more information. There is also a history of changes available. [Less]

Framework to test and mock pl/sql on Java.

Code snippets and the like from ORACLENERD

AboutLog4Ora is an enterprise class logging framework for Oracle PL/SQL applications. Log4Ora is designed specifically for Oracle 11g. Key features in Oracle 11g are utilized to make Log4Ora very ... [More] efficient, versatile, and scalable. Key FeaturesEasy to use logging API. Example: log4.info('Hello World'); Logging severity levels based on Log4j (Trace, Debug, Info, Warn, Error, Fatal). Log Levels can be changed at run time. Error and Fatal messages automatically capture Oracle error information. All messages capture session and system information. Oracle AQ is leveraged to support multiple log message consumers. To enable a variety of log output, Log4j is used as a AQ message subscriber. Project StatusThe project is nearing a alpha release. [Less]

My Working Useing Code

The goal of the plsql-core project is to produce a library of reusable PL/SQL components. The plsql-core project will provide components to help with common programming tasks, such as: Logging ... [More] , Application configuration and Producing user feedback (messages). Getting startedComing soon ... [Less]

some pl