Description

PowerBuilder 9 supports connection pooling, NCHAR or NVARCHAR2 datatypes, and LOB datatypes with Oracle9i.

Connection pooling

Connection pooling is the use of a group (the pool) of reusable physical connections by several sessions in order to balance loads. The management of the pool is done by OCI, not the application. Connection pooling is not used by default. On the Connection tab page of the Database Profile Setup dialog box for Oracle9i, select the Use Connection Pool check box to turn on connection pooling. You can also set the CnnPool DBParm to Yes.

NCHAR and NVARCHAR2 support

PowerBuilder supports the NCHAR and NVARCHAR2 datatypes when connecting to an Oracle9i server using the pbo9090.dll.

This support is not available for Oracle8i because the DataWindow object is unable to generate a prefix required when sending an ANSI string to an NCHAR or NVARCHAR2 column in a table on an Oracle8i server. The prefix instructs the server to convert data to a Unicode string. Oracle9i servers do not need to convert ANSI strings to UNICODE strings.

For Oracle8i, a client statement might look like this:

Update table1 set C1 = N'NEW STRING' where C1 = N'OLD STRING';

where the datatype of C1 is NCHAR or NVARCHAR2, and the prefix N instructs the Oracle8i server to convert the data to a Unicode string.

LOB output parameter in Oracle stored procedures

Using the pbo9090.dll interface, you can define an LOB (Large OBject) as an output parameter for an Oracle stored procedure or function to retrieve blob data. There is no limit to the number of LOB output parameters that you can define for each stored procedure or function.

ConnectAs DBParm

Oracle9i provides an option to connect with SYSOPER or SYSDBA system privileges if those privileges have been granted to the user. When you connect with SYSDBA or SYSOPER privileges using a username and password, you connect with a default schema, not with the schema that is generally associated with your username. For SYSDBA this schema is SYS; for SYSOPER the schema is PUBLIC. Use the ConnectAs DBParm to specify a connection with SYSOPER or SYSDBA privileges. See the online Help for a description of the ConnectAs DBParm.

For more information

See Connecting to Your Database and the DBParm descriptions in the online Help.