Initializing help system before first use

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
s 
SQL command to be executed
a 
An array
l 
A list. May be a list of arrays
m 
A set
Example
The following example contains four OCIexecute statements performing the following tasks:
  • Get all different values of the column color in the table pricelist.
  • Initialize the arrays colors and prices with the values of the columns color and price of the table pricelist.
  • Create a new table newtab in the active database with 2 columns, ndx and price.
  • Add data entries to table newtab. 

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 output 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 conversions 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 of 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,lists and list of arrays but sets must be of a basic type.
Related topics
OCIreadinteger, OCIreadreal, OCIreadstring.
Module
mmoci

Parent Topic Procedures and functions

© 2001-2025 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.