Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » MobiLink - Server Administration » Using MobiLink server technology » MobiLink consolidated databases » Oracle consolidated database


Using Oracle VARRAY

The iAnywhere Solutions 12 - Oracle ODBC driver supports the use of Oracle VARRAY in stored procedures. Using VARRAY in upload scripts (upload_insert, upload_update, and upload_delete) that are written in stored procedures may improve performance of the MobiLink server, compared with upload scripts written in stored procedures that do not use VARRAY. Simple SQL statements such as INSERT, UPDATE and DELETE without stored procedures usually offer the best performance, however using stored procedures, including the VARRAY technique, provides an opportunity to apply business logic that the simple statements do not.

 VARRAY example
 VARRAY restrictions