Initializing help system before first use

# OCIreadstring

Purpose
Read a string from a database.
Synopsis
`function OCIreadstring(s:string|text):string`
Argument

s | SQL command for selecting the string to be read

Return value
String read or empty string.
Example
The following retrieves the color of the (first) data item in table pricelist with article number 1004:

    s:=OCIreadstring(
           "select color from pricelist where articlenum=1004")

Further information
1. The empty string is returned if no real value can be found.
2. If the given SQL selection command does not denote a single entry, the first string to which the selection criterion applies is returned.
Related topics
OCIexecute, OCIreadinteger, OCIreadreal.
Module
mmoci
Parent Topic Procedures and functions

© 2001-2026 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.