Special Variables
Oratcl stores information related to its operation in the global
variable oramsg. The variable is an array and
contains the keys described in the following list:
collengthsA list of the column lengths returned by oracols.
colprecsA list of the precision of the numeric columns returned by oracols.
colscalesA list of the scales of the numeric columns returned by oracols.
coltypesA list of the types of the columns returned by oracols.
errortxtThe error message text associated with the last SQL command.
handleThe handle of the last Oratcl command.
maxlongSet to limit the amount of data returned by an orafetch or orareadlong command; default is 32,768 bytes.
nullvalueString value to return for null results. The default value
defaultwill return 0 for numeric types and a null string for others.ocifuncThe numeric Oracle Call Interface (OCI) status code of the last OCI function performed.
ociinfoList of features present in Oracle library when Oratcl was compiled.
peoParse error offset; index into SQL string that failed due to error.
rcNumeric Oracle error number associated with the last SQL command (see the following list).
rowidRow ID of the row affected by SQL insert, update, or delete command.
rowsThe number of rows affected by an SQL insert, update, or delete command or number of rows fetched by orafetch.
sqlfuncThe numeric OCI status code of the last SQL function performed.
versionVersion of Oratcl.
The following are typical error status values returned in the
$oramsg(rc) variable. Refer to the Oracle
documentation for an exhaustive set of codes and messages.
- 0
Normal command completion; no error.
- 900–999
Invalid SQL statements, keywords, column names, etc.
- 1000–1099
Program interface error.
- 1400–1499
Execution errors or feedback.
- 1403
End of data reached on orafetch command.
- 1406
Column fetched by orafetch command was truncated.
- 3123
Asynchronous execution is pending completion (not an error).
One or more of the following features can be returned in the
$oramsg(ociinfo) variable: