Oracle Stored Procedure Examples

Stored procedures provide the ability to perform some action against a database and have some advantages to query data from an application. First and foremost, it reduces the amount of redundancy and has a performance gain when multiple calls are executed. For most applications, these stored... Platforms: Windows, 2003, Windows Vista, 2008, 7

extproc_perl allows you to write Oracle stored procedures in Perl. Whether youre looking to accomplish something thats easier to program in Perl, or youre just more comfortable programming in Perl, read on to see if extproc_perl will work for you and your Oracle database.. Platforms: *nix

SPWrapper project analyzes Oracle database system tables, finds out parameter names and types, and writes the Java code necessary for calling stored procedures. Do you ever needed to use stored procedures from java code? Perhaps you had to write first the stored procedure, then you had to write... Platforms: *nix

QueryObjectFactory (QOF) is a lightweight runtime JDBC byte-code generator providing support for CRUD (create, retrieve, update and delete) operations and stored procedure calls. It uses Java annotations to define mappings and is fully OSGi ready. Platforms: Windows, Mac, Linux

MySQL stored procedures emulates stored procedures for MySQL databases used (MySQL) client side files to define the SQL code of the procedures. It executes simple queries defined within a named block, known as "stored procedure".The query syntax within a stored procedure is compliant with... Platforms: PHP

pl2method uses PHP 5 __call function to map class function calls to execute stored procedures with the same name on a given PostgreSQL database schema.pl2method passes function parameter values to the stored procedure as its parameters. If the values do not match the procedure expected types, the... Platforms: PHP

External Language Stored Procedures for MySQL is a patch for MySQL 6.0 to provide support for stored procedures written in an external languages. Stored procedures are declared in SQL using SQL standards compliant syntax. Additional stored procedure languages are implemented as plug-ins to be... Platforms: *nix

DBAHelper project is a collection of scripts to ease the daily maintenance work of Oracle database administrators. Examples are moving objects between tablespaces, analyzing schemata, and rebuilding invalid indices. Whats New in This Release: - Some fixes to the Generate_createDB.sh. - An... Platforms: *nix

Decrypts SQL stored procedures, functions, triggers, and views on SQL Server. If you have encrypted an object definition in your database(s) by specifying WITH ENCRYPTION option, and by some reason you cannot restore it's original T-SQL script, the SQL Decryptor will easily do it for you... Platforms: Windows

OraDeveloper Tools integrates into Visual Studio and Delphi, making all database development and administration tasks available from your favorite IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different... Platforms: Windows

This script can execute MySQl queries build from parameters. It can establish connections to MySQL database servers using configuration loaded using a separate auxiliary script.The MySQL script can execute INSERT, UPDATE, DELETE, SELECT queries and stored procedure calls from parameters that... Platforms: PHP

Abe depends on Python 2.7 (or 2.6), the pycrypto package, and an SQL database supporting ROLLBACK. Abe runs on PostgreSQL, MySQL's InnoDB engine, SQLite, some ODBC configurations, Oracle, and IBM DB2. Other SQL databases may work with minor changes. See the comments in abe.conf about dbtype for... Platforms: *nix

Genezzo::Contrib::Clustered::ModPerlWrap is a Perl module with Mod Perl wrappers for Genezzo. SYNOPSIS StartPage(); Connect("/dev/raw"); ProcessStmt("insert into t1 values (10, test10)"); ProcessStmt("insert into t1 values (11, test11)"); Commit(); FinishPage(); or StartPage();... Platforms: *nix

Talend project has the most open and powerful data management solutions available as a packaged, out-of-box, ready-to-install platform. Talends fundamental technology breaks with the markets leading proprietary solutions, associated with the open source model, significantly modifying the rules... Platforms: *nix

Advanced ETL Processor Professional is a Codeless Automation Tool. It transfers from any database into any database or file. Complete automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging.... Platforms: Windows

SDE for NetBeans is a UML CASE tool/plug-in tightly integrated with NetBeans. This UML modeling software supports full software lifecycle - analysis, design, implementation, testing and deployment. This UML CASE tool helps you build quality applications faster, better and cheaper. You can draw... Platforms: Windows, Mac, Linux, Java

Utility to validate stored procedures, views and user functions - all at once. Gives you a list of possible errors, including stored procedure errors, DB view errors, missing table columns and other things which may cause gnereated database SQL script to fail. Platforms: Windows

phpMSAdmin project is designed to be a capable replacment to "SQL Enterprise Manager", which requires Windows to run. With the use of phpMSAdmin, your database can be managed from any computer capable of running a web browser (open source or otherwise). Whats New in This Release: - Added... Platforms: *nix

OpenLink Virtuoso is a Virtual Database product that provides transparent real-time access to disparate data sources (ODBC, JDBC, XML, and Web Services), and transparent integration of disparate application logic (e.g. Mono ECMA-CLI and J2EE integration). OpenLink Virtuoso Universal Servers broad... Platforms: *nix

Gizmo Central is a suite of useful utilities for computer power users. Mount ISO images, create encrypted virtual hard disks, calculate MD5 and SHA-1 values for a mass set of files. Automate your PC with Gizmo Script, which simulates mouse movements and keystrokes. Gizmo also includes a set of... Platforms: Windows