Oracle B12255-01 Manuale Utente

mod_plsql

Oracle HTTP Server Modules

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.

# 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' );

This function sets the default character form for a database handle.

$dbh->func( ORA_NCHAR , 'set_default_form' );

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