Oracle B12255-01 - Manual (Page 89)

mod_plsql
Oracle HTTP Server Modules 7-19
set_form This function sets the character form for parameter(s). Valid forms are
either ORA_IMPLICIT (default) or ORA_NCHAR. The constants are available as:
ora_forms
in DBD::Oracle.
Example 7–4 Sample for set_form
# a declaration example for the constants ORA_IMPLICIT and ORA_NCHAR
use DBD::Oracle qw(:ora_forms);
# set the character form for the placeholder :nchar1 to NCHAR
$sth->func( { ':nchar1' => ORA_NCHAR } , 'set_form' );
# set the character form using the positional index
$sth->func( { 2 => ORA_NCHAR } , 'set_form' );
# set the character form for multiple placeholders at once
$sth->func( { 1 => ORA_NCHAR, 2 => ORA_NCHAR } , 'set_form' );
set_default_form This function sets the default character form for a database handle.
Example 7–5 Default Character Form for a Database Handle
$dbh->func( ORA_NCHAR , 'set_default_form' );
mod_plsql
This Oracle module connects the Oracle HTTP Server to an Oracle database,
enabling you to create Web applications using Oracle stored procedures.
In order to access a Web-enabled PL/SQL application, configure a PL/SQL
Database Access Descriptor (DAD) for mod_plsql. A DAD is a set of values that
specifies how mod_plsql connects to a database server to fulfill an HTTP request.
Besides the connect details, a DAD contains important configuration parameters for
various operations in the database and for mod_plsql in general. Any
Web-enabled PL/SQL application which makes use of the PL/SQL Web ToolKit
needs to create a DAD to invoke the application.
■
Any PL/SQL Application written using the PL/SQL Web ToolKit
■
Oracle Application Server Portal