NAME

ExtProc - Perl interface to the Oracle Perl External Procedure Library

SYNOPSIS

  use ExtProc;

DESCRIPTION

The ExtProc module provides several functions that return useful data from an Oracle database connection. It is only useful from the Oracle Perl External Procedure Library (extproc_perl).

FUNCTIONS

database_name or DATABASE_NAME (exportable)

Returns the name of the database the client is connected to.

user or USER (exportable)

Returns the username used to connect to Oracle.

sessionid or SESSIONID (exportable)

Returns the session ID of the current connection

exception(message)

Throws a user-defined Oracle exception. Note that the Perl subroutine will probably complete after this function is called, but no return values should be accepted by the calling client.

context (DEPRECATED)

If you are familiar with the pre-0.97 method of using DBI callbacks, see dbi_connect for more information.

dbi_connect()

 use DBI;
 use ExtProc;

 # connect back to the calling database
 my $dbh = ExtProc->dbi_connect();

NOTE: External procedures are stateless, so there is no concept of a persistent connection to the database. Therefore, you must run the DBI->connect method once per transaction.

AUTHOR

Jeff Horwitz <jeff@smashing.org>

SEE ALSO

perl(1), perlembed(1), DBI(3), DBD::Oracle(3)