Projects tagged ‘perl’ and ‘storedprocedure’

This Perl module allow your program to process text files containing one or many commands that execute SQL statements sequentially following the procedure you define. Please keep in mind that ... [More] DBIx::Simple::Procedure is an alternative to database stored procedures and not a replacement or emulation of them. Essentially it is an interface to execute and return data from multiple queries. Here is an example of how to setup and process a (sql) text file. EXAMPLE: use DBIx::Simple::Procedure; my $db = DBIx::Simple::Procedure->new($path_to_sqlfiles, 'dbi:SQLite:dbname=file.dat'); $db->queue($sql_file)->process_queue(@sql_parameters); foreach my $result (@{$db->cache(0)}){ $result->{...}; } [Less]

External Language Stored Procedures for MySQL is a patch for MySQL to provide support for stored procedures written in an external languages. Stored procedures are declared in SQL using SQL standards ... [More] compliant syntax. Additional stored procedure languages are implemented as plug-ins to be installed at run time into the server. Currently, plugins for Java and Perl are implemented, as well as support for declaring XML-RPC requests as stored procedures. [Less]