OCIexecute


Purpose
Execute an SQL command.
Synopsis
procedure OCIexecute(s:string|text)
procedure OCIexecute(s:string|text, a:array)
procedure OCIexecute(s:string|text, l:list)
procedure OCIexecute(s:string|text, m:set)
Arguments
SQL command to be executed
An array
A list. May be a list of arrays
A set
Example
The following example contains four OCIexecute statements performing the following tasks:
declarations
 prices: array(1001..1004) of real
 colors: array(1001..1004) of string
 allcolors: set of string
end-declarations

OCIexecute("select color from pricelist", allcolors)
OCIexecute("select articlenum,color,price from pricelist",
                                                  [colors,prices])
OCIexecute("create table newtab (ndx integer, price double)")	         
OCIexecute("insert into newtab (ndx, price) values (:1,:2)", prices) 
Further information
1. This procedure executes the given SQL command. The user is referred to the Oracle documentation for further information on PL/SQL.
2. For ouput commands (like insert into) this procedure accepts arrays, sets and lists of basic types (integer, real, string or Boolean) as well as module types for which from/to string convertions are available. Record types composed of scalars or other records can also be used (the fields that cannot be handled are silently ignored). It is also possible to use a list arrays of basic types (all arrays must be indexed by the same sets) or a list of scalar elements of different basic or module types.
3. For input commands (like select from) the same restrictions apply for arrays and list of arrays but lists and sets must be of a basic type.
Related topics
OCIreadinteger, OCIreadreal, OCIreadstring.
Module
mmoci


If you have any comments or suggestions about these pages, please send mail to support@fico.com.

© Copyright 2001-2013 Fair Isaac Corporation. All rights reserved.