(in-package #:clsql-oracle)
-(defconstant +oci-default+ #x00) ; default value for parameters and attributes
-(defconstant +oci-threaded+ #x01) ; application is in threaded environment
-(defconstant +oci-object+ #x02) ; the application is in object environment
-(defconstant +oci-non-blocking+ #x04) ; non blocking mode of operation
-(defconstant +oci-env-no-mutex+ #x08) ; the environment handle will not be protected by a mutex internally
+(defconstant +oci-default+ #x00) ; default value for parameters and attributes
+(defconstant +oci-threaded+ #x01) ; application is in threaded environment
+(defconstant +oci-object+ #x02) ; the application is in object environment
+(defconstant +oci-non-blocking+ #x04) ; non blocking mode of operation
+(defconstant +oci-env-no-mutex+ #x08) ; the environment handle will not be protected by a mutex internally
;; Handle types
-(defconstant +oci-htype-env+ 1) ; environment handle
-(defconstant +oci-htype-error+ 2) ; error handle
-(defconstant +oci-htype-svcctx+ 3) ; service handle
-(defconstant +oci-htype-stmt+ 4) ; statement handle
-(defconstant +oci-htype-bind+ 5) ; bind handle
-(defconstant +oci-htype-define+ 6) ; define handle
-(defconstant +oci-htype-describe+ 7) ; describe handle
-(defconstant +oci-htype-server+ 8) ; server handle
-(defconstant +oci-htype-session+ 9) ; authentication handle
-(defconstant +oci-htype-trans+ 10) ; transaction handle
+(defconstant +oci-htype-env+ 1) ; environment handle
+(defconstant +oci-htype-error+ 2) ; error handle
+(defconstant +oci-htype-svcctx+ 3) ; service handle
+(defconstant +oci-htype-stmt+ 4) ; statement handle
+(defconstant +oci-htype-bind+ 5) ; bind handle
+(defconstant +oci-htype-define+ 6) ; define handle
+(defconstant +oci-htype-describe+ 7) ; describe handle
+(defconstant +oci-htype-server+ 8) ; server handle
+(defconstant +oci-htype-session+ 9) ; authentication handle
+(defconstant +oci-htype-trans+ 10) ; transaction handle
(defconstant +oci-htype-complexobject+ 11) ; complex object retrieval handle
-(defconstant +oci-htype-security+ 12) ; security handle
+(defconstant +oci-htype-security+ 12) ; security handle
;; Descriptor types
-(defconstant +oci-dtype-lob+ 50) ; lob locator
-(defconstant +oci-dtype-snap+ 51) ; snapshot
-(defconstant +oci-dtype-rset+ 52) ; result set
-(defconstant +oci-dtype-param+ 53) ; parameter descriptor obtained from ocigparm
+(defconstant +oci-dtype-lob+ 50) ; lob locator
+(defconstant +oci-dtype-snap+ 51) ; snapshot
+(defconstant +oci-dtype-rset+ 52) ; result set
+(defconstant +oci-dtype-param+ 53) ; parameter descriptor obtained from ocigparm
(defconstant +oci-dtype-rowid+ 54) ; rowid
(defconstant +oci-dtype-complexobjectcomp+ 55) ; complex object retrieval descriptor
-(defconstant +oci-dtype-file+ 56) ; File Lob locator
+(defconstant +oci-dtype-file+ 56) ; File Lob locator
(defconstant +oci-dtype-aqenq-options+ 57) ; enqueue options
(defconstant +oci-dtype-aqdeq-options+ 58) ; dequeue options
(defconstant +oci-dtype-aqmsg-properties+ 59) ; message properties
;; Objectr pointer types
-(defconstant +oci-otype-name+ 1) ; object name
-(defconstant +oci-otype-ref+ 2) ; REF to TDO
-(defconstant +oci-otype-ptr+ 3) ; PTR to TDO
+(defconstant +oci-otype-name+ 1) ; object name
+(defconstant +oci-otype-ref+ 2) ; REF to TDO
+(defconstant +oci-otype-ptr+ 3) ; PTR to TDO
;; Attribute types
;; AQ Attribute Types
;; Enqueue Options
-(defconstant +oci-attr-visibility+ 47) ; visibility
+(defconstant +oci-attr-visibility+ 47) ; visibility
(defconstant +oci-attr-relative-msgid+ 48) ; relative message id
(defconstant +oci-attr-sequence-deviation+ 49) ; sequence deviation
; - Dequeue Options -
; consumer name
;#define OCI-ATTR-DEQ-MODE 50
-;(defconstant +OCI-ATTR-CONSUMER-NAME 50 + 51) ; dequeue mode
-;#define OCI-ATTR-NAVIGATION 52 ; navigation
-;#define OCI-ATTR-WAIT 53 ; wait
-;#define OCI-ATTR-DEQ-MSGID 54 ; dequeue message id
+;(defconstant +OCI-ATTR-CONSUMER-NAME 50 + 51) ; dequeue mode
+;#define OCI-ATTR-NAVIGATION 52 ; navigation
+;#define OCI-ATTR-WAIT 53 ; wait
+;#define OCI-ATTR-DEQ-MSGID 54 ; dequeue message id
; - Message Properties -
-(defconstant +OCI-ATTR-PRIORITY+ 55) ; priority
-(defconstant +OCI-ATTR-DELAY+ 56) ; delay
-(defconstant +OCI-ATTR-EXPIRATION+ 57) ; expiration
-(defconstant +OCI-ATTR-CORRELATION+ 58) ; correlation id
-(defconstant +OCI-ATTR-ATTEMPTS+ 59) ; # of attempts
+(defconstant +OCI-ATTR-PRIORITY+ 55) ; priority
+(defconstant +OCI-ATTR-DELAY+ 56) ; delay
+(defconstant +OCI-ATTR-EXPIRATION+ 57) ; expiration
+(defconstant +OCI-ATTR-CORRELATION+ 58) ; correlation id
+(defconstant +OCI-ATTR-ATTEMPTS+ 59) ; # of attempts
(defconstant +OCI-ATTR-RECIPIENT-LIST+ 60) ; recipient list
(defconstant +OCI-ATTR-EXCEPTION-QUEUE+ 61) ; exception queue name
-(defconstant +OCI-ATTR-ENQ-TIME+ 62) ; enqueue time (only OCIAttrGet)
-(defconstant +OCI-ATTR-MSG-STATE+ 63) ; message state (only OCIAttrGet)
+(defconstant +OCI-ATTR-ENQ-TIME+ 62) ; enqueue time (only OCIAttrGet)
+(defconstant +OCI-ATTR-MSG-STATE+ 63) ; message state (only OCIAttrGet)
;; AQ Agent
-(defconstant +OCI-ATTR-AGENT-NAME+ 64) ; agent name
+(defconstant +OCI-ATTR-AGENT-NAME+ 64) ; agent name
(defconstant +OCI-ATTR-AGENT-ADDRESS+ 65) ; agent address
(defconstant +OCI-ATTR-AGENT-PROTOCOL+ 66) ; agent protocol
;- Server handle -
-(defconstant +OCI-ATTR-NATIVE-FDES+ 67) ; native cncxn file desc
+(defconstant +OCI-ATTR-NATIVE-FDES+ 67) ; native cncxn file desc
;-Parameter Attribute Types-
-(defconstant +OCI-ATTR-UNK+ 101) ; unknown attribute
-(defconstant +OCI-ATTR-NUM-COLS+ 102) ; number of columns
+(defconstant +OCI-ATTR-UNK+ 101) ; unknown attribute
+(defconstant +OCI-ATTR-NUM-COLS+ 102) ; number of columns
(defconstant +OCI-ATTR-LIST-COLUMNS+ 103) ; parameter of the column list
-(defconstant +OCI-ATTR-RDBA+ 104) ; DBA of the segment header
-(defconstant +OCI-ATTR-CLUSTERED+ 105) ; whether the table is clustered
+(defconstant +OCI-ATTR-RDBA+ 104) ; DBA of the segment header
+(defconstant +OCI-ATTR-CLUSTERED+ 105) ; whether the table is clustered
(defconstant +OCI-ATTR-PARTITIONED+ 106) ; whether the table is partitioned
-(defconstant +OCI-ATTR-INDEX-ONLY+ 107) ; whether the table is index only
+(defconstant +OCI-ATTR-INDEX-ONLY+ 107) ; whether the table is index only
(defconstant +OCI-ATTR-LIST-ARGUMENTS+ 108) ; parameter of the argument list
(defconstant +OCI-ATTR-LIST-SUBPROGRAMS+ 109) ; parameter of the subprogram list
-(defconstant +OCI-ATTR-REF-TDO+ 110) ; REF to the type descriptor
-(defconstant +OCI-ATTR-LINK+ 111) ; the database link name
-(defconstant +OCI-ATTR-MIN+ 112) ; minimum value
-(defconstant +OCI-ATTR-MAX+ 113) ; maximum value
-(defconstant +OCI-ATTR-INCR+ 114) ; increment value
-(defconstant +OCI-ATTR-CACHE+ 115) ; number of sequence numbers cached
-(defconstant +OCI-ATTR-ORDER+ 116) ; whether the sequence is ordered
-(defconstant +OCI-ATTR-HW-MARK+ 117) ; high-water mark
+(defconstant +OCI-ATTR-REF-TDO+ 110) ; REF to the type descriptor
+(defconstant +OCI-ATTR-LINK+ 111) ; the database link name
+(defconstant +OCI-ATTR-MIN+ 112) ; minimum value
+(defconstant +OCI-ATTR-MAX+ 113) ; maximum value
+(defconstant +OCI-ATTR-INCR+ 114) ; increment value
+(defconstant +OCI-ATTR-CACHE+ 115) ; number of sequence numbers cached
+(defconstant +OCI-ATTR-ORDER+ 116) ; whether the sequence is ordered
+(defconstant +OCI-ATTR-HW-MARK+ 117) ; high-water mark
(defconstant +OCI-ATTR-TYPE-SCHEMA+ 118) ; type's schema name
-(defconstant +OCI-ATTR-TIMESTAMP+ 119) ; timestamp of the object
-(defconstant +OCI-ATTR-NUM-ATTRS+ 120) ; number of sttributes
-(defconstant +OCI-ATTR-NUM-PARAMS+ 121) ; number of parameters
-(defconstant +OCI-ATTR-OBJID+ 122) ; object id for a table or view
-(defconstant +OCI-ATTR-PTYPE+ 123) ; type of info described by
-(defconstant +OCI-ATTR-PARAM+ 124) ; parameter descriptor
+(defconstant +OCI-ATTR-TIMESTAMP+ 119) ; timestamp of the object
+(defconstant +OCI-ATTR-NUM-ATTRS+ 120) ; number of sttributes
+(defconstant +OCI-ATTR-NUM-PARAMS+ 121) ; number of parameters
+(defconstant +OCI-ATTR-OBJID+ 122) ; object id for a table or view
+(defconstant +OCI-ATTR-PTYPE+ 123) ; type of info described by
+(defconstant +OCI-ATTR-PARAM+ 124) ; parameter descriptor
(defconstant +OCI-ATTR-OVERLOAD-ID+ 125) ; overload ID for funcs and procs
-(defconstant +OCI-ATTR-TABLESPACE+ 126) ; table name space
-(defconstant +OCI-ATTR-TDO+ 127) ; TDO of a type
-(defconstant +OCI-ATTR-PARSE-ERROR-OFFSET+ 128) ; Parse Error offset
+(defconstant +OCI-ATTR-TABLESPACE+ 126) ; table name space
+(defconstant +OCI-ATTR-TDO+ 127) ; TDO of a type
+(defconstant +OCI-ATTR-PARSE-ERROR-OFFSET+ 128) ; Parse Error offset
;-Credential Types-
-(defconstant +OCI-CRED-RDBMS+ 1) ; database username/password
-(defconstant +OCI-CRED-EXT+ 2) ; externally provided credentials
+(defconstant +OCI-CRED-RDBMS+ 1) ; database username/password
+(defconstant +OCI-CRED-EXT+ 2) ; externally provided credentials
;; Error Return Values-
-(defconstant +oci-continue+ -24200) ; Continue with the body of the OCI function
+(defconstant +oci-continue+ -24200) ; Continue with the body of the OCI function
(defconstant +oci-still-executing+ -3123) ; OCI would block error
-(defconstant +oci-invalid-handle+ -2) ; maps to SQL-INVALID-HANDLE
+(defconstant +oci-invalid-handle+ -2) ; maps to SQL-INVALID-HANDLE
(defconstant +oci-error+ -1) ; maps to SQL-ERROR
(defconstant +oci-success+ 0) ; maps to SQL-SUCCESS of SAG CLI
(defconstant +oci-success-with-info+ 1) ; maps to SQL-SUCCESS-WITH-INFO
-(defconstant +oci-need-data+ 99) ; maps to SQL-NEED-DATA
+(defconstant +oci-need-data+ 99) ; maps to SQL-NEED-DATA
(defconstant +oci-no-data+ 100) ; maps to SQL-NO-DATA
;; Parsing Syntax Types-
-(defconstant +oci-ntv-syntax+ 1) ; Use what so ever is the native lang of server
-(defconstant +oci-v7-syntax+ 2) ; V7 language
-(defconstant +oci-v8-syntax+ 3) ; V8 language
+(defconstant +oci-ntv-syntax+ 1) ; Use what so ever is the native lang of server
+(defconstant +oci-v7-syntax+ 2) ; V7 language
+(defconstant +oci-v8-syntax+ 3) ; V8 language
;-Scrollable Cursor Options-
;-Bind and Define Options-
-(defconstant +OCI-SB2-IND-PTR+ #x01) ; unused
-(defconstant +OCI-DATA-AT-EXEC+ #x02) ; data at execute time
-(defconstant +OCI-DYNAMIC-FETCH+ #x02) ; fetch dynamically
-(defconstant +OCI-PIECEWISE+ #x04) ; piecewise DMLs or fetch
+(defconstant +OCI-SB2-IND-PTR+ #x01) ; unused
+(defconstant +OCI-DATA-AT-EXEC+ #x02) ; data at execute time
+(defconstant +OCI-DYNAMIC-FETCH+ #x02) ; fetch dynamically
+(defconstant +OCI-PIECEWISE+ #x04) ; piecewise DMLs or fetch
;-
;-Execution Modes-
-(defconstant +OCI-BATCH-MODE+ #x01) ; batch the oci statement for execution
-(defconstant +OCI-EXACT-FETCH+ #x02) ; fetch the exact rows specified
+(defconstant +OCI-BATCH-MODE+ #x01) ; batch the oci statement for execution
+(defconstant +OCI-EXACT-FETCH+ #x02) ; fetch the exact rows specified
(defconstant +OCI-KEEP-FETCH-STATE+ #x04) ; unused
(defconstant +OCI-SCROLLABLE-CURSOR+ #x08) ; cursor scrollable
-(defconstant +OCI-DESCRIBE-ONLY+ #x10) ; only describe the statement
+(defconstant +OCI-DESCRIBE-ONLY+ #x10) ; only describe the statement
(defconstant +OCI-COMMIT-ON-SUCCESS+ #x20) ; commit, if successful execution
;-
;-Authentication Modes-
-(defconstant +OCI-MIGRATE+ #x0001) ; migratable auth context
-(defconstant +OCI-SYSDBA+ #x0002) ; for SYSDBA authorization
-(defconstant +OCI-SYSOPER+ #x0004) ; for SYSOPER authorization
-(defconstant +OCI-PRELIM-AUTH+ #x0008) ; for preliminary authorization
+(defconstant +OCI-MIGRATE+ #x0001) ; migratable auth context
+(defconstant +OCI-SYSDBA+ #x0002) ; for SYSDBA authorization
+(defconstant +OCI-SYSOPER+ #x0004) ; for SYSOPER authorization
+(defconstant +OCI-PRELIM-AUTH+ #x0008) ; for preliminary authorization
;-
;-Piece Information-
-(defconstant +OCI-PARAM-IN+ #x01) ; in parameter
-(defconstant +OCI-PARAM-OUT+ #x02) ; out parameter
+(defconstant +OCI-PARAM-IN+ #x01) ; in parameter
+(defconstant +OCI-PARAM-OUT+ #x02) ; out parameter
;-
;- Transaction Start Flags -
(defconstant +OCI-TRANS-JOIN+ #x00000002) ; join an existing transaction
(defconstant +OCI-TRANS-RESUME+ #x00000004) ; resume this transaction
(defconstant +OCI-TRANS-STARTMASK+ #x000000ff)
-
-
+
+
(defconstant +OCI-TRANS-READONLY+ #x00000100) ; starts a readonly transaction
(defconstant +OCI-TRANS-READWRITE+ #x00000200) ; starts a read-write transaction
(defconstant +OCI-TRANS-SERIALIZABLE+ #x00000400)
- ; starts a serializable transaction
+ ; starts a serializable transaction
(defconstant +OCI-TRANS-ISOLMASK+ #x0000ff00)
(defconstant +OCI-TRANS-LOOSE+ #x00010000) ; a loosely coupled branch
;; NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE
; - Visibility flags -
-(defconstant +OCI-ENQ-IMMEDIATE+ 1) ; enqueue is an independent transaction
-(defconstant +OCI-ENQ-ON-COMMIT+ 2) ; enqueue is part of current transaction
+(defconstant +OCI-ENQ-IMMEDIATE+ 1) ; enqueue is an independent transaction
+(defconstant +OCI-ENQ-ON-COMMIT+ 2) ; enqueue is part of current transaction
; - Dequeue mode flags -
-(defconstant +OCI-DEQ-BROWSE+ 1) ; read message without acquiring a lock
-(defconstant +OCI-DEQ-LOCKED+ 2) ; read and obtain write lock on message
-(defconstant +OCI-DEQ-REMOVE+ 3) ; read the message and delete it
+(defconstant +OCI-DEQ-BROWSE+ 1) ; read message without acquiring a lock
+(defconstant +OCI-DEQ-LOCKED+ 2) ; read and obtain write lock on message
+(defconstant +OCI-DEQ-REMOVE+ 3) ; read the message and delete it
; - Dequeue navigation flags -
(defconstant +OCI-DEQ-FIRST-MSG+ 1) ; get first message at head of queue
-(defconstant +OCI-DEQ-NEXT-MSG+ 3) ; next message that is available
+(defconstant +OCI-DEQ-NEXT-MSG+ 3) ; next message that is available
(defconstant +OCI-DEQ-NEXT-TRANSACTION+ 2) ; get first message of next txn group
; - Message states -
-(defconstant +OCI-MSG-WAITING+ 1) ; the message delay has not yet completed
-(defconstant +OCI-MSG-READY+ 0) ; the message is ready to be processed
-(defconstant +OCI-MSG-PROCESSED+ 2) ; the message has been processed
-(defconstant +OCI-MSG-EXPIRED+ 3) ; message has moved to exception queue
+(defconstant +OCI-MSG-WAITING+ 1) ; the message delay has not yet completed
+(defconstant +OCI-MSG-READY+ 0) ; the message is ready to be processed
+(defconstant +OCI-MSG-PROCESSED+ 2) ; the message has been processed
+(defconstant +OCI-MSG-EXPIRED+ 3) ; message has moved to exception queue
; - Sequence deviation -
-(defconstant +OCI-ENQ-BEFORE+ 2) ; enqueue message before another message
-(defconstant +OCI-ENQ-TOP+ 3) ; enqueue message before all messages
+(defconstant +OCI-ENQ-BEFORE+ 2) ; enqueue message before another message
+(defconstant +OCI-ENQ-TOP+ 3) ; enqueue message before all messages
; - Visibility flags -
-(defconstant +OCI-DEQ-IMMEDIATE+ 1) ; dequeue is an independent transaction
-(defconstant +OCI-DEQ-ON-COMMIT+ 2) ; dequeue is part of current transaction
+(defconstant +OCI-DEQ-IMMEDIATE+ 1) ; dequeue is an independent transaction
+(defconstant +OCI-DEQ-ON-COMMIT+ 2) ; dequeue is part of current transaction
; - Wait -
-(defconstant +OCI-DEQ-WAIT-FOREVER+ -1) ; wait forever if no message available
-(defconstant +OCI-DEQ-NO-WAIT+ 0) ; do not wait if no message is available
+(defconstant +OCI-DEQ-WAIT-FOREVER+ -1) ; wait forever if no message available
+(defconstant +OCI-DEQ-NO-WAIT+ 0) ; do not wait if no message is available
; - Delay -
-(defconstant +OCI-MSG-NO-DELAY+ 0) ; message is available immediately
+(defconstant +OCI-MSG-NO-DELAY+ 0) ; message is available immediately
;; Expiration
(defconstant +OCI-MSG-NO-EXPIRATION+ -1) ; message will never expire
;; Describe Handle Parameter Attributes
;; Attributes common to Columns and Stored Procs
-(defconstant +oci-attr-data-size+ 1) ; maximum size of the data
-(defconstant +oci-attr-data-type+ 2) ; the sql type of the column/argument
-(defconstant +oci-attr-disp-size+ 3) ; the display size
+(defconstant +oci-attr-data-size+ 1) ; maximum size of the data
+(defconstant +oci-attr-data-type+ 2) ; the sql type of the column/argument
+(defconstant +oci-attr-disp-size+ 3) ; the display size
(defconstant +oci-attr-name+ 4) ; the name of the column/argument
-(defconstant +oci-attr-precision+ 5) ; precision if number type
-(defconstant +oci-attr-scale+ 6) ; scale if number type
-(defconstant +oci-attr-is-null+ 7) ; is it null ?
+(defconstant +oci-attr-precision+ 5) ; precision if number type
+(defconstant +oci-attr-scale+ 6) ; scale if number type
+(defconstant +oci-attr-is-null+ 7) ; is it null ?
(defconstant +oci-attr-type-name+ 8)
;; name of the named data type or a package name for package private types
-(defconstant +OCI-ATTR-SCHEMA-NAME+ 9) ; the schema name
-(defconstant +OCI-ATTR-SUB-NAME+ 10) ; type name if package private type
-(defconstant +OCI-ATTR-POSITION+ 11) ; relative position of col/arg in the list of cols/args
+(defconstant +OCI-ATTR-SCHEMA-NAME+ 9) ; the schema name
+(defconstant +OCI-ATTR-SUB-NAME+ 10) ; type name if package private type
+(defconstant +OCI-ATTR-POSITION+ 11) ; relative position of col/arg in the list of cols/args
; complex object retrieval parameter attributes
(defconstant +OCI-ATTR-COMPLEXOBJECTCOMP-TYPE+ 50) ;
(defconstant +OCI-ATTR-COMPLEXOBJECT-COLL-OUTOFLINE+ 53) ;
; Only Columns
-(defconstant +OCI-ATTR-DISP-NAME+ 100) ; the display name
+(defconstant +OCI-ATTR-DISP-NAME+ 100) ; the display name
;; stored procs
-(defconstant +OCI-ATTR-OVERLOAD+ 210) ; is this position overloaded
-(defconstant +OCI-ATTR-LEVEL+ 211) ; level for structured types
+(defconstant +OCI-ATTR-OVERLOAD+ 210) ; is this position overloaded
+(defconstant +OCI-ATTR-LEVEL+ 211) ; level for structured types
(defconstant +OCI-ATTR-HAS-DEFAULT+ 212) ; has a default value
-(defconstant +OCI-ATTR-IOMODE+ 213) ; in, out inout
-(defconstant +OCI-ATTR-RADIX+ 214) ; returns a radix
-(defconstant +OCI-ATTR-NUM-ARGS+ 215) ; total number of arguments
+(defconstant +OCI-ATTR-IOMODE+ 213) ; in, out inout
+(defconstant +OCI-ATTR-RADIX+ 214) ; returns a radix
+(defconstant +OCI-ATTR-NUM-ARGS+ 215) ; total number of arguments
;; named type attributes
(defconstant +oci-attr-order-method+ 233) ; order method of type
; only collection element
-(defconstant +OCI-ATTR-NUM-ELEMS+ 234) ; number of elements
+(defconstant +OCI-ATTR-NUM-ELEMS+ 234) ; number of elements
; only type methods
(defconstant +OCI-ATTR-ENCAPSULATION+ 235) ; encapsulation level
-(defconstant +OCI-ATTR-IS-SELFISH+ 236) ; method selfish
-(defconstant +OCI-ATTR-IS-VIRTUAL+ 237) ; virtual
-(defconstant +OCI-ATTR-IS-INLINE+ 238) ; inline
+(defconstant +OCI-ATTR-IS-SELFISH+ 236) ; method selfish
+(defconstant +OCI-ATTR-IS-VIRTUAL+ 237) ; virtual
+(defconstant +OCI-ATTR-IS-INLINE+ 238) ; inline
(defconstant +OCI-ATTR-IS-CONSTANT+ 239) ; constant
-(defconstant +OCI-ATTR-HAS-RESULT+ 240) ; has result
+(defconstant +OCI-ATTR-HAS-RESULT+ 240) ; has result
(defconstant +OCI-ATTR-IS-CONSTRUCTOR+ 241) ; constructor
(defconstant +OCI-ATTR-IS-DESTRUCTOR+ 242) ; destructor
(defconstant +OCI-ATTR-IS-OPERATOR+ 243) ; operator
-(defconstant +OCI-ATTR-IS-MAP+ 244) ; a map method
-(defconstant +OCI-ATTR-IS-ORDER+ 245) ; order method
-(defconstant +OCI-ATTR-IS-RNDS+ 246) ; read no data state method
-(defconstant +OCI-ATTR-IS-RNPS+ 247) ; read no process state
-(defconstant +OCI-ATTR-IS-WNDS+ 248) ; write no data state method
-(defconstant +OCI-ATTR-IS-WNPS+ 249) ; write no process state
+(defconstant +OCI-ATTR-IS-MAP+ 244) ; a map method
+(defconstant +OCI-ATTR-IS-ORDER+ 245) ; order method
+(defconstant +OCI-ATTR-IS-RNDS+ 246) ; read no data state method
+(defconstant +OCI-ATTR-IS-RNPS+ 247) ; read no process state
+(defconstant +OCI-ATTR-IS-WNDS+ 248) ; write no data state method
+(defconstant +OCI-ATTR-IS-WNPS+ 249) ; write no process state
; describing public objects
(defconstant +OCI-ATTR-DESC-PUBLIC+ 250) ; public object
;-
;-OCIPasswordChange-
-(defconstant +OCI-AUTH+ #x08) ; Change the password but do not login
+(defconstant +OCI-AUTH+ #x08) ; Change the password but do not login
;-Other Constants-
-(defconstant +OCI-MAX-FNS+ 100) ; max number of OCI Functions
-(defconstant +OCI-SQLSTATE-SIZE+ 5) ;
+(defconstant +OCI-MAX-FNS+ 100) ; max number of OCI Functions
+(defconstant +OCI-SQLSTATE-SIZE+ 5) ;
(defconstant +OCI-ERROR-MAXMSG-SIZE+ 1024) ; max size of an error message
-;; (defconstant +OCI-LOBMAXSIZE+ 4MAXVAL) ; maximum lob data size
-(defconstant +OCI-ROWID-LEN+ 23) ;
+;; (defconstant +OCI-LOBMAXSIZE+ 4MAXVAL) ; maximum lob data size
+(defconstant +OCI-ROWID-LEN+ 23) ;
;-
;- Fail Over Events -
-(defconstant +OCI-FO-END+ #x00000001) ;
-(defconstant +OCI-FO-ABORT+ #x00000002) ;
+(defconstant +OCI-FO-END+ #x00000001) ;
+(defconstant +OCI-FO-ABORT+ #x00000002) ;
(defconstant +OCI-FO-REAUTH+ #x00000004) ;
-(defconstant +OCI-FO-BEGIN+ #x00000008) ;
+(defconstant +OCI-FO-BEGIN+ #x00000008) ;
(defconstant +OCI-FO-ERROR+ #x00000010) ;
;-
;- Fail Over Types -
-(defconstant +OCI-FO-NONE+ #x00000001) ;
+(defconstant +OCI-FO-NONE+ #x00000001) ;
(defconstant +OCI-FO-SESSION+ #x00000002) ;
(defconstant +OCI-FO-SELECT+ #x00000004) ;
(defconstant +OCI-FO-TXNAL+ #x00000008) ;
;-
;-Function Codes-
-(defconstant +OCI-FNCODE-INITIALIZE+ 1) ; OCIInitialize
+(defconstant +OCI-FNCODE-INITIALIZE+ 1) ; OCIInitialize
(defconstant +OCI-FNCODE-HANDLEALLOC+ 2) ; OCIHandleAlloc
-(defconstant +OCI-FNCODE-HANDLEFREE+ 3) ; OCIHandleFree
+(defconstant +OCI-FNCODE-HANDLEFREE+ 3) ; OCIHandleFree
(defconstant +OCI-FNCODE-DESCRIPTORALLOC+ 4) ; OCIDescriptorAlloc
(defconstant +OCI-FNCODE-DESCRIPTORFREE+ 5) ; OCIDescriptorFree
-(defconstant +OCI-FNCODE-ENVINIT+ 6) ; OCIEnvInit
+(defconstant +OCI-FNCODE-ENVINIT+ 6) ; OCIEnvInit
(defconstant +OCI-FNCODE-SERVERATTACH+ 7) ; OCIServerAttach
(defconstant +OCI-FNCODE-SERVERDETACH+ 8) ; OCIServerDetach
-; unused 9
+; unused 9
(defconstant +OCI-FNCODE-SESSIONBEGIN+ 10) ; OCISessionBegin
(defconstant +OCI-FNCODE-SESSIONEND+ 11) ; OCISessionEnd
(defconstant +OCI-FNCODE-PASSWORDCHANGE+ 12) ; OCIPasswordChange
(defconstant +OCI-FNCODE-BINDDYNAMIC+ 17) ; OCIBindDynamic
(defconstant +OCI-FNCODE-BINDOBJECT+ 18) ; OCIBindObject
; 19 unused
-(defconstant +OCI-FNCODE-BINDARRAYOFSTRUCT+ 20) ; OCIBindArrayOfStruct
+(defconstant +OCI-FNCODE-BINDARRAYOFSTRUCT+ 20) ; OCIBindArrayOfStruct
(defconstant +OCI-FNCODE-STMTEXECUTE+ 21) ; OCIStmtExecute
; unused 22-24
(defconstant +OCI-FNCODE-DEFINEOBJECT+ 25) ; OCIDefineObject
(defconstant +OCI-FNCODE-DEFINEDYNAMIC+ 26) ; OCIDefineDynamic
(defconstant +OCI-FNCODE-DEFINEARRAYOFSTRUCT+ 27) ; OCIDefineArrayOfStruct
-(defconstant +OCI-FNCODE-STMTFETCH+ 28) ; OCIStmtFetch
+(defconstant +OCI-FNCODE-STMTFETCH+ 28) ; OCIStmtFetch
(defconstant +OCI-FNCODE-STMTGETBIND+ 29) ; OCIStmtGetBindInfo
; 30, 31 unused
(defconstant +OCI-FNCODE-DESCRIBEANY+ 32) ; OCIDescribeAny
(defconstant +OCI-FNCODE-TRANSDETACH+ 34) ; OCITransDetach
(defconstant +OCI-FNCODE-TRANSCOMMIT+ 35) ; OCITransCommit
; 36 unused
-(defconstant +OCI-FNCODE-ERRORGET+ 37) ; OCIErrorGet
+(defconstant +OCI-FNCODE-ERRORGET+ 37) ; OCIErrorGet
(defconstant +OCI-FNCODE-LOBOPENFILE+ 38) ; OCILobFileOpen
(defconstant +OCI-FNCODE-LOBCLOSEFILE+ 39) ; OCILobFileClose
; 40 was LOBCREATEFILE, unused
; 41 was OCILobFileDelete, unused
-(defconstant +OCI-FNCODE-LOBCOPY+ 42) ; OCILobCopy
-(defconstant +OCI-FNCODE-LOBAPPEND+ 43) ; OCILobAppend
-(defconstant +OCI-FNCODE-LOBERASE+ 44) ; OCILobErase
-(defconstant +OCI-FNCODE-LOBLENGTH+ 45) ; OCILobGetLength
-(defconstant +OCI-FNCODE-LOBTRIM+ 46) ; OCILobTrim
-(defconstant +OCI-FNCODE-LOBREAD+ 47) ; OCILobRead
-(defconstant +OCI-FNCODE-LOBWRITE+ 48) ; OCILobWrite
+(defconstant +OCI-FNCODE-LOBCOPY+ 42) ; OCILobCopy
+(defconstant +OCI-FNCODE-LOBAPPEND+ 43) ; OCILobAppend
+(defconstant +OCI-FNCODE-LOBERASE+ 44) ; OCILobErase
+(defconstant +OCI-FNCODE-LOBLENGTH+ 45) ; OCILobGetLength
+(defconstant +OCI-FNCODE-LOBTRIM+ 46) ; OCILobTrim
+(defconstant +OCI-FNCODE-LOBREAD+ 47) ; OCILobRead
+(defconstant +OCI-FNCODE-LOBWRITE+ 48) ; OCILobWrite
; 49 unused
(defconstant +OCI-FNCODE-SVCCTXBREAK+ 50) ; OCIBreak
(defconstant +OCI-FNCODE-SERVERVERSION+ 51) ; OCIServerVersion
; unused 52, 53
-(defconstant +OCI-FNCODE-ATTRGET+ 54) ; OCIAttrGet
-(defconstant +OCI-FNCODE-ATTRSET+ 55) ; OCIAttrSet
-(defconstant +OCI-FNCODE-PARAMSET+ 56) ; OCIParamSet
-(defconstant +OCI-FNCODE-PARAMGET+ 57) ; OCIParamGet
+(defconstant +OCI-FNCODE-ATTRGET+ 54) ; OCIAttrGet
+(defconstant +OCI-FNCODE-ATTRSET+ 55) ; OCIAttrSet
+(defconstant +OCI-FNCODE-PARAMSET+ 56) ; OCIParamSet
+(defconstant +OCI-FNCODE-PARAMGET+ 57) ; OCIParamGet
(defconstant +OCI-FNCODE-STMTGETPIECEINFO+ 58) ; OCIStmtGetPieceInfo
(defconstant +OCI-FNCODE-LDATOSVCCTX+ 59) ; OCILdaToSvcCtx
; 60 unused
(defconstant +OCI-FNCODE-TRANSPREPARE+ 63) ; OCITransPrepare
(defconstant +OCI-FNCODE-TRANSROLLBACK+ 64) ; OCITransRollback
(defconstant +OCI-FNCODE-DEFINEBYPOS+ 65) ; OCIDefineByPos
-(defconstant +OCI-FNCODE-BINDBYPOS+ 66) ; OCIBindByPos
+(defconstant +OCI-FNCODE-BINDBYPOS+ 66) ; OCIBindByPos
(defconstant +OCI-FNCODE-BINDBYNAME+ 67) ; OCIBindByName
-(defconstant +OCI-FNCODE-LOBASSIGN+ 68) ; OCILobAssign
+(defconstant +OCI-FNCODE-LOBASSIGN+ 68) ; OCILobAssign
(defconstant +OCI-FNCODE-LOBISEQUAL+ 69) ; OCILobIsEqual
-(defconstant +OCI-FNCODE-LOBISINIT+ 70) ; OCILobLocatorIsInit
+(defconstant +OCI-FNCODE-LOBISINIT+ 70) ; OCILobLocatorIsInit
; 71 was lob locator size in beta2
(defconstant +OCI-FNCODE-LOBENABLEBUFFERING+ 71) ; OCILobEnableBuffering
(defconstant +OCI-FNCODE-LOBCHARSETID+ 72) ; OCILobCharSetID
(defconstant +OCI-FNCODE-LOBCHARSETFORM+ 73) ; OCILobCharSetForm
(defconstant +OCI-FNCODE-LOBFILESETNAME+ 74) ; OCILobFileSetName
(defconstant +OCI-FNCODE-LOBFILEGETNAME+ 75) ; OCILobFileGetName
-(defconstant +OCI-FNCODE-LOGON+ 76) ; OCILogon
-(defconstant +OCI-FNCODE-LOGOFF+ 77) ; OCILogoff
+(defconstant +OCI-FNCODE-LOGON+ 76) ; OCILogon
+(defconstant +OCI-FNCODE-LOGOFF+ 77) ; OCILogoff
(defconstant +OCI-FNCODE-LOBDISABLEBUFFERING+ 78) ; OCILobDisableBuffering
(defconstant +OCI-FNCODE-LOBFLUSHBUFFER+ 79) ; OCILobFlushBuffer
(defconstant +OCI-FNCODE-LOBLOADFROMFILE+ 80) ; OCILobLoadFromFile
;-
;- FILE open modes -
-(defconstant +OCI-FILE-READONLY+ 1) ; readonly mode open for FILE types
+(defconstant +OCI-FILE-READONLY+ 1) ; readonly mode open for FILE types
;-
;- LOB Buffering Flush Flags -
-(defconstant +OCI-LOB-BUFFER-FREE+ 1) ;
+(defconstant +OCI-LOB-BUFFER-FREE+ 1) ;
(defconstant +OCI-LOB-BUFFER-NOFREE+ 2) ;
;-
;- OCI Statement Types -
-(defconstant +oci-stmt-select+ 1) ; select statement
-(defconstant +oci-stmt-update+ 2) ; update statement
-(defconstant +oci-stmt-delete+ 3) ; delete statement
-(defconstant +oci-stmt-insert+ 4) ; insert statement
-(defconstant +oci-stmt-create+ 5) ; create statement
-(defconstant +oci-stmt-drop+ 6) ; drop statement
-(defconstant +oci-stmt-alter+ 7) ; alter statement
-(defconstant +oci-stmt-begin+ 8) ; begin ... (pl/sql statement)
-(defconstant +oci-stmt-declare+ 9) ; declare .. (pl/sql statement )
+(defconstant +oci-stmt-select+ 1) ; select statement
+(defconstant +oci-stmt-update+ 2) ; update statement
+(defconstant +oci-stmt-delete+ 3) ; delete statement
+(defconstant +oci-stmt-insert+ 4) ; insert statement
+(defconstant +oci-stmt-create+ 5) ; create statement
+(defconstant +oci-stmt-drop+ 6) ; drop statement
+(defconstant +oci-stmt-alter+ 7) ; alter statement
+(defconstant +oci-stmt-begin+ 8) ; begin ... (pl/sql statement)
+(defconstant +oci-stmt-declare+ 9) ; declare .. (pl/sql statement )
;-
;- OCI Parameter Types -
-(defconstant +OCI-PTYPE-UNK+ 0) ; unknown
-(defconstant +OCI-PTYPE-TABLE+ 1) ; table
-(defconstant +OCI-PTYPE-VIEW+ 2) ; view
-(defconstant +OCI-PTYPE-PROC+ 3) ; procedure
-(defconstant +OCI-PTYPE-FUNC+ 4) ; function
-(defconstant +OCI-PTYPE-PKG+ 5) ; package
-(defconstant +OCI-PTYPE-TYPE+ 6) ; user-defined type
-(defconstant +OCI-PTYPE-SYN+ 7) ; synonym
-(defconstant +OCI-PTYPE-SEQ+ 8) ; sequence
-(defconstant +OCI-PTYPE-COL+ 9) ; column
-(defconstant +OCI-PTYPE-ARG+ 10) ; argument
-(defconstant +OCI-PTYPE-LIST+ 11) ; list
-(defconstant +OCI-PTYPE-TYPE-ATTR+ 12) ; user-defined type's attribute
-(defconstant +OCI-PTYPE-TYPE-COLL+ 13) ; collection type's element
+(defconstant +OCI-PTYPE-UNK+ 0) ; unknown
+(defconstant +OCI-PTYPE-TABLE+ 1) ; table
+(defconstant +OCI-PTYPE-VIEW+ 2) ; view
+(defconstant +OCI-PTYPE-PROC+ 3) ; procedure
+(defconstant +OCI-PTYPE-FUNC+ 4) ; function
+(defconstant +OCI-PTYPE-PKG+ 5) ; package
+(defconstant +OCI-PTYPE-TYPE+ 6) ; user-defined type
+(defconstant +OCI-PTYPE-SYN+ 7) ; synonym
+(defconstant +OCI-PTYPE-SEQ+ 8) ; sequence
+(defconstant +OCI-PTYPE-COL+ 9) ; column
+(defconstant +OCI-PTYPE-ARG+ 10) ; argument
+(defconstant +OCI-PTYPE-LIST+ 11) ; list
+(defconstant +OCI-PTYPE-TYPE-ATTR+ 12) ; user-defined type's attribute
+(defconstant +OCI-PTYPE-TYPE-COLL+ 13) ; collection type's element
(defconstant +OCI-PTYPE-TYPE-METHOD+ 14) ; user-defined type's method
-(defconstant +OCI-PTYPE-TYPE-ARG+ 15) ; user-defined type method's argument
+(defconstant +OCI-PTYPE-TYPE-ARG+ 15) ; user-defined type method's argument
(defconstant +OCI-PTYPE-TYPE-RESULT+ 16) ; user-defined type method's result
;-
;- OCI List Types -
-(defconstant +OCI-LTYPE-UNK+ 0) ; unknown
-(defconstant +OCI-LTYPE-COLUMN+ 1) ; column list
-(defconstant +OCI-LTYPE-ARG-PROC+ 2) ; procedure argument list
-(defconstant +OCI-LTYPE-ARG-FUNC+ 3) ; function argument list
-(defconstant +OCI-LTYPE-SUBPRG+ 4) ; subprogram list
-(defconstant +OCI-LTYPE-TYPE-ATTR+ 5) ; type attribute
-(defconstant +OCI-LTYPE-TYPE-METHOD+ 6) ; type method
+(defconstant +OCI-LTYPE-UNK+ 0) ; unknown
+(defconstant +OCI-LTYPE-COLUMN+ 1) ; column list
+(defconstant +OCI-LTYPE-ARG-PROC+ 2) ; procedure argument list
+(defconstant +OCI-LTYPE-ARG-FUNC+ 3) ; function argument list
+(defconstant +OCI-LTYPE-SUBPRG+ 4) ; subprogram list
+(defconstant +OCI-LTYPE-TYPE-ATTR+ 5) ; type attribute
+(defconstant +OCI-LTYPE-TYPE-METHOD+ 6) ; type method
(defconstant +OCI-LTYPE-TYPE-ARG-PROC+ 7) ; type method w/o result argument list
(defconstant +OCI-LTYPE-TYPE-ARG-FUNC+ 8) ; type method w/result argument list
projects / clsql.git / blobdiff