oracle oci报错 -3123,ORATCL

NAME

Oratcl - Oracle Database Server access commands for Tcl

INTRODUCTION

Oratcl is a collection of Tcl commands and a Tcl global array that provides access to an Oracle Database Server.Each Oratcl command generally invokes sev e ral Oracle Call Interface (OCI) library functions.Pro-grammers using Oratcl should be familar with basic concepts of OCI programming.

ORATCL COMMANDS

oralogon connect-str

Connect to an Oracle server using connect-str.The connect string should be a valid Oracle con-

nect string, in the form:

name

name/password

name@n:dbname

name/password@n:dbname

A logon handle is returned and should be used for all other Oratcl commands using this connec-

tion that require a logon handle.Multiple connections to the same or different servers are allowed,

up to a maximum of 25 total connections.Oralogon raises a Tcl error if the connection is not

made for any reason (login or password incorrect, network unavailable, etc.).If the connect string

does not include a database speci?cation, the value of the environment variable ORACLE_SID is

used as the server.

oralogoff logon-handle

Logoff from the Oracle server connection associated with logon-handle.Logon-handle must be a

valid handle previously opened with oralogon.Oralogoff returns a null string.Oralogoff raises a

Tcl error if the logon handle speci?ed is not open.

oraopen logon-handle

Open an SQL cursor to the server.Oraopen returns a cursor to be used on subsequent Oratcl com-

mands that require a cursor handle.Logon-handle must be a valid handle previously opened with

oralogon. Multiple cursors can be opened through the same or different logon handles, up to a

maximum of 25 total cursors.Oraopen raises a Tcl error if the logon handle speci?ed is not open.

oraclose cursor-handle

Closes the cursor associated with cursor-handle. Oraclose raises a Tcl error if the cursor handle

speci?ed is not open.

orasql cursor-handle sql-statement ?-parseonly? ?-async?

Send the Oracle SQL statement sql-statement to the server.Cursor-handle must be a valid handle

previously opened with oraopen.Orasql will return the numeric return code "0" on successful

execution of the sql statement.The oramsg array index rc is set with the return code; the rows

index is set to the number of rows affected by the SQL statement in the case of insert, update,or

delete.

The oramsg array index rowid is set with the Oracle ROWID of the last row processed in an

insert, update,or delete statement.

Only a single SQL statement may be speci?ed in sql-statement.Orafetch allows retrieval of return

rows generated.