dnrops
/
node-oracledb
mirror of https://github.com/oracle/node-oracledb
1
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity
node-oracledb/test/list.txt

5908 lines
272 KiB
Plaintext
Executable File
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

Overview of node-oracledb functional tests
1. connection.js
1.1 can run SQL query with different output formats
1.1.1 ARRAY format by default
1.1.2 ARRAY format explicitly
1.1.3 OBJECT format
1.1.4 Negative test - invalid outFormat value
1.2 can call PL/SQL procedures
1.2.1 bind parameters in various ways
1.3 statementCacheSize controls statement caching
1.3.1 stmtCacheSize = 0, which disable statement caching
1.3.2 works well when statement cache enabled (stmtCacheSize > 0)
1.4 Testing commit() & rollback() functions
1.4.1 commit() function works well
1.4.2 rollback() function works well
1.5 Close method
1.5.1 close can be used as an alternative to release
1.6 connectionString alias
1.6.1 allows connectionString to be used as an alias for connectString
1.7 privileged connections
1.7.1 Negative value - null
1.7.2 Negative - invalid type, a String
1.7.3 Negative value - random constants
1.7.4 Negative value - NaN
1.7.5 Negative - throws error, when invalid privilege is provided for creating a Pool
1.7.6 negative test case SYSPRELIM & SYSASM
1.8 Ping method
1.8.1 ping() checks the connection is usable
1.8.2 closed connection
1.9 connectString & connectionString specified
1.9.1 both connectString & ConnectionString specified
1.10 user & username specified
1.10.1 both user & username specified
1.10.2 allows username to be used as an alias for user
1.10.3 uses username alias to login with SYSDBA privilege
2. pool.js
2.1 default setting
2.1.1 testing default values of pool properties
2.2 poolMin
2.2.1 poolMin cannot be a negative number
2.2.2 poolMin must be a Number
2.2.3 poolMin cannot greater than poolMax
2.2.4 (poolMin + poolIncrement) can equal to poolMax
2.3 poolMax
2.3.1 poolMax cannot be a negative value
2.3.2 poolMax cannot be 0
2.3.3 poolMax must be a number
2.3.4 poolMax limits the pool capacity
2.3.4 poolMax and poolMin actually limit the pool size
2.4 poolIncrement
2.4.1 poolIncrement cannot be a negative value
2.4.2 poolIncrement must be a Number
2.4.3 the amount of open connections equals to poolMax when (connectionsOpen + poolIncrement) > poolMax
2.5 poolTimeout
2.5.1 poolTimeout cannot be a negative number
2.5.2 poolTimeout can be 0, which disables timeout feature
2.5.3 poolTimeout must be a number
2.6 stmtCacheSize
2.6.1 stmtCacheSize cannot be a negative value
2.6.2 stmtCacheSize can be 0
2.6.3 stmtCacheSize must be a Number
2.7 getConnection
2.7.1 passes error in callback if called after pool is terminated and a callback is provided
2.8 connection queueing
2.8.1 basic case
2.8.2 generates NJS-040 if request is queued and queueTimeout expires
2.8.3 generates NJS-076 if request exceeds queueMax
2.8.4 generates NJS-076 if request exceeds queueMax 0
2.8.5 request queue never terminate for queueTimeout set to 0
2.8.6 queueMax range check, queueMax -1
2.8.7 queueMax range check, queueMax -0.5 not an integer
2.9 _enableStats & _logStats functionality
2.9.1 does not work after the pool has been terminated
2.10 Close method
2.10.1 close can be used as an alternative to release
2.11 Invalid Credential
2.11.1 error occurs at creating pool when poolMin >= 1
2.11.2 error occurs at getConnection() when poolMin is the default value 0
2.12 connectionString alias
2.12.1 allows connectionString to be used as an alias for connectString
2.13 connectString & connectionString provided
2.13.1 both connectString & connectionString provided
2.14 username alias
2.14.1 allows username to be used as an alias for user
2.14.2 both user and username specified
2.14.3 uses username alias to login with SYSDBA privilege
2.15 creation time non editable properties
2.15.1 default edition value
2.15.2 ORA$BASE edition value
2.15.3 default value for events - undefined
2.15.4 events - false
2.15.5 events - true
2.15.6 externalAuth - default undefined
2.15.7 externalAuth - true
2.15.8 externalAuth - false
2.15.9 homogeneous - default true
2.15.10 homogeneous - true
2.15.11 homogeneous - false
2.15.12 user name
2.15.13 user name - undefined
2.15.14 connectString
2.16 Pool non-configurable properties global/local override
2.16.1 edition only globally set
2.16.2 edition override
2.16.3 edition override to empty string
2.16.4 events override to true
2.16.5 events override to false
2.16.6 externalAuth override to false
2.16.7 externalAuth override to true
2.17 Check execute same/different query with new/released session from pool
2.17.1 same query execution from new and released session
2.17.2 different query execution from new and released session
2.18 pool stats
2.18.1 driver mode in pool stats
2.19 DBA and Non-DBA user login with SYSDBA privilege
2.19.1 DBA user with SYSDBA privilege
3. examples.js
3.1 connect.js
3.1.1 tests a basic connection to the database
3.2 version.js
3.2.1 shows the node-oracledb version attributes
3.3 select1.js & select2.js
3.3.1. execute a basic query
3.3.2. execute queries to show array and object formats
3.4 selectjson.js - 12.1.0.2 feature
3.4.1 Selecting JSON stored in a VARCHAR2 column
3.4.2 Using JSON_VALUE to extract a value from a JSON column
3.4.3 Using JSON_OBJECT to extract relational data as JSON
3.5 date.js
3.5.1 inserts and query DATE and TIMESTAMP columns
3.6 rowlimit.js
3.6.1 shows ways to limit the number of records fetched by queries
3.7 plsqlproc.js and plsqlfun.js
3.7.1 calling PL/SQL procedure and binding parameters in various ways
3.7.2 calling PL/SQL function
3.8 insert1.js
3.8.1 creates a table and inserts data
3.9 insert2.js
3.9.1 tests the auto commit behavior
3.10 resultset.js
3.10.1 resultset1.js - getRow() function
3.10.2 resultset2.js - getRows() function
3.11 refcursor.js
3.11.1 REF CURSOR
4. binding.js
4.1 test STRING, NUMBER, ARRAY & JSON format
4.1.1 VARCHAR2 binding, Object & Array formats
4.1.2 NUMBER binding, Object & Array formats
4.1.3 Multiple binding values, Object & Array formats
4.1.4 Multiple binding values, Change binding order
4.1.5 default bind type - STRING
4.2 mixing named with positional binding
4.2.1 array binding is ok
4.2.2 array binding with mixing JSON should throw an error
4.3 insert with DATE column and DML returning
4.3.1 passes in object syntax without returning into
4.3.2 passes in object syntax with returning into
4.3.3 passes in array syntax without returning into
4.3.4 should pass but fail in array syntax with returning into
4.4 test maxSize option
4.4.1 outBind & maxSize restriction
4.4.2 default value is 200
4.4.3 Negative - bind out data exceeds default length
4.4.4 maximum value is 32767
4.5 The default direction for binding is BIND_IN
4.5.1 DML default bind
4.5.2 negative DML invalid bind direction
4.6 PL/SQL block with empty outBinds
4.6.1
4.7 Value as JSON named/unamed test cases
4.7.1 valid case when numeric values are passed as it is
4.7.2 Valid values when one of the value is passed as JSON
4.7.3 Valid test case when one of the value is passed as JSON
4.7.4 Valid Test case when both values are passed as JSON
4.7.5 Invalid Test case when value is passed as named JSON
4.7.6 Invalid Test case when other-value is passed as named JSON
4.7.7 Invalid Test case when all values is passed as named JSON
4.8 bind DATE
4.8.1 binding out in Object & Array formats
4.8.2 BIND_IN
4.8.3 BIND_INOUT
5. externalAuth.js
5.1 tests that work both when DB has configured externalAuth and not configured
5.1.1 can get connection from oracledb with correct user/password when externalAuth is disabled
5.1.2 throws error when getting connection from oracledb with correct user/password when externalAuth is enabled
5.1.3 throws error when getting connection from oracledb given only invalid 'user' when externalAuth is enabled
5.1.4 throws error when getting connection from oracledb given only 'password' when externalAuth is enabled
5.1.5 can get pool from oracledb with user/password when externalAuth is disabled
5.1.6 throws error when getting pool from oracledb given user/password when externalAuth is enabled
5.1.7 throws error when getting pool from oracledb only given username when externalAuth is enabled
5.1.8 throws error when getting pool from oracledb only given password when externalAuth is enabled
5.2 tests only work when externalAuth is configured on DB
5.2.1 can get connection from oracledb with external authentication
5.2.2 can get pool from oracledb with external authentication
5.2.3 gets multiple connections from oracledb
5.2.4 gets multiple pools from oracledb
6. dmlReturning.js
6.1 NUMBER & STRING driver data type
6.1.1 INSERT statement with Object binding
6.1.2 INSERT statement with Array binding
6.1.3 INSERT statement with small maxSize restriction
6.1.4 UPDATE statement with single row matched
6.1.5 UPDATE statement with single row matched & Array binding
6.1.6 UPDATE statements with multiple rows matched
6.1.7 UPDATE statements with multiple rows matched & Array binding
6.1.8 DELETE statement with Object binding
6.1.9 DELETE statement with Array binding
6.1.10 Stress test - support 4k varchars
6.1.11 Negative test - throws correct error message
6.1.12 INSERT DML returning into too small a variable
6.1.13 INSERT statement with NaN
6.1.14 INSERT statement with an invalid bind name (reserved namespace keyword)
6.1.15 INSERT statement parse non ascii returning bind
6.1.16 Execute DML with Duplicated bind names for input and returning into clause
6.2 DATE and TIMESTAMP data
6.2.1 INSERT statement, single row matched, Object binding, no bind in data
6.2.2 INSERT statement with JavaScript date bind in
6.2.3 INSERT statement with Array binding
6.2.4 UPDATE statement with single row matched
6.2.5 UPDATE statements with multiple rows matched, ARRAY binding format
6.2.6 UPDATE statements, multiple rows, TIMESTAMP data
6.2.7 DELETE statement, single row matched, Object binding format
6.2.8 DELETE statement, multiple rows matched, Array binding format
6.2.9 Negative test - bind value and type mismatch
6.2.10 INSERT statement, check re-execute by changing the out bindtype
7. autoCommit.js
7.1 autoCommit takes effect when setting oracledb.autoCommit before connecting
7.2 autoCommit takes effect when setting oracledb.autoCommit after connecting
7.3 autoCommit setting does not affect previous SQL result
7.4 global option - oracledb.autoCommit
7.4.1 Negative - 0
7.4.2 Negative - negative number
7.4.3 Negative - positive number
7.4.4 Negative - NaN
7.4.5 Negative - undefined
7.5 set autoCommit as an execute() option
7.5.1 Negative - 0
7.5.2 Negative - negative number
7.5.3 Negative - positive number
7.5.4 Negative - NaN
7.5.5 works as 'false' when setting to 'undefined'
8. autoCommitForSelect.js
8.1 should return previous value when autoCommit is false
8.2 can use explicit commit() to keep data consistent
8.3 can also use the autoCommit for SELECTs feature
9. columnMetadata.js
9.1 tests with the same table
9.1.1 shows metaData correctly when retrieving 1 column from a 4-column table
9.1.2 shows metaData when retrieving 2 columns. MetaData is correct in content and sequence
9.1.3 shows metaData correctly when retrieve 3 columns
9.1.4 shows metaData correctly when retrieving all columns with [SELECT * FROM table] statement
9.1.5 works for SELECT count(*)
9.1.6 works when a query returns no rows
9.1.7 only works for SELECT statement, does not work for INSERT
9.1.8 only works for SELECT statement, does not work for UPDATE
9.1.9 works with a SQL WITH statement
9.1.10 displays metaData correctly with result set
9.2 case sensitive
9.2.1 works for tables whose column names were created case sensitively
9.3 Large number of columns
9.10 works with a large number of columns
9.4 single character column
9.4.1 works with column names consisting of single characters
9.5 duplicate column alias
9.5.1 works when using duplicate column alias
10. nullColumnValues.js
10.1 a simple query for null value
10.2 in-bind for null column value
10.3 out-bind for null column value
10.4 DML Returning for null column value
10.5 resultSet for null value
12. resultSet1.js
12.1 Testing resultSet option
12.1.1 when resultSet option = false, content of result is correct
12.1.2 when resultSet option = true, content of result is correct
12.1.3 negative - 0
12.1.4 negative - null
12.1.5 when resultSet option = undefined, it behaves like false
12.1.6 negative - NaN
12.1.7 negative - 1
12.1.8 negative - (-1)
12.1.9 negative - random string
12.2 Testing fetchArraySize option
12.2.1 negative - negative value
12.2.2 negative - random string
12.2.3 negative - NaN
12.2.4 negative - null
12.2.5 negative - zero value
12.3 Testing function getRows()
12.3.1 retrieved set is exactly the size of result
12.3.2 retrieved set is greater than the size of result
12.3.3 retrieved set is half of the size of result
12.3.4 retrieved set is one tenth of the size of the result
12.3.5 data in resultSet is array when setting outFormat ARRAY
12.3.6 data in resultSet is object when setting outFormat OBJECT
12.3.7 the size of retrieved set can be set to 1
12.3.8 query 0 row
12.3.9 getRows() without argument returns remaining all rows
12.3.10 getRows(0) returns remaining all rows
12.3.11 Negative - set the 1st parameter of getRows() to be -5
12.3.12 Negative - set the 1st parameter of getRows() to be null
12.4 Testing function getRow()
12.4.1 works well with all correct setting
12.4.2 data in resultSet is array when setting outFormat ARRAY
12.4.3 data in resultSet is object when setting outFormat OBJECT
12.4.4 query 0 row
12.4.5 Negative - set the first parameter like getRows()
12.5 Testing function close()
12.5.1 does not call close()
12.5.2 invokes close() twice
12.5.3 uses getRows after calling close()
12.5.4 closes one resultSet and then open another resultSet
12.6 Testing metaData
12.6.1 the amount and value of metaData should be correct
12.6.2 can distinguish lower case and upper case
12.6.3 can contain quotes
12.6.4 can contain underscore
12.7 Testing maxRows
12.7.1 maxRows option is ignored when resultSet option is true
12.7.2 maxRows option is ignored with REF Cursor
13. stream1.js
13.1 Testing QueryStream
13.1.1 stream results for oracle connection
13.1.2 stream results for oracle connection (outFormat: oracledb.OUT_FORMAT_OBJECT)
13.1.3 errors in query
13.1.4 no result
13.1.5 single row
13.1.6 multiple row
13.1.7 invalid SQL
13.1.8 Read CLOBs
13.1.9 Read CLOBs after stream close
13.1.10 meta data
13.1.11 should emit events in the correct order
13.1.12 query with logical error should throw error
13.2 Testing QueryStream.destroy
13.2.1 should be able to stop the stream early with destroy
13.2.2 should be able to stop the stream before any data
13.2.3 should invoke an optional callback passed to destroy
13.2.4 should work if querystream is destroyed before resultset is opened
13.2.5 should work if querystream is destroyed after end event
13.2.6 should emit the error passed in
13.3 Testing QueryStream's fetchArraySize option
13.3.1 should use oracledb.fetchArraySize for fetching
13.3.2 should use execute option fetchArraySize for fetching
13.4 Testing QueryStream other race conditions
13.4.1 queryStream from toQueryStream should get open event
13.4.2 queryStream from toQueryStream should get metadata event
14. stream2.js
14.1 Bind by position and return an array
14.2 Bind by name and return an array
14.3 Bind by position and return an object
14.4 Bind by name and return an object
14.5 explicitly setting resultSet option to be false takes no effect
14.6 maxRows option is ignored as expect
14.7 Negative - queryStream() has no parameters
14.10 metadata event - single column
14.11 metadata event - multiple columns
14.12 metadata event - all column names occurring
14.13 metadata event - no return rows
14.15 metadata event - case sensitive columns
14.16 metadata event - large number of columns
14.17 metadata event - single character column
14.18 metadata event - duplicate column alias
15. resultsetToStream.js
15.1 Testing ResultSet.toQueryStream
15.1.1 should allow resultsets to be converted to streams
15.2 Testing ResultSet/QueryStream conversion errors
15.2.1 should prevent conversion to stream after getRow is invoked
15.2.2 should prevent conversion to stream after getRows is invoked
15.2.3 should prevent conversion to stream after close is invoked
15.2.4 should prevent invoking getRow after conversion to stream
15.2.5 should prevent invoking getRows after conversion to stream
15.2.6 should prevent invoking close after conversion to stream
15.2.7 should prevent calling toQueryStream more than once
18. constants.js
18.1 Query outFormat Constants
18.2 Node-oracledb Type Constants
18.3 Oracle Database Type Constants
18.4 Execute Bind Direction Constants
18.5 Privileged Connection Constants
18.6 SQL Statement Type Constants
18.7 Subscription Constants
18.8 Advanced Queuing Constants
18.9 Continuous Query Notification Constants
18.10 Pool Status Constants
18.11 Simple Oracle Document Access (SODA) Constants
19. fetchTimestampAsString.js
19.1 TIMESTAMP
19.1.1 fetchInfo option
19.1.2 fetchInfo option, outFormat is OBJECT
19.1.3 fetchInfo option, enables resultSet
19.1.4 fetchInfo option, resultSet and OBJECT outFormat
19.1.5 fetchAsString property
19.1.6 fetchAsString property and OBJECT outFormat
19.1.7 fetchAsString property, resultSet
19.1.8 fetchAsString property, resultSet and OBJECT outFormat
19.2 TIMESTAMP WITH TIME ZONE
19.2.1 fetchInfo option
19.2.2 fetchInfo option, outFormat is OBJECT
19.2.3 fetchInfo option, enables resultSet
19.2.4 fetchInfo option, resultSet and OBJECT outFormat
19.2.5 fetchAsString property
19.2.6 fetchAsString property and OBJECT outFormat
19.2.7 fetchAsString property, resultSet
19.2.8 fetchAsString property, resultSet and OBJECT outFormat
19.3 testing maxRows settings and queryStream() to fetch as string
19.3.1 works well when setting oracledb.maxRows > actual number of rows
19.3.2 maxRows = actual num of rows
19.3.3 works when oracledb.maxRows < actual number of rows
19.3.4 uses queryStream() and maxRows > actual number of rows
19.3.5 uses queryStream() and maxRows = actual number of rows
19.3.6 maxRows < actual rows. maxRows does not restrict queryStream()
21. dataTypeAssist.js
22. dataTypeChar.js
22.1 testing CHAR data in various lengths
22.1.1 works well with SELECT query
22.1.2 works well with result set
22.1.3 works well with REF Cursor
22.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
22.2 stores null value correctly
22.2.1 testing Null, Empty string and Undefined
22.3 PL/SQL binding scalar
22.3.1 PL/SQL binding scalar values IN
22.3.2 bind scalar values INOUT
22.3.3 bind scalar values OUT
22.4 PL/SQL binding indexed tables
22.4.1 bind indexed table IN
23. dataTypeNchar.js
23.1 testing NCHAR data in various lengths
23.1.1 SELECT query
23.1.2 resultSet stores NCHAR data correctly
23.1.3 works well with REF Cursor
23.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
23.2 stores null value correctly
23.2.1 testing Null, Empty string and Undefined
24. dataTypeVarchar2.js
24.1 testing VARCHAR2 data in various lengths
24.1.1 SELECT query
24.1.2 resultSet stores VARCHAR2 data correctly
24.1.3 works well with REF Cursor
24.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
24.2 stores null value correctly
24.2.1 testing Null, Empty string and Undefined
25. dataTypeNvarchar2.js
25.1 testing NVARCHAR2 data in various lengths
25.1.1 SELECT query
25.1.2 resultSet stores NVARCHAR2 data correctly
25.1.3 works well with REF Cursor
25.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
25.2 stores null value correctly
25.2.1 testing Null, Empty string and Undefined
26. dataTypeNumber.js
26.1 testing NUMBER data
26.1.1 SELECT query
26.1.2 resultSet stores NUMBER data correctly
26.1.3 works well with REF Cursor
26.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
26.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
26.2 stores null value correctly
26.2.1 testing Null, Empty string and Undefined
26.3 large integers that cannot fit inside a 32-bit integer
26.3.1 original case
26.4 Large number, edge cases
26.4.1 maximum safe integer, (2^53 - 1)
26.4.2 Negative - maximum safe integer + 1
26.4.3 minimum safe integer
26.4.4 Negative - minimum safe integer - 1
26.4.5 fetch as string number that cannot be represented as JS Number
27. dataTypeNumber2.js
27.1 testing NUMBER(p, s) data
27.1.1 SELECT query
27.1.2 resultSet stores NUMBER(p, s) data correctly
27.2 stores null value correctly
27.2.1 testing Null, Empty string and Undefined
28. dataTypeFloat.js
28.1 testing FLOAT data type
28.1.1 works well with SELECT query
28.1.2 works well with result set
28.1.3 works well with REF Cursor
28.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
28.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
28.2 stores null value correctly
28.2.1 testing Null, Empty string and Undefined
29. dataTypeFloat2.js
29.1 testing FLOAT(p) data type
29.1.1 works well with SELECT query
29.1.2 works well with result set
29.1.3 works well with REF Cursor
29.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
29.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
29.2 stores null value correctly
29.2.1 testing Null, Empty string and Undefined
30. dataTypeBinaryFloat.js
30.1 testing BINARY_FLOAT data
30.1.1 works well with SELECT query
30.1.2 works well with result set
30.1.3 works well with REF Cursor
30.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
30.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
30.2 stores null value correctly
30.2.1 testing Null, Empty string and Undefined
30.3 testing floating-point numbers which cannot be precisely represent
30.3.1 rounding numbers
31. dataTypeBinaryDouble.js
31.1 testing BINARY_DOUBLE data
31.1.1 works well with SELECT query
31.1.2 works well with result set
31.1.3 works well with REF Cursor
31.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
31.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
31.2 stores null value correctly
31.2.1 testing Null, Empty string and Undefined
31.3 testing floating-point numbers which can be precisely represent
31.3.1 testing floating-point numbers
32. dataTypeDate.js
32.1 Testing JavaScript Date data
32.1.1 works well with SELECT query
32.1.2 works well with result set
32.1.3 works well with REF Cursor
32.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
32.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
32.1.6 works well with SELECT query after session TimeZone change
32.2 stores null value correctly
32.2.1 testing Null, Empty string and Undefined
32.3 insert SQL Date data
32.3.1 SELECT query - original data
32.3.2 SELECT query - formatted data for comparison
32.4 Select invalid dates
32.4.1 Negative - Invalid Year 0
32.4.2 No ORA-01841 error in Oracle 12.1 server
32.4.3 Negative - Invalid Year -4713
32.4.4 Negative - Invalid Year 10000
33. dataTypeTimestamp1.js
33.1 Testing JavaScript Date with database TIMESTAMP
33.1.1 works well with SELECT query
33.1.2 works well with result set
33.1.3 works well with REF Cursor
33.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
33.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
33.2 stores null value correctly
33.2.1 testing Null, Empty string and Undefined
33.3 testing TIMESTAMP without TIME ZONE
32.3.1 SELECT query - original data
33.3.2 SELECT query - formatted data for comparison
33.3.3 returns scalar types from PL/SQL block
33.4 timestamp with time zone
33.4.1 test with different session time zone
34. dataTypeTimestamp2.js
34.1 Testing JavaScript Date with database TIMESTAMP(p)
34.1.1 works well with SELECT query
34.1.2 works well with result set
34.1.3 works well with REF Cursor
34.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
34.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
34.2 stores null value correctly
34.2.1 testing Null, Empty string and Undefined
34.3 testing database TIMESTAMP(p)
34.3.1 SELECT query - original data
34.3.2 SELECT query - formatted data for comparison
35. dataTypeTimestamp3.js
35.1 Testing JavaScript Date with database TIMESTAMP WITH TIME ZONE
35.1.1 works well with SELECT query
35.1.2 works well with result set
35.1.3 works well with REF Cursor
35.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
35.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
35.2 stores null value correctly
35.2.1 testing Null, Empty string and Undefined
35.3 testing TIMESTAMP WITH TIME ZONE
32.3.1 SELECT query - original data
35.3.2 SELECT query - formatted data for comparison
35.3.3 returns scalar types from PL/SQL block
36. dataTypeTimestamp4.js
36.1 Testing JavaScript Date with database TIMESTAMP (4) WITH TIME ZONE
36.1.1 works well with SELECT query
36.1.2 works well with result set
36.1.3 works well with REF Cursor
36.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
36.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
36.2 stores null value correctly
36.2.1 testing Null, Empty string and Undefined
36.3 testing TIMESTAMP (4) WITH TIME ZONE
32.3.1 SELECT query - original data
36.3.2 SELECT query - formatted data for comparison
36.3.3 returns scalar types from PL/SQL block
37. dataTypeTimestamp5.js
37.1 Testing JavaScript Date with database TIMESTAMP WITH LOCAL TIME ZONE
37.1.1 works well with SELECT query
37.1.2 works well with result set
37.1.3 works well with REF Cursor
37.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
37.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
37.2 stores null value correctly
37.2.1 testing Null, Empty string and Undefined
37.3 testing TIMESTAMP WITH LOCAL TIME ZONE
37.3.1 SELECT query - original data
37.3.2 SELECT query - formatted data for comparison
38. dataTypeTimestamp6.js
38.1 Testing JavaScript Date with database TIMESTAMP(9) WITH LOCAL TIME ZON
38.1.1 works well with SELECT query
38.1.2 works well with result set
38.1.3 works well with REF Cursor
38.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
38.1.5 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
38.2 stores null value correctly
38.2.1 testing Null, Empty string and Undefined
38.3 testing TIMESTAMP WITH LOCAL TIME ZONE
38.3.1 SELECT query - original data
38.3.2 SELECT query - formatted data for comparison
39. dataTypeRowid.js
39.1 testing ROWID data type
39.1.1 query rowid
39.1.2 works well with result set
39.1.3 ROWID couldn't update
39.1.4 can get data object number correctly
39.1.5 can get datafile number correctly
39.1.6 can get data block number correctly
39.1.7 can get row number correctly
39.1.8 works well with REF Cursor
39.1.9 columns fetched from REF CURSORS can be mapped by fetchInfo settings
39.2 stores null value correctly
39.2.1 testing Null, Empty string and Undefined
40. dataTypeClob.js
40.1 testing CLOB data type
40.1.1 stores CLOB value correctly
40.1.2 CLOB getData()
40.1.3 CLOB getData(offset, len)
40.2 stores null value correctly
40.2.1 testing Null, Empty string and Undefined
41. dataTypeBlob.js
41.1 testing BLOB data type
41.1.1 stores BLOB value correctly
41.1.2 BLOB getData()
41.1.3 BLOB getData(offset, len)
41.2 stores null value correctly
41.2.1 testing Null, Empty string and Undefined
41.3 OSON column metadata
41.3.1 Verify isOson flag in column metadata
41.3.2 Verify Basic encode/decode OSON on OSON format column
42. dataTypeRaw.js
42.1 testing RAW data in various lengths
42.1.1 SELECT query
42.1.2 resultSet stores RAW data correctly
42.1.3 works well with REF Cursor
42.1.4 result set getRow() function works well with RAW
42.1.5 a negative case which hits NJS-011 error
42.2 stores null value correctly
42.2.1 testing Null, Empty string and Undefined
42.3 DML Returning - Currently not support RAW
42.3.1 INSERT statement with Object binding
42.3.2 INSERT statement with ARRAY binding
42.3.3 INSERT statement with exact maxSize restriction
42.3.4 UPDATE statement
42.3.5 DELETE statement with single row matching
42.3.6 DELETE statement with multiple rows matching
42.4 in PL/SQL, the maximum size is 32767
42.4.1 works well when the length of data is less than maxSize
42.4.2 works well when the length of data is exactly 32767
42.4.3 throws error when the length of data is greater than maxSize
42.4.4 throws error when both data and maxSize are greater than 32767
42.5 INSERT and SELECT
42.5.1 works with data size 100
42.5.2 works with data size 2000
42.5.3 works with default type/dir
42.6 UPDATE
42.6.1 works with data size 100
42.6.2 works with data size 2000
42.6.3 works with default type/dir
42.7 DB_TYPE_RAW in Advanced Queue (AQ)
42.7.1 enqOne/deqOne with DB_TYPE_RAW specified.
42.7.2 enqMany/deqMany with DB_TYPE_RAW specified.
43. plsqlBindIndexedTable1.js
43.1 binding PL/SQL indexed table
43.1.1 binding PL/SQL indexed table IN by name
43.1.2 binding PL/SQL indexed table IN by position
43.1.3 binding PL/SQL indexed table IN OUT
43.1.4 binding PL/SQL indexed table OUT
43.2 test exceptions when using PL/SQL indexed table bindings
43.2.1 maxArraySize is ignored when specifying BIND_IN
43.2.2 maxArraySize is mandatory for BIND_INOUT
43.2.3 maxArraySize cannot smaller than the number of array elements
43.2.5 negative case: incorrect type of array element - bind by name 1
43.2.6 negative case: incorrect type of array element - bind by name 2
43.2.7 negative case: incorrect type of array element - bind by name 3
43.2.8 negative case: incorrect type of array element - bind by name 4
43.2.9 supports binding by position
43.2.10 negative case: incorrect type of array elements - bind by pos 1
43.2.11 negative case: incorrect type of array elements - bind by pos 2
43.2.12 negative case: incorrect type of array elements - bind by pos 3
43.2.13 negative case: incorrect type of array elements - bind by pos 4
43.3 binding PL/SQL scalar
43.3.1 binding PL/SQL scalar IN
43.3.2 binding PL/SQL scalar IN/OUT
43.3.3 binding PL/SQL scalar OUT by name
43.3.4 binding PL/SQL scalar OUT by position
43.4 test attribute - maxArraySize
43.4.1 maxArraySize property is ignored for BIND_IN
43.4.2 maxArraySize is mandatory for BIND_INOUT
43.4.3 maxArraySize cannot smaller than the number of array elements
43.4.4 maxArraySize can be equal to the number of array elements
43.4.5 negative case: large value
43.4.6 negative case: < 0
43.4.7 negative case: = 0
43.4.8 negative case: assign a string to it
43.4.9 negative case: NaN
44. plsqlBindIndexedTable2.js.js
44.1 example case
44.2 example case binding by position
44.3 default binding type and direction with binding by name
44.4 default binding type and direction with binding by position
44.5 null elements in String and Number arrays
44.6 empty array for BIND_IN and BIND_INOUT
44.7 empty array for BIND_OUT
44.8 maxSize option applies to each elements of an array
45. instanceof1.js
45.1 instanceof works for pool instances
45.2 instanceof works for connection instances
45.3 instanceof works for resultset instances
45.4 instanceof works for lob instances
51. poolClose.js
51.1 can not get connections from the terminated pool
51.2 can not terminate the same pool multiple times
51.3 can not close the same pool multiple times
51.4 pool is still available after the failing close
51.5 can not close the same connection multiple times
51.6 can not get connection in promise version from the terminated pool
51.7 can not set the attributes after pool created
51.8 can access the attributes of closed pool without error
52. connClose.js
52.1 can not set property, stmtCacheSize, after connection closes
52.2 can not set property, clientId, after connection closes
52.3 can not set property, module
52.4 can not set property, action
52.5 can not call method, execute()
52.6 can not call method, break()
52.7 can not call method, commit()
52.8 can not call method, createLob()
52.9 can not call method, queryStream()
52.10 can not call release() multiple times
52.11 can not call method, rollback
52.12 can access properties of closed connection without error
53. resultSetClose.js
53.1 can not get metaData property
53.2 can not call close() again
53.3 can not call getRow()
53.4 can not call getRows()
53.5 can not call toQueryStream()
53.6 can call getRow() again in the callback of getRow()
54. lobClose.js
54.1 can access properties of closed LOB without error
54.2 can not call close() multiple times
54.3 verify closed LOB
54.4 automatically close result sets and LOBs when the connection is closed
55. resultSet2.js
55.1 query a RDBMS function
55.1.1 LPAD function
55.2 binding variables
55.2.1 query with one binding variable
55.3 alternating getRow() & getRows() function
55.3.1 result set
55.3.2 REF Cursor
55.4 automatically close resultSets and LOBs when the connection is closed
55.4.1 resultSet gets closed automatically
55.4.2 REF Cursor gets closed automatically
55.5 the content of resultSet should be consistent
55.5.1 (1) get RS (2) modify data in that table and commit (3) check RS
55.6 access resultSet simultaneously
55.6.1 concurrent operations on resultSet are not allowed (using getRows())
55.6.2 concurrent operation on REF Cursor are not allowed
55.6.3 concurrent operations on resultSet are not allowed (using getRow())
55.6.4 concurrently closing resultSet not allowed
55.7 getting multiple resultSets
55.7.1 can access multiple resultSet on one connection
55.7.2 can access multiple REF Cursor
55.8 test querying a PL/SQL function
55.8.1
55.9 calls getRows() once and then close RS before getting more rows
55.9.1
55.10 use Resultset asyncIterator
55.10.1
55.11 NEgative - resultSet with unsupported data types
55.11.1 INTERVAL YEAR TO MONTH data type
55.12 bind a cursor BIND_INOUT
55.12.1 has not supported binding a cursor with BIND_INOUT
55.13 Negative - Invalid Ref Cursor
55.13.1
56. fetchAs.js
56.1 property value check
56.2 Fetch DATE column values as STRING - by-Column name
56.3 Fetch DATE, NUMBER column values STRING - by Column-name
56.4 Fetch DATE, NUMBER as STRING by-time configuration and by-name
56.5 Fetch DATE, NUMBER column as STRING by-type and override at execute time
56.6 Fetch ROWID column values STRING - non-ResultSet
56.7 Fetch ROWID column values STRING - ResultSet
56.8 large numbers with fetchInfo
56.9 large numbers with setting fetchAsString property
56.10 invalid syntax for type should result in error
56.11 assigns an empty array to fetchAsString
56.12 Negative - empty string
56.13 Negative - null
56.14 Negative - undefined
56.15 Negative - NaN
56.16 Negative - invalid type of value, number
56.17 Negative - invalid type of value, string
56.18 Negative - passing oracledb.DATE type to fetchInfo
56.19 Negative - passing empty JSON to fetchInfo
56.20 Negative - passing oracledb.NUMBER type to fetchInfo
56.21 Negative - passing Date for fetchAsString
56.22 Negative - passing Buffer for fetchAsstring
58. properties.js
58.1 Oracledb Class
58.1.1 poolMin
58.1.2 poolMax
58.1.3 poolIncrement
58.1.4 poolTimeout
58.1.5 maxRows
58.1.6 fetchArraySize
58.1.7 autoCommit
58.1.8 version (read-only)
58.1.9 connectionClass
58.1.10 externalAuth
58.1.11 fetchAsString
58.1.12 outFormat
58.1.13 lobPrefetchSize
58.1.14 oracleClientVersion (read-only)
58.1.15 queueTimeout
58.1.16 queueMax
58.1.17 stmtCacheSize
58.1.18 poolPingInterval
58.1.19 fetchAsBuffer
58.1.20 Negative - connectionClass
58.1.21 Negative - autoCommit
58.1.22 Negative - outFormat
58.1.23 Negative - externalAuth
58.1.24 versionString (read-only)
58.1.25 versionSuffix (read-only)
58.1.26 oracleClientVersionString (read-only)
58.1.27 edition
58.1.28 Negative - edition
58.1.29 events
58.1.30 Negative - events
58.1.31 dbObjectAsPojo
58.1.32 Negative - fetchArraySize
58.1.33 Negative - dbObjectAsPojo
58.1.34 Negative - fetchAsString
58.1.35 Negative - lobPrefetchSize
58.1.36 Negative - maxRows
58.1.37 Negative - poolIncrement
58.1.38 Negative - poolMin
58.1.39 Negative - poolMax
58.1.40 Negative - poolTimeout
58.1.41 Negative - stmtCacheSize
58.1.42 poolPingTimeout
58.1.43 Negative - poolPingTimeout
58.2 Pool Class
58.2.1 poolMin
58.2.2 poolMax
58.2.3 poolIncrement
58.2.4 poolTimeout
58.2.5 stmtCacheSize
58.2.6 connectionsInUse
58.2.7 connectionsOpen
58.2.8 queueTimeout
58.2.9 poolPingInterval
58.2.10 poolMax
58.2.11 poolPingTimeout
58.3 Connection Class
58.3.1 Connection object initial toString values
58.3.2 stmtCacheSize (read-only)
58.3.3 clientId (write-only)
58.3.4 action (write-only)
58.3.5 module (write-only)
58.3.6 oracleServerVersion (read-only)
58.3.7 oracleServerVersionString (read-only)
58.3.8 currentSchema
58.4 ResultSet Class
58.4.1 metaData (read-only)
59. lobResultSet.js
59.1 CLOB data
59.1.1 reads clob data one by one row from result set
59.1.2 works with oracledb.maxRows > actual number of rows fetched
59.1.3 works with oracledb.maxRows = actual number of rows fetched
59.1.4 works with oracledb.maxRows < actual number of rows fetched
59.2 BLOB data
59.2.1 reads blob data one by one row from result set
59.2.2 works with oracledb.maxRows > actual number of rows fetched
59.2.3 works with oracledb.maxRows = actual number of rows fetched
59.2.4 works with oracledb.maxRows < actual number of rows fetched
60. clobPlsqlString.js
60.1 BIND OUT as STRING
60.1.1 PL/SQL OUT CLOB parameters can also be bound as STRING
60.1.2 The returned length is limited to the maximum size
60.2 BIND OUT as CLOB
60.2.1 maxSize option does not take effect when bind out type is clob
61. checkClassesTypes.js
61.1 Oracledb class
61.2 Connection class
61.3 Lob Class
61.4 Pool Class
61.5 ResultSet Class
62. lobProperties1.js
62.1 chunkSize (read-only)
62.2 length (read-only)
62.3 pieceSize -default value is chunkSize
62.4 pieceSize - can be increased
62.5 pieceSize - can be decreased
62.6 pieceSize - can be zero
62.7 pieceSize - cannot be less than zero
62.8 pieceSize - cannot be null
62.9 pieceSize - must be a number
62.10 type (read-only)
63. autoCommit4nestedExecutes.js
63.1 nested execute() functions
64. sqlWithWarnings.js
64.1 SQL - Success With Info
64.1.1 Executes an aggregate query which causes warnings
64.2 PL/SQL - Success With Info
64.2.1 Execute SQL Statement to create PLSQL procedure with warnings
65. uninitializedLob.js
65.1 an uninitialized Lob is returned from a PL/SQL block
66. writableProperties1.js
66.1 allows overwriting of public methods on pool instances
66.2 allows overwriting of public methods on connection instances
66.3 allows overwriting of public methods on resultset instances
66.4 allows overwriting of public methods on lob instances
66.5 allows overwriting of public methods on oracledb instances
67. poolCache.js
67.1 basic functional tests
67.1.1 caches pool as default if pool is created when cache is empty
67.1.2 removes the pool from the cache on terminate
67.1.3 can cache and retrieve an aliased pool
67.1.4 throws an error if the poolAlias already exists in the cache
67.1.5 does not throw an error if multiple pools are created without an alias
67.1.6 throws an error if poolAttrs.poolAlias is not a string
67.1.7 makes poolAttrs.poolAlias a read-only attribute on the pool named alias
67.1.8 retrieves the default pool, even after an aliased pool is created
67.1.9 retrieves the right pool, even after multiple pools are created
67.1.10 throws an error if the pool specified in getPool doesn't exist
67.1.11 does not throw an error if multiple pools are created without a poolAlias in the same call stack
67.2 oracledb.getConnection functional tests
67.2.1 gets a connection from the default pool
67.2.2 gets a connection from the pool with the specified alias when no alias is specified
67.2.3 throws an error if an attempt is made to use the default pool when it does not exist
67.2.4 throws an error if an attempt is made to use a poolAlias for a pool that is not in the cache
67.2.5 gets a connection from the default pool, even after an aliased pool is created
67.2.6 uses the right pool, even after multiple pools are created
67.2.7 gets a connection from the default pool with callback function(err)
67.3 poolAlias attribute
67.3.1 throws an error if poolAttrs.poolAlias is an object
67.3.2 throws an error if poolAttrs.poolAlias is an array
67.3.3 throws an error if poolAttrs.poolAlias is a number
67.3.4 throws an error if poolAttrs.poolAlias is a boolean
67.3.5 throws an error if poolAttrs.poolAlias is null
67.3.6 throws an error if poolAttrs.poolAlias is an empty string
67.3.7 throws an error if poolAttrs.poolAlias is NaN
67.3.8 works if poolAttrs.poolAlias is undefined
68. multipleLobInsertion.js
68.1 inserts multiple BLOBs
68.2 inserts multiple CLOBs
69. driverName.js
69.1 checks the driver name
70. plsqlBindScalar.js
70.1 PL/SQL bind scalar, dir: BIND_IN and BIND_OUT, type: STRING
70.1.1 basic case: a simple string
70.1.2 negative: bind in value and type mismatch
70.1.3 val: null
70.1.4 val: empty string
70.1.5 val: undefined
70.1.6 tests default dir & type
70.1.7 val: NaN
70.2 dir: BIND_IN and BIND_OUT, type: NUMBER
70.2.1 basic case
70.2.2 auto detect number type
70.2.3 val: null
70.2.4 Negative: bind value and type mismatch - val: empty string
70.2.5 val: 0
70.2.6 val: undefined
70.2.7 val: NaN
70.2.8 val: -1
70.2.9 val: maxval
70.3 dir: BIND_IN and BIND_OUT, type: DATE
70.3.1 basic case
70.3.2 auto detect Date type
70.3.3 val: null
70.3.4 val: empty string, negative - bind value and type mismatch
70.3.5 val: undefined
70.3.6 val: NaN
70.3.7 val: invalid Date Value: Feb 30, 2016
70.3.8 val: 1969-12-31
70.3.9 val: epoc date 1970-1-1
70.3.10 val: create Date value using numeric value: new Date(number)
70.3.11 val: create Date value using numeric value: new Date(7 number)
70.3.12 val: create Date value using numeric value: 0
70.4 dir: BIND_IN and BIND_OUT, type: BUFFER
70.4.1 basic case
70.4.2 auto detect Buffer type
70.4.3 val: null
70.4.4 val: empty string
70.4.5 val: undefined
70.4.6 val: NaN
70.5 dir: BIND_INOUT, type: STRING
70.5.1 basic case: a simple string
70.5.2 tests default type
70.5.3 negative: bind value and type mismatch
70.5.4 val: null
70.5.5 val: empty string
70.5.6 val: undefined
70.5.7 val: NaN
70.5.8 NULL IN and NON-NULL out
70.5.9 NON-NULL IN and NULL OUT
70.5.10 n Length IN and 2n OUT
70.5.11 2n Length IN and n OUT
70.6 dir: BIND_INOUT, type: NUMBER
70.6.1 basic case
70.6.2 auto detect number type
70.6.3 negative: bind value and type mismatch - val: empty string
70.6.4 val: null
70.6.5 val: undefined
70.6.6 val: NaN
70.6.7 val: 0
70.6.8 val: -1
70.6.9 val: maxval
70.6.10 NULL IN and NON-NULL out
70.6.11 NON-NULL IN and NULL OUT
70.7 dir: BIND_INOUT, type: DATE
70.7.1 basic case
70.7.2 auto detect Date type
70.7.3 val: null
70.7.4 val: empty string, negative - bind value and type mismatch
70.7.5 val: undefined
70.7.6 val: NaN
70.7.7 val: invalid Date Value: Feb 30, 2016
70.7.8 val: 1969-12-31
70.7.9 val: epoc date 1970-1-1
70.7.10 NULL IN and NON-NULL out
70.7.11 NON-NULL IN and NULL OUT
70.8 dir: BIND_INOUT, type: BUFFER
70.8.1 basic case
70.8.2 auto detect BUFFER type
70.8.3 val: null
70.8.4 val: empty string
70.8.5 val: undefined
70.8.6 val: NaN
70.9 Query the binded data by SQL
70.9.1 basic case
70.9.2 dir: BIND_INOUT, val: null
70.9.3 dir: BIND_IN, val: null
70.9.4 dir: BIND_INOUT, val: undefined
70.9.5 dir: BIND_IN, val: undefined
70.10 Check the bind-in values in PL/SQL
70.10.1 STRING, basic
70.10.2 STRING, null, empty string, undefined
70.10.3 NUMBER, null values
70.10.4 DATE, null values
70.10.5 BUFFER
70.10.6 TIMESTAMP, null values
70.10.7 TIMESTAMP WITH TIME ZONE, null values
70.10.8 TIMESTAMP WITH LOCAL TIME ZONE, null values
70.11 dir: BIND_IN and BIND_OUT, type: TIMESTAMP(convert STRING to TIMESTAMP)
70.11.1 basic case
70.11.2 val: null
70.11.3 val: empty string
70.11.4 val: undefined
70.11.5 val: NaN
70.11.7 val: invalid Date Value: Feb 30, 2016
70.11.8 val: 1969-12-31
70.11.9 val: epoch date 1970-1-1
70.12 dir: BIND_IN and BIND_OUT, type: TIMESTAMP(WITH VARCHAR2 RETURN)
70.12.1 basic case
70.12.2 val: null
70.12.3 val: empty string
70.12.4 val: undefined
70.12.5 val: NaN
70.12.7 val: invalid Date Value: Feb 30, 2016
70.12.8 val: 1969-12-31
70.12.9 val: epoch date 1970-1-1
70.12.10 val: create Date value using numeric value: new Date(number)
70.12.11 val: create Date value using numeric value: 0
70.13 dir: BIND_IN and BIND_OUT, type: TIMESTAMP
70.13.1 val: empty string
70.13.2 val: undefined
70.13.3 val: NaN
70.14 dir: BIND_INOUT, type:TIMESTAMP
70.14.1 basic case
70.14.2 auto detect data type
70.14.3 val: null
70.14.4 val: empty string
70.14.5 val: undefined
70.14.6 val: NaN
70.14.7 val: invalid Date Value: Feb 30, 2016
70.14.8 val: 1969-12-31
70.14.9 val: epoch date 1970-1-1
70.14.10 NULL IN and NON-NULL out
70.14.11 NON-NULL IN and NULL OUT
70.15 dir: BIND_IN and BIND_OUT, type: TIMESTAMP WITH TIME ZONE(convert STRING to TIMESTAMP)
70.15.1 basic case
70.15.2 val: null
70.15.3 val: empty string
70.15.4 val: undefined
70.15.5 val: NaN
70.15.7 val: invalid Date Value: Feb 30, 2016
70.15.8 val: 1969-12-31
70.15.9 val: epoch date 1970-1-1
70.16 dir: BIND_IN and BIND_OUT, type: TIMESTAMP WITH TIME ZONE(WITH VARCHAR2 RETURN)
70.16.1 basic case
70.16.2 val: null
70.16.3 val: empty string
70.16.4 val: undefined
70.16.5 val: NaN
70.16.7 val: invalid Date Value: Feb 30, 2016
70.16.8 val: 1969-12-31
70.16.9 val: epoch date 1970-1-1
70.16.10 val: create Date value using numeric value: new Date(number)
70.16.11 val: create Date value using numeric value: 0
70.17 dir: BIND_IN and BIND_OUT, type: TIMESTAMP WITH TIME ZONE
70.17.1 val: empty string
70.17.2 val: undefined
70.17.3 val: NaN
70.18 dir: BIND_INOUT, type:TIMESTAMP WITH TIME ZONE
70.18.1 basic case
70.18.2 auto detect data type
70.18.3 val: null
70.18.4 val: empty string
70.18.5 val: undefined
70.18.6 val: NaN
70.18.7 val: invalid Date Value: Feb 30, 2016
70.18.8 val: 1969-12-31
70.18.9 val: epoch date 1970-1-1
70.18.10 NULL IN and NON-NULL out
70.18.11 NON-NULL IN and NULL OUT
70.19 dir: BIND_IN and BIND_OUT, type: TIMESTAMP WITH LOCAL TIME ZONE(convert STRING to TIMESTAMP)
70.19.1 basic case
70.19.2 val: null
70.19.3 val: empty string
70.19.4 val: undefined
70.19.5 val: NaN
70.19.7 val: invalid Date Value: Feb 30, 2016
70.19.8 val: 1969-12-31
70.19.9 val: epoch date 1970-1-1
70.20 dir: BIND_IN and BIND_OUT, type: TIMESTAMP WITH LOCAL TIME ZONE(WITH VARCHAR2 RETURN)
70.20.1 basic case
70.20.2 val: null
70.20.3 val: empty string
70.20.4 val: undefined
70.20.5 val: NaN
70.20.7 val: invalid Date Value: Feb 30, 2016
70.20.8 val: 1969-12-31
70.20.9 val: epoch date 1970-1-1
70.20.10 val: create Date value using numeric value: new Date(number)
70.20.11 val: create Date value using numeric value: 0
70.21 dir: BIND_IN and BIND_OUT, type: TIMESTAMP WITH LOCAL TIME ZONE
70.21.1 val: empty string
70.21.2 val: undefined
70.21.3 val: NaN
70.22 dir: BIND_INOUT, type:TIMESTAMP WITH LOCAL TIME ZONE
70.22.1 basic case
70.22.2 auto detect data type
70.22.3 val: null
70.22.4 val: empty string
70.22.5 val: undefined
70.22.6 val: NaN
70.22.7 val: invalid Date Value: Feb 30, 2016
70.22.8 val: 1969-12-31
70.22.9 val: epoch date 1970-1-1
70.22.10 NULL IN and NON-NULL OUT
70.22.11 NON-NULL IN and NULL OUT
71. lobBind1.js
71.1 persistent CLOB
71.1.1 BIND_IN, DML, a String variable
71.1.2 BIND_IN, DML, null
71.1.3 BIND_IN, DML, a txt file
71.1.4 BIND_IN, PL/SQL, a txt file
71.1.5 BIND_OUT, PL/SQL, a string
71.1.6 BIND_OUT, PL/SQL, a txt file
71.1.7 BIND_INOUT, PL/SQL, A String. IN LOB gets closed automatically.
71.1.8 BIND_INOUT, PL/SQL, a txt file
71.1.9 BIND_INOUT, PL/SQL, a String as the bind IN Value
71.2 persistent BLOB
71.2.1 BIND_IN, DML, a Buffer value
71.2.2 BIND_IN, DML, null
71.2.3 BIND_IN, DML, a jpg file
71.2.4 BIND_IN, PL/SQL, a jpg file
71.2.5 BIND_OUT, PL/SQL, a Buffer value
71.2.6 BIND_OUT, PL/SQL, a jpg file
71.2.7 BIND_INOUT, PL/SQL, a Buffer value
71.2.8 BIND_INOUT, PL/SQL, a jpg file
71.2.9 BIND_INOUT, PL/SQL, a Buffer as the bind IN value
72. lobBind2.js
72.1 CLOB
72.1.1 BIND_IN, DML, a txt file
72.1.2 BIND_IN, PL/SQL, a txt file
72.1.3 Negative - invalid type
72.1.4 Negative - invalid value
72.1.5 DML - UPDATE statement
72.1.6 BIND_INOUT, PL/SQL, IN LOB gets closed automatically
72.2 BLOB
72.2.1 BIND_IN, DML, a jpg file
72.2.2 BIND_IN, PL/SQL, a jpg file
72.2.3 Negative - inconsistent datatypes
72.2.4 Negative - not providing first parameter
72.2.5 call lob.close() multiple times sequentially
72.3 NCLOB
72.3.1 BIND_IN, DML, a txt file
72.3.2 BIND_IN, PL/SQL, a txt file
72.3.3 Negative - invalid type
72.3.4 Negative - invalid value
72.3.5 DML - UPDATE statement
72.3.6 BIND_INOUT, PL/SQL, IN LOB gets closed automatically
73. poolPing.js
73.1 the default value of poolPingInterval is 60
73.2 does not change after the pool has been created
73.3 can not be changed on pool object
73.4 can not be accessed on connection object
73.5 can be set to 0, means always ping
73.6 can be set to negative values, means never ping
73.7 Negative: Number.MAX_SAFE_INTEGER
73.8 cannot surpass the upper limit
73.9 cannot surpass the lower Limit
73.10 Negative: null
73.11 Negative: NaN
73.12 Negative: undefined
73.13 Negative: 'random-string'
73.14 can be set at pool creation, e.g. positive value 1234
73.15 can be set at pool creation, e.g. negative value -4321
73.16 can be set at pool creation, e.g. 0 means always ping
73.17 Negative: null
73.18 Setting to 'undefined' will use current value from oracledb
73.19 can be set at pool creation. Negative: NaN
73.20 can be set at pool creation. Negative: 'random-string'
73.21 cannot surpass the upper limit at pool creation
73.22 cannot surpass the lower limit at pool creation
73_1 poolPingTimeout
73_1.1 larger pingTimeout to simulate healthy conns
74. clobPlsqlBindAsString_bindin.js
74.1 CLOB, PLSQL, BIND_IN
74.1.1 works with EMPTY_CLOB
74.1.2 works with EMPTY_CLOB and bind in maxSize set to 1
74.1.3 works with EMPTY_CLOB and bind in maxSize set to (64K - 1)
74.1.4 works with null
74.1.5 works with null and bind in maxSize set to 1
74.1.6 works with null and bind in maxSize set to (64K - 1)
74.1.7 works with empty string
74.1.8 works with empty string and bind in maxSize set to 1
74.1.9 works with empty string and bind in maxSize set to (64K - 1)
74.1.10 works with undefined
74.1.11 works with undefined and bind in maxSize set to 1
74.1.12 works with undefined and bind in maxSize set to (64K - 1)
74.1.13 works with NaN
74.1.14 works with 0
74.1.15 works with String length 32K
74.1.16 works with String length (64K - 1)
74.1.17 works with String length (64K + 1)
74.1.18 works with String length (1MB + 1)
74.1.19 works with bind value and type mismatch
74.1.20 mixing named with positional binding
74.1.21 works with invalid CLOB
74.1.22 works with bind in maxSize smaller than string length
74.1.23 RETURN with bind type STRING
74.1.24 works with UPDATE
74.1.25 bind error: NJS-037, bind by name 1
74.1.26 bind error: NJS-037, bind by name 2
74.1.27 bind error: NJS-037, bind by name 3
74.1.28 bind error: NJS-037, bind by name 4
74.1.29 bind error: NJS-052, bind by pos 1
74.1.30 bind error: NJS-052, bind by pos 2
74.1.31 bind error: NJS-052, bind by pos 3
74.1.32 bind error: NJS-052, bind by pos 4
74.2 CLOB, PLSQL, BIND_IN to VARCHAR2
74.2.1 works with EMPTY_CLOB
74.2.2 works with EMPTY_CLOB and bind in maxSize set to 1
74.2.3 works with EMPTY_CLOB and bind in maxSize set to (64K - 1)
74.2.4 works with null
74.2.5 works with null and bind in maxSize set to 1
74.2.6 works with null and bind in maxSize set to (64K - 1)
74.2.7 works with empty string
74.2.8 works with empty string and bind in maxSize set to 1
74.2.9 works with empty string and bind in maxSize set to (64K - 1)
74.2.10 works with undefined
74.2.11 works with undefined and bind in maxSize set to 1
74.2.12 works with undefined and bind in maxSize set to (64K - 1)
74.2.13 works with NaN
74.2.14 works with 0
74.2.15 works with String length (32K - 1)
74.2.16 works with String length 32K
74.2.17 works with invalid CLOB
74.2.18 works with bind in maxSize smaller than string length
74.2.19 works with UPDATE
74.3 Multiple CLOBs, BIND_IN
74.3.1 bind two string
74.3.2 bind a txt file and a string
74.3.3 bind two string, one > (64K - 1)
75. clobPlsqlBindAsString_bindout.js
75.1 CLOB, PLSQL, BIND_OUT
75.1.1 works with EMPTY_LOB
75.1.2 works with EMPTY_LOB and bind out maxSize set to 1
75.1.3 works with EMPTY_LOB and bind out maxSize set to (64k - 1)
75.1.4 works with null
75.1.5 works with null and bind out maxSize set to 1
75.1.6 works with null and bind out maxSize set to (64k - 1)
75.1.7 works with empty string
75.1.8 works with empty string and bind out maxSize set to 1
75.1.9 works with empty string and bind out maxSize set to (64K - 1)
75.1.10 works with undefined
75.1.11 works with undefined and bind out maxSize set to 1
75.1.12 works with undefined and bind out maxSize set to (64K - 1)
75.1.13 works with NaN
75.1.14 works with 0
75.1.15 works with String length 32K
75.1.16 works with String length (64K - 1)
75.1.17 works with String length (64K + 1)
75.1.18 works with String length (1MB + 1)
75.1.19 works with bind value and type mismatch
75.1.20 mixing named with positional binding
75.1.21 works with UPDATE
75.1.22 works with substr
75.1.23 named binding, bind out maxSize smaller than string length ( < 32K )
75.1.24 named binding, bind out maxSize smaller than string length ( > 32K )
75.1.25 named binding, bind out maxSize smaller than string length ( > 64K )
75.1.26 positional binding, bind out maxSize smaller than string length ( < 32K )
75.1.27 positional binding, bind out maxSize smaller than string length ( > 32K )
75.1.28 positional binding, bind out maxSize smaller than string length ( > 63K )
75.2 CLOB, PLSQL, BIND_OUT to VARCHAR2
75.2.1 works with EMPTY_LOB
75.2.2 works with EMPTY_LOB and bind out maxSize set to 1
75.2.3 works with EMPTY_LOB and bind out maxSize set to (64k - 1)
75.2.4 works with null
75.2.5 works with null and bind out maxSize set to 1
75.2.6 works with null and bind out maxSize set to (64k - 1)
75.2.7 works with empty string
75.2.8 works with empty string and bind out maxSize set to 1
75.2.9 works with empty string and bind out maxSize set to (64K - 1)
75.2.10 works with undefined
75.2.11 works with undefined and bind out maxSize set to 1
75.2.12 works with undefined and bind out maxSize set to (64K - 1)
75.2.13 works with NaN
75.2.14 works with 0
75.2.15 works with String length (32K - 1)
75.2.16 works with String length 32K
75.2.17 works with bind out maxSize smaller than string length
75.2.18 works with UPDATE
75.2.19 works with substr
75.3 Multiple CLOBs, BIND_OUT
75.3.1 bind two string
75.3.2 bind a txt file and a string
75.3.3 bind two string, one > (64K - 1)
76. clobPlsqlBindAsString_bindinout.js
76.1 CLOB, PLSQL, BIND_INOUT
76.1.1 works with EMPTY_CLOB
76.1.2 works with EMPTY_CLOB and maxSize set to 1
76.1.3 works with EMPTY_CLOB and maxSize set to (64K - 1)
76.1.4 works with null
76.1.5 works with null and maxSize set to 1
76.1.6 works with null and maxSize set to (64K - 1)
76.1.7 works with empty string
76.1.8 works with empty string and maxSize set to 1
76.1.9 works with empty string and maxSize set to (64K - 1)
76.1.10 works with undefined
76.1.11 works with undefined and maxSize set to 1
76.1.12 works with undefined and maxSize set to (64K - 1)
76.1.13 works with NaN
76.1.14 works with 0
76.1.15 works with String length 32K
76.1.16 works with String length (64K - 1)
76.1.17 works with String length (64K + 1)
76.1.18 works with String length (1MB + 1)
76.1.19 works with bind value and type mismatch
76.1.20 mixing named with positional binding
76.1.21 works with UPDATE
76.1.22 works with invalid CLOB
76.1.23 works with substr
76.1.24 named binding: maxSize smaller than string length( < 32K )
76.1.25 named binding: maxSize smaller than string length( > 32K )
76.1.26 named binding: maxSize smaller than string length( > 64K )
76.1.27 positional binding: maxSize smaller than string length( < 32K )
76.1.28 positional binding: maxSize smaller than string length( > 32K )
76.1.29 positional binding: maxSize smaller than string length( > 64K )
76.2 CLOB, PLSQL, BIND_INOUT to VARCHAR2
76.2.1 works with EMPTY_CLOB
76.2.2 works with EMPTY_CLOB and maxSize set to 1
76.2.3 works with EMPTY_CLOB and maxSize set to (64K - 1)
76.2.4 works with null
76.2.5 works with null and maxSize set to 1
76.2.6 works with null and maxSize set to (64K - 1)
76.2.7 works with empty string
76.2.8 works with empty string and maxSize set to 1
76.2.9 works with empty string and maxSize set to (64K - 1)
76.2.10 works with undefined
76.2.11 works with undefined and maxSize set to 1
76.2.12 works with undefined and maxSize set to (64K - 1)
76.2.13 works with NaN
76.2.14 works with 0
76.2.15 works with String length (32K - 1)
76.2.16 works with String length 32K
76.2.17 works with bind out maxSize smaller than string length
76.2.18 works with UPDATE
76.2.19 works with invalid CLOB
76.2.20 works with substr
76.3 Multiple CLOBs, BIND INOUT
76.3.1 bind a txt file and a 32K string
76.3.2 bind a txt file and a (64K - 1) string
76.3.3 bind a txt file and a (64K + 1) string
77. blobPlsqlBindAsBuffer_bindin.js
77.1 BLOB, PLSQL, BIND_IN
77.1.1 works with EMPTY_BLOB
77.1.2 works with EMPTY_BLOB and bind in maxSize set to 1
77.1.3 works with EMPTY_BLOB and bind in maxSize set to (64K - 1)
77.1.4 works with null
77.1.5 works with null and bind in maxSize set to 1
77.1.6 works with null and bind in maxSize set to (64K - 1)
77.1.7 works with empty buffer
77.1.8 works with empty buffer and bind in maxSize set to 1
77.1.9 works with empty buffer and bind in maxSize set to (64K - 1)
77.1.10 works with undefined
77.1.11 works with undefined and bind in maxSize set to 1
77.1.12 works with undefined and bind in maxSize set to (64K - 1)
77.1.13 works with NaN
77.1.14 works with 0
77.1.15 works with Buffer size 32K
77.1.16 works with Buffer size (64K - 1)
77.1.17 works with Buffer size (64K + 1)
77.1.18 works with Buffer size (1MB + 1)
77.1.19 works with bind value and type mismatch
77.1.20 mixing named with positional binding
77.1.21 works with invalid BLOB
77.1.22 works without maxSize
77.1.23 works with bind in maxSize smaller than buffer size
77.1.24 works with UPDATE
77.2 BLOB, PLSQL, BIND_IN to RAW
77.2.1 works with EMPTY_BLOB
77.2.2 works with EMPTY_BLOB and bind in maxSize set to 1
77.2.3 works with EMPTY_BLOB and bind in maxSize set to (64K - 1)
77.2.4 works with null
77.2.5 works with null and bind in maxSize set to 1
77.2.6 works with null and bind in maxSize set to (64K - 1)
77.2.7 works with empty buffer
77.2.8 works with empty buffer and bind in maxSize set to 1
77.2.9 works with empty buffer and bind in maxSize set to (64K - 1)
77.2.10 works with undefined
77.2.11 works with undefined and bind in maxSize set to 1
77.2.12 works with undefined and bind in maxSize set to (64K - 1)
77.2.13 works with NaN
77.2.14 works with 0
77.2.15 works with Buffer size (32K - 1)
77.2.16 works with Buffer size 32K
77.2.17 works with invalid BLOB
77.2.18 works without maxSize
77.2.19 works with bind in maxSize smaller than buffer size
77.2.20 works with UPDATE
77.3 Multiple BLOBs, BIND_IN
77.3.1 bind two Buffer
77.3.2 bind a JPG file and a Buffer
77.3.3 bind two Buffer, one > (64K - 1)
78. blobPlsqlBindAsBuffer_bindout.js
78.1 BLOB, PLSQL, BIND_OUT
78.1.1 works with EMPTY_BLOB
78.1.2 works with EMPTY_BLOB and bind out maxSize set to 1
78.1.3 works with EMPTY_BLOB and bind out maxSize set to (64K - 1)
78.1.4 works with null
78.1.5 works with null and bind out maxSize set to 1
78.1.6 works with null and bind out maxSize set to (64K - 1)
78.1.7 works with empty buffer
78.1.8 works with empty buffer and bind out maxSize set to 1
78.1.9 works with empty buffer and bind out maxSize set to (64K - 1)
78.1.10 works with undefined
78.1.11 works with undefined and bind out maxSize set to 1
78.1.12 works with undefined and bind out maxSize set to (64K - 1)
78.1.13 works with Buffer size 32K
78.1.14 works with Buffer size (64K - 1)
78.1.15 works with Buffer size (64K + 1)
78.1.16 works with Buffer size (1MB + 1)
78.1.17 mixing named with positional binding
78.1.18 works with UPDATE
78.1.19 works with dbms_lob.substr()
78.1.20 named binding: bind out maxSize smaller than buffer size( < 32K )
78.1.21 named binding: bind out maxSize smaller than buffer size( > 32K )
78.1.22 named binding: bind out maxSize smaller than buffer size( > 64K )
78.1.23 positional binding: bind out maxSize smaller than buffer size( < 32K )
78.1.24 positional binding: bind out maxSize smaller than buffer size( > 32K )
78.1.25 positional binding: bind out maxSize smaller than buffer size( > 64K )
78.1.26 bind out without maxSize
78.1.28 bind out without maxSize
78.2 BLOB, PLSQL, BIND_OUT to RAW
78.2.1 works with EMPTY_BLOB
78.2.2 works with EMPTY_BLOB and bind out maxSize set to 1
78.2.3 works with EMPTY_BLOB and bind out maxSize set to (64K - 1)
78.2.4 works with null
78.2.5 works with null and bind out maxSize set to 1
78.2.6 works with null and bind out maxSize set to (64K - 1)
78.2.7 works with empty buffer
78.2.8 works with empty buffer and bind out maxSize set to 1
78.2.9 works with empty buffer and bind out maxSize set to (64K - 1)
78.2.10 works with undefined
78.2.11 works with undefined and bind out maxSize set to 1
78.2.12 works with undefined and bind out maxSize set to (64K - 1)
78.2.13 works with Buffer size (32K - 1)
78.2.14 works with Buffer size 32K
78.2.15 works with bind out maxSize smaller than buffer size
78.2.16 bind out without maxSize
78.2.17 works with UPDATE
78.2.18 works with dbms_lob.substr()
78.3 Multiple BLOBs, BIND_OUT
78.3.1 bind two buffer
78.3.2 PLSQL, BIND_OUT, bind a JPG file and a Buffer
78.3.3 bind two buffer, one > (64K - 1)
79. blobPlsqlBindAsBuffer_bindinout.js
79.1 BLOB, PLSQL, BIND_INOUT
79.1.1 works with EMPTY_BLOB
79.1.2 works with EMPTY_BLOB and maxSize set to 1
79.1.3 works with EMPTY_BLOB and maxSize set to (64K - 1)
79.1.4 works with null
79.1.5 works with null and maxSize set to 1
79.1.6 works with null and maxSize set to (64K - 1)
79.1.7 works with empty buffer
79.1.8 works with empty buffer and maxSize set to 1
79.1.9 works with empty buffer and maxSize set to (64K - 1)
79.1.10 works with undefined
79.1.11 works with undefined and maxSize set to 1
79.1.12 works with undefined and maxSize set to (64K - 1)
79.1.13 works with NaN
79.1.14 works with 0
79.1.15 works with buffer size 32K
79.1.16 works with buffer size (64K - 1)
79.1.17 works with buffer size (64K + 1)
79.1.18 works with buffer size (1MB + 1)
79.1.19 works with bind value and type mismatch
79.1.20 mixing named with positional binding
79.1.21 works with invalid BLOB
79.1.22 works with substr
79.1.23 works with UPDATE
79.1.24 named binding: maxSize smaller than buffer size ( < 32K )
79.1.25 named binding: maxSize smaller than buffer size ( > 32K )
79.1.26 named binding: maxSize smaller than buffer size ( > 64K )
79.1.27 positional binding: maxSize smaller than buffer size ( < 32K )
79.1.28 positional binding: maxSize smaller than buffer size ( > 32K )
79.1.29 positional binding: maxSize smaller than buffer size ( > 64K )
79.1.30 bind without maxSize
79.2 BLOB, PLSQL, BIND_INOUT to RAW
79.2.1 works with EMPTY_BLOB
79.2.2 works with EMPTY_BLOB and maxSize set to 1
79.2.3 works with EMPTY_BLOB and maxSize set to (64K - 1)
79.2.4 works with null
79.2.5 works with null and maxSize set to 1
79.2.6 works with null and maxSize set to (64K - 1)
79.2.7 works with empty buffer
79.2.8 works with empty buffer and maxSize set to 1
79.2.9 works with empty buffer and maxSize set to (64K - 1)
79.2.10 works with undefined
79.2.11 works with undefined and maxSize set to 1
79.2.12 works with undefined and maxSize set to (64K - 1)
79.2.13 works with NaN
79.2.14 works with 0
79.2.15 works with buffer size (32K - 1)
79.2.16 works with buffer size 32K
79.2.17 works with buffer size > maxSize
79.2.18 works with invalid BLOB
79.2.19 works with substr
79.2.20 works with UPDATE
79.2.21 works without maxSize
79.3 Multiple BLOBs, BIND_INOUT
79.3.1 bind a JPG and a 32K buffer
79.3.2 bind two buffers
79.3.3 bind two buffers, one > (64K - 1)
80. lobBindAsStringBuffer.js
80.1 Multiple LOBs, BIND_IN
80.1.1 PLSQL, CLOB&BLOB, bind a string and a buffer
80.1.2 PLSQL, CLOB&BLOB, bind a string and a JPG file
80.1.3 PLSQL, CLOB&BLOB, bind a txt file and a Buffer
80.2 Multiple LOBs, BIND_OUT
80.2.1 PLSQL, CLOB&BLOB, bind a string and a buffer
80.2.2 PLSQL, CLOB&BLOB, bind a string and a JPG file
80.2.3 PLSQL, CLOB&BLOB, bind a txt file and a buffer
80.3 Multiple LOBs, BIND_INOUT
80.3.1 PLSQL, BIND_INOUT, bind a 32K string and a 32K buffer
80.3.2 PLSQL, BIND_INOUT, bind a (64K - 1) string and a (64K - 1) buffer
81. clobDMLBindAsString.js
81.1 CLOB, INSERT
81.1.1 works with EMPTY_CLOB
81.1.2 works with empty string
81.1.3 works with empty string and bind in maxSize set to 32767
81.1.4 works with empty string and bind in maxSize set to 50000
81.1.5 works with undefined
81.1.6 works with null
81.1.7 works with null and bind in maxSize set to 32767
81.1.8 works with null and bind in maxSize set to 50000
81.1.9 works with NaN
81.1.10 works with 0
81.1.11 works with String length 32K
81.1.12 works with String length (64K - 1)
81.1.13 works with String length (64K + 1)
81.1.14 works with String length (1MB + 1)
81.1.15 bind value and type mismatch
81.1.16 mixing named with positional binding
81.1.17 bind with invalid CLOB
81.1.18 RETURNING INTO with bind type STRING
81.1.19 works with bind in maxSize smaller than string length
81.2 CLOB, UPDATE
81.2.1 update EMPTY_CLOB column
81.2.2 update a column with EMPTY_CLOB
81.2.3 update EMPTY_CLOB column with empty string
81.2.4 update empty string column
81.2.5 update a column with empty string
82. blobDMLBindAsBuffer.js
82.1 BLOB, INSERT
82.1.1 works with EMPTY_BLOB
82.1.2 works with empty buffer
82.1.3 works with empty buffer and bind in maxSize set to 32767
82.1.4 works with empty buffer and bind in maxSize set to 50000
82.1.5 works with undefined
82.1.6 works with null
82.1.7 works with null and bind in maxSize set to 32767
82.1.8 works with null and bind in maxSize set to 50000
82.1.9 works with NaN
82.1.10 works with 0
82.1.11 works with Buffer length 32K
82.1.12 works with Buffer length (64K - 1)
82.1.13 works with Buffer length (64K + 1)
82.1.14 works with Buffer length (1MB + 1)
82.1.15 bind value and type mismatch
82.1.16 mixing named with positional binding
82.1.17 bind with invalid BLOB
82.1.18 RETURNING INTO with bind type BUFFER
82.1.19 works with bind in maxSize smaller than buffer size
82.2 BLOB, UPDATE
82.2.1 update EMPTY_BLOB column
82.2.2 update a column with EMPTY_BLOB
82.2.3 update EMPTY_BLOB column with empty buffer
82.2.4 update empty buffer column
82.2.5 update a column with empty buffer
83. lobProperties2.js
83.1 CLOB: chunkSize (read-only)
83.2 BLOB: chunkSize (read-only)
83.3 CLOB: length (read-only)
83.4 BLOB: length (read-only)
83.5 CLOB: type (read-only)
83.6 BLOB: type (read-only)
83.7 pieceSize
83.7.1 default value is chunkSize
83.7.2 can be increased
83.7.3 can be decreased
83.7.4 can be zero
83.7.5 cannot be less than zero
83.7.6 cannot be null
83.7.7 must be a number
84. fetchClobAsString1.js
84.1 fetch CLOB columns by setting oracledb.fetchAsString
84.1.1 works with NULL value
84.1.2 works with empty string
84.1.3 works with small CLOB data
84.1.4 works with (64K - 1) data
84.1.5 works with (64K + 1) data
84.1.6 works with (1MB + 1) data
84.1.7 fetch with substr()
84.1.8 works with EMPTY_CLOB()
84.1.9 fetch multiple CLOB columns as String
84.1.10 fetch the same CLOB column multiple times
84.1.11 works with update statement
84.1.12 works with REF CURSOR
84.1.13 fetch CLOB with stream
84.1.14 works with setting oracledb.maxRows < actual number of rows in the table
84.1.15 works with setting oracledb.maxRows > actual number of rows in the table
84.1.16 override oracledb.fetchAsString with fetchInfo set to oracledb.DEFAULT
84.1.17 works with connection.queryStream()
84.1.18 works with connection.queryStream() and oracledb.maxRows > actual number of rows in the table
84.1.19 works with connection.queryStream() and oracledb.maxRows = actual number of rows in the table
84.1.20 works with connection.queryStream() and oracledb.maxRows < actual number of rows in the table
84.2 fetch CLOB columns by setting oracledb.fetchAsString and outFormat = oracledb.OUT_FORMAT_OBJECT
84.2.1 works with NULL value
84.2.2 works with empty String
84.2.3 works with small value
84.2.4 works with (64K - 1) value
84.2.5 works with (64K + 1) value
84.2.6 works with (1MB + 1) data
84.2.7 works with dbms_lob.substr()
84.2.8 works with EMPTY_CLOB()
84.2.9 fetch multiple CLOB rows as String
84.2.10 fetch the same CLOB column multiple times
84.2.11 works with update statement
84.2.12 works with REF CURSOR
84.2.13 fetch CLOB with stream
84.2.14 works with setting oracledb.maxRows < actual number of rows in the table
84.2.15 works with setting oracledb.maxRows > actual number of rows in the table
84.2.16 override oracledb.fetchAsString with fetchInfo set to oracledb.DEFAULT
84.3 fetch CLOB columns by setting oracledb.fetchAsString, outFormat = oracledb.OUT_FORMAT_OBJECT and resultSet = true
84.3.1 works with NULL value
84.3.2 works with empty String
84.3.3 works with small value
84.3.4 works with (64K - 1) value
84.3.5 works with (64K + 1) value
84.3.6 works with (1MB + 1) data
84.3.7 works with dbms_lob.substr()
84.3.8 works with EMPTY_CLOB()
84.3.9 fetch multiple CLOB rows as String
84.3.10 fetch the same CLOB column multiple times
84.3.11 works with update statement
84.3.13 fetch CLOB with stream
84.3.14 works with setting oracledb.maxRows < actual number of rows in the table
84.3.15 works with setting oracledb.maxRows > actual number of rows in the table
84.3.16 override oracledb.fetchAsString with fetchInfo set to oracledb.DEFAULT
84.4 fetch CLOB columns by setting oracledb.fetchAsString and outFormat = oracledb.OUT_FORMAT_ARRAY
84.4.1 works with NULL value
84.4.2 works with empty String
84.4.3 works with small value
84.4.4 works with (64K - 1) value
84.4.5 works with (64K + 1) value
84.4.6 works with (1MB + 1) data
84.4.7 works with dbms_lob.substr()
84.4.8 works with EMPTY_CLOB()
84.4.9 fetch multiple CLOB rows as String
84.4.10 fetch the same CLOB column multiple times
84.4.11 works with update statement
84.4.12 works with REF CURSOR
84.4.13 fetch CLOB with stream
84.4.14 works with setting oracledb.maxRows < actual number of rows in the table
84.4.15 works with setting oracledb.maxRows < actual number of rows in the table
84.4.16 override oracledb.fetchAsString with fetchInfo set to oracledb.DEFAULT
84.5 fetch CLOB columns by setting oracledb.fetchAsString, outFormat = oracledb.OUT_FORMAT_ARRAY and resultSet = true
84.5.1 works with NULL value
84.5.2 works with empty String
84.5.3 works with small value
84.5.4 works with (64K - 1) value
84.5.5 works with (64K + 1) value
84.5.6 works with (1MB + 1) data
84.5.7 works with dbms_lob.substr()
84.5.8 works with EMPTY_CLOB()
84.5.9 fetch multiple CLOB rows as String
84.5.10 fetch the same CLOB column multiple times
84.5.11 works with update statement
84.5.13 fetch CLOB with stream
84.5.14 works with setting oracledb.maxRows < actual number of rows in the table
84.5.15 works with setting oracledb.maxRows > actual number of rows in the table
84.5.16 override oracledb.fetchAsString with fetchInfo set to oracledb.DEFAULT
85. fetchClobAsString2.js
85.1 fetch CLOB columns by setting fetchInfo option
85.1.1 works with NULL value
85.1.2 works with empty String
85.1.3 works with small value
85.1.4 works with (64K - 1) value
85.1.5 works with (64K + 1) value
85.1.6 works with (1MB + 1) value
85.1.7 works with dbms_lob.substr()
85.1.8 works with EMPTY_CLOB()
85.1.9 fetch multiple CLOB rows as String
85.1.10 fetch the same CLOB column multiple times
85.1.11 works with update statement
85.1.12 works with setting oracledb.maxRows < actual number of rows in the table
85.1.13 works with setting oracledb.maxRows > actual number of rows in the table
85.1.14 works with connection.queryStream()
85.1.15 works with connection.queryStream() and oracledb.maxRows > actual number of rows in the table
85.1.16 works with connection.queryStream() and oracledb.maxRows = actual number of rows in the table
85.1.17 works with connection.queryStream() and oracledb.maxRows < actual number of rows in the table
85.1.18 works with REF CURSOR
85.2 fetch CLOB columns by setting fetchInfo option and outFormat = oracledb.OUT_FORMAT_OBJECT
85.2.1 works with NULL value
85.2.2 works with empty buffer
85.2.3 works with small value
85.2.4 works with (64K - 1) value
85.2.5 works with (64K + 1) value
85.2.6 works with (1MB + 1) value
85.2.7 works with dbms_lob.substr()
85.2.8 works with EMPTY_CLOB()
85.2.9 fetch multiple CLOB rows as String
85.2.10 fetch the same CLOB column multiple times
85.2.11 works with update statement
85.2.12 works with setting oracledb.maxRows < actual number of rows in the table
85.2.13 works with setting oracledb.maxRows > actual number of rows in the table
85.2.14 works with REF CURSOR
85.3 fetch CLOB columns by setting fetchInfo option, outFormat = oracledb.OUT_FORMAT_OBJECT and resultSet = true
85.3.1 works with NULL value
85.3.2 works with empty buffer
85.3.3 works with small value
85.3.4 works with (64K - 1) value
85.3.5 works with (64K + 1) value
85.3.6 works with (1MB + 1) value
85.3.7 works with dbms_lob.substr()
85.3.8 works with EMPTY_CLOB()
85.3.9 fetch multiple CLOB rows as String
85.3.10 fetch the same CLOB column multiple times
85.3.11 works with update statement
85.3.12 works with setting oracledb.maxRows < actual number of rows in the table
85.3.13 works with setting oracledb.maxRows > actual number of rows in the table
85.4 fetch CLOB columns by setting fetchInfo option and outFormat = oracledb.OUT_FORMAT_ARRAY
85.4.1 works with NULL value
85.4.2 works with empty String
85.4.3 works with small value
85.4.4 works with (64K - 1) value
85.4.5 works with (64K + 1) value
85.4.6 works with (1MB + 1) value
85.4.7 works with dbms_lob.substr()
85.4.8 works with EMPTY_CLOB()
85.4.9 fetch multiple CLOB rows as String
85.4.10 fetch the same CLOB column multiple times
85.4.11 works with update statement
85.4.12 works with setting oracledb.maxRows < actual number of rows in the table
85.4.13 works with setting oracledb.maxRows > actual number of rows in the table
85.4.14 works with REF CURSOR
85.5 fetch CLOB columns by setting fetchInfo option, outFormat = oracledb.OUT_FORMAT_ARRAY and resultSet = true
85.5.1 works with NULL value
85.5.2 works with empty String
85.5.3 works with small value
85.5.4 works with (64K - 1) value
85.5.5 works with (64K + 1) value
85.5.6 works with (1MB + 1) value
85.5.7 works with dbms_lob.substr()
85.5.8 works with EMPTY_CLOB()
85.5.9 fetch multiple CLOB rows as String
85.5.10 fetch the same CLOB column multiple times
85.5.11 works with update statement
85.5.12 works with setting oracledb.maxRows < actual number of rows in the table
85.5.13 works with setting oracledb.maxRows > actual number of rows in the table
86. fetchClobAsString3.js
86.1 fetch multiple CLOBs
86.1.1 fetch multiple CLOB columns as String
86.1.2 fetch two CLOB columns, one as string, another streamed
86.1.3 works with Restult Set
86.2 types support for fetchAsString property
86.2.1 String not supported in fetchAsString
86.2.2 BLOB not supported in fetchAsString
86.2.3 Cursor not supported in fetchAsString
86.2.4 Buffer supported in fetchAsString
86.2.5 Number supported in fetchAsString
86.2.6 Date supported in fetchAsString
86.2.7 CLOB supported in fetchAsString
86.2.8 undefined in fetchAsString will throw NJS-004
86.2.9 Random string in fetchAsString will throw NJS-004
86.2.10 Random integer in fetchAsString will throw NJS-021
86.2.11 Negative integer in fetchAsString will throw NJS-004
86.2.12 Random float in fetchAsString will throw NJS-004
86.2.13 Array in fetchAsString will throw NJS-004
86.2.14 Object in fetchAsString will throw NJS-004
86.2.15 Non-Array as fetchAsString will throw NJS-004
87. fetchBlobAsBuffer1.js
87.1 fetch BLOB columns by setting oracledb.fetchAsBuffer
87.1.1 works with NULL value
87.1.2 works with empty Buffer
87.1.3 works with small value
87.1.4 works with (64K - 1) value
87.1.5 works with (64K + 1) value
87.1.6 works with (1MB + 1) data
87.1.7 works with dbms_lob.substr()
87.1.8 works with EMPTY_BLOB()
87.1.9 fetch multiple BLOB rows as Buffer
87.1.10 fetch the same BLOB column multiple times
87.1.11 works with update statement
87.1.12 works with REF CURSOR
87.1.13 fetch BLOB with stream
87.1.14 works with setting oracledb.maxRows < actual number of rows in the table
87.1.15 works with setting oracledb.maxRows > actual number of rows in the table
87.1.16 override oracledb.fetchAsBuffer with fetchInfo set to oracledb.DEFAULT
87.1.17 works with connection.queryStream()
87.1.18 works with connection.queryStream() and oracledb.maxRows > actual number of rows in the table
87.1.19 works with connection.queryStream() and oracledb.maxRows = actual number of rows in the table
87.1.20 works with connection.queryStream() and oracledb.maxRows < actual number of rows in the table
87.2 fetch BLOB columns by setting oracledb.fetchAsBuffer and outFormat =
oracledb.OUT_FORMAT_OBJECT
87.2.1 works with NULL value
87.2.2 works with empty Buffer
87.2.3 works with small value
87.2.4 works with (64K - 1) value
87.2.5 works with (64K + 1) value
87.2.6 works with (1MB + 1) data
87.2.7 works with dbms_lob.substr()
87.2.8 works with EMPTY_BLOB()
87.2.9 fetch multiple BLOB rows as Buffer
87.2.10 fetch the same BLOB column multiple times
87.2.11 works with update statement
87.2.12 works with REF CURSOR
87.2.13 fetch BLOB with stream
87.2.14 works with setting oracledb.maxRows < actual number of rows in the table
87.2.15 works with setting oracledb.maxRows > actual number of rows in the table
87.2.16 override oracledb.fetchAsBuffer with fetchInfo set to oracledb.DEFAULT
87.3 fetch BLOB columns by setting oracledb.fetchAsBuffer, outFormat =
oracledb.OUT_FORMAT_OBJECT and resultSet = true
87.3.1 works with NULL value
87.3.2 works with empty Buffer
87.3.3 works with small value
87.3.4 works with (64K - 1) value
87.3.5 works with (64K + 1) value
87.3.6 works with (1MB + 1) data
87.3.7 works with dbms_lob.substr()
87.3.8 works with EMPTY_BLOB()
87.3.9 fetch multiple BLOB rows as Buffer
87.3.10 fetch the same BLOB column multiple times
87.3.11 works with update statement
87.3.12 works with REF CURSOR
87.3.13 fetch BLOB with stream
87.3.14 works with setting oracledb.maxRows < actual number of rows in the table
87.3.15 works with setting oracledb.maxRows > actual number of rows in the table
87.3.16 override oracledb.fetchAsBuffer with fetchInfo set to oracledb.DEFAULT
87.4 fetch BLOB columns by setting oracledb.fetchAsBuffer and outFormat = oracledb.OUT_FORMAT_ARRAY
87.4.1 works with NULL value
87.4.2 works with empty Buffer
87.4.3 works with small value
87.4.4 works with (64K - 1) value
87.4.5 works with (64K + 1) value
87.4.6 works with (1MB + 1) data
87.4.7 works with dbms_lob.substr()
87.4.8 works with EMPTY_BLOB()
87.4.9 fetch multiple BLOB rows as Buffer
87.4.10 fetch the same BLOB column multiple times
87.4.11 works with update statement
87.4.12 works with REF CURSOR
87.4.13 fetch BLOB with stream
87.4.14 works with setting oracledb.maxRows < actual number of rows in the table
87.4.15 works with setting oracledb.maxRows < actual number of rows in the table
87.4.16 override oracledb.fetchAsBuffer with fetchInfo set to oracledb.DEFAULT
87.5 fetch BLOB columns by setting oracledb.fetchAsBuffer, outFormat = oracledb.OUT_FORMAT_ARRAY and resultSet = true
87.5.1 works with NULL value
87.5.2 works with empty Buffer
87.5.3 works with small value
87.5.4 works with (64K - 1) value
87.5.5 works with (64K + 1) value
87.5.6 works with (1MB + 1) data
87.5.7 works with dbms_lob.substr()
87.5.8 works with EMPTY_BLOB()
87.5.9 fetch multiple BLOB rows as Buffer
87.5.10 fetch the same BLOB column multiple times
87.5.11 works with update statement
87.5.12 works with REF CURSOR
87.5.13 fetch BLOB with stream
87.5.14 works with setting oracledb.maxRows < actual number of rows in the table
87.5.15 works with setting oracledb.maxRows > actual number of rows in the table
87.5.16 override oracledb.fetchAsBuffer with fetchInfo set to oracledb.DEFAULT
88. fetchBlobAsBuffer2.js
88.1 fetch BLOB columns by setting fetchInfo option
88.1.1 works with NULL value
88.1.2 works with empty Buffer
88.1.3 works with small value
88.1.4 works with (64K - 1) value
88.1.5 works with (64K + 1) value
88.1.6 works with (1MB + 1) value
88.1.7 works with dbms_lob.substr()
88.1.8 works with EMPTY_BLOB()
88.1.9 fetch multiple BLOB rows as Buffer
88.1.10 fetch the same BLOB column multiple times
88.1.11 works with update statement
88.1.12 works with setting oracledb.maxRows < actual number of rows in the table
88.1.13 works with setting oracledb.maxRows > actual number of rows in the table
88.1.14 works with connection.queryStream()
88.1.15 works with connection.queryStream() and oracledb.maxRows > actual number of rows in the table
88.1.16 works with connection.queryStream() and oracledb.maxRows = actual number of rows in the table
88.1.17 works with connection.queryStream() and oracledb.maxRows < actual number of rows in the table
88.2 fetch BLOB columns by setting fetchInfo option and outFormat =
oracledb.OUT_FORMAT_OBJECT
88.2.1 works with NULL value
88.2.2 works with empty buffer
88.2.3 works with small value
88.2.4 works with (64K - 1) value
88.2.5 works with (64K + 1) value
88.2.6 works with (1MB + 1) value
88.2.7 works with dbms_lob.substr()
88.2.8 works with EMPTY_BLOB()
88.2.9 fetch multiple BLOB rows as Buffer
88.2.10 fetch the same BLOB column multiple times
88.2.11 works with update statement
88.2.12 works with setting oracledb.maxRows < actual number of rows in the table
88.2.13 works with setting oracledb.maxRows > actual number of rows in the table
88.3 fetch BLOB columns by setting fetchInfo option, outFormat =
oracledb.OUT_FORMAT_OBJECT and resultSet = true
88.3.1 works with NULL value
88.3.2 works with empty buffer
88.3.3 works with small value
88.3.4 works with (64K - 1) value
88.3.5 works with (64K + 1) value
88.3.6 works with (1MB + 1) value
88.3.7 works with dbms_lob.substr()
88.3.8 works with EMPTY_BLOB()
88.3.9 fetch multiple BLOB rows as Buffer
88.3.10 fetch the same BLOB column multiple times
88.3.11 works with update statement
88.3.12 works with setting oracledb.maxRows < actual number of rows in the table
88.3.13 works with setting oracledb.maxRows > actual number of rows in the table
88.4 fetch BLOB columns by setting fetchInfo option and outFormat = oracledb.OUT_FORMAT_ARRAY
88.4.1 works with NULL value
88.4.2 works with empty Buffer
88.4.3 works with small value
88.4.4 works with (64K - 1) value
88.4.5 works with (64K + 1) value
88.4.6 works with (1MB + 1) value
88.4.7 works with dbms_lob.substr()
88.4.8 works with EMPTY_BLOB()
88.4.9 fetch multiple BLOB rows as Buffer
88.4.10 fetch the same BLOB column multiple times
88.4.11 works with update statement
88.4.12 works with setting oracledb.maxRows < actual number of rows in the table
88.4.13 works with setting oracledb.maxRows > actual number of rows in the table
88.5 fetch BLOB columns by setting fetchInfo option, outFormat = oracledb.OUT_FORMAT_ARRAY and resultSet = true
88.5.1 works with NULL value
88.5.2 works with empty Buffer
88.5.3 works with small value
88.5.4 works with (64K - 1) value
88.5.5 works with (64K + 1) value
88.5.6 works with (1MB + 1) value
88.5.7 works with dbms_lob.substr()
88.5.8 works with EMPTY_BLOB()
88.5.9 fetch multiple BLOB rows as Buffer
88.5.10 fetch the same BLOB column multiple times
88.5.11 works with update statement
88.5.12 works with setting oracledb.maxRows < actual number of rows in the table
88.5.13 works with setting oracledb.maxRows > actual number of rows in the table
89. fetchBlobAsBuffer3.js
89.1 fetch multiple BLOBs
89.1.1 fetch multiple BLOB columns as Buffer
89.1.2 fetch two BLOB columns, one as string, another streamed
89.2 types support for fetchAsBuffer property
89.2.1 String not supported in fetchAsBuffer
89.2.2 CLOB not supported in fetchAsBuffer
89.2.3 Number not supported in fetchAsBuffer
89.2.4 Date not supported in fetchAsBuffer
89.2.5 Cursor not supported in fetchAsBuffer
89.2.6 Buffer not supported in fetchAsBuffer
89.2.7 BLOB supported in fetchAsBuffer
89.2.8 negative - null value for fetchAsBuffer
89.2.9 negative - undefined value for fetchAsBuffer
89.2.10 negative - numeric value for fetchAsBuffer
89.2.11 negative - empty string value for fetchAsBuffer
89.2.12 negative - arbitary string value for fetchAsBuffer
89.2.13 negative - date value for fetchAsBuffer
89.2.14 negative - buffer value for fetchAsBuffer
90. fetchClobAsString4.js
90.1 PLSQL FUNCTION RETURN CLOB to STRING
90.1.1 bind by position - 1
90.1.2 bind by name - 1
90.1.3 bind by position - 2
90.1.4 bind by name - 2
90.2 PLSQL PROCEDURE BIND OUT CLOB to STRING
90.2.1 bind by position - 1
90.2.2 bind by name - 1
90.2.3 bind by position - 2
90.2.4 bind by name - 2
90.3 PLSQL FUNCTION RETURN CLOB to VARCHAR2
90.3.1 bind by name - 1
90.3.2 bind by position - 1
90.3.3 bind by name - 2
90.3.4 bind by position - 2
91. fetchBlobAsBuffer4.js
91.1 PLSQL FUNCTION RETURN BLOB to BUFFER
91.1.1 bind by position - 1
91.1.2 bind by name - 1
91.1.3 bind by position - 2
91.1.4 bind by name - 2
91.2 PLSQL PROCEDURE BIND OUT BLOB to BUFFER
91.2.1 bind by position - 1
91.2.2 bind by name - 1
91.2.3 bind by position - 2
91.2.4 bind by name - 2
91.3 PLSQL FUNCTION RETURN BLOB to RAW
91.3.1 bind by name - 1
91.3.2 bind by position - 1
91.3.3 bind by name - 2
91.3.4 bind by position - 2
92.binding_DMLInsert.js
92.1 insert small value of oracledb.STRING/BUFFER
92.1.1 oracledb.STRING <--> DB: NUMBER
92.1.2 oracledb.STRING <--> DB: CHAR
92.1.3 oracledb.STRING <--> DB: NCHAR
92.1.4 oracledb.STRING <--> DB: VARCHAR2
92.1.5 oracledb.STRING <--> DB: FLOAT
92.1.6 oracledb.STRING <--> DB: BINARY_FLOAT
92.1.7 oracledb.STRING <--> DB: BINARY_DOUBLE
92.1.8 oracledb.STRING <--> DB: DATE
92.1.9 oracledb.STRING <--> DB: TIMESTAMP
92.1.10 oracledb.STRING <--> DB: RAW
92.1.11 oracledb.STRING <--> DB: CLOB
92.1.12 oracledb.STRING <--> DB: BLOB
92.1.13 oracledb.BUFFER <--> DB: NUMBER
92.1.14 oracledb.BUFFER <--> DB: CHAR
92.1.15 oracledb.BUFFER <--> DB: NCHAR
92.1.16 oracledb.BUFFER <--> DB: VARCHAR2
92.1.17 oracledb.BUFFER <--> DB: FLOAT
92.1.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
92.1.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
92.1.20 oracledb.BUFFER <--> DB: DATE
92.1.21 oracledb.BUFFER <--> DB: TIMESTAMP
92.1.22 oracledb.BUFFER <--> DB: RAW
92.1.23 oracledb.BUFFER <--> DB: CLOB
92.1.24 oracledb.BUFFER <--> DB: BLOB
92.2 insert null value of oracledb.STRING/BUFFER
92.2.1 oracledb.STRING <--> DB: NUMBER
92.2.2 oracledb.STRING <--> DB: CHAR
92.2.3 oracledb.STRING <--> DB: NCHAR
92.2.4 oracledb.STRING <--> DB: VARCHAR2
92.2.5 oracledb.STRING <--> DB: FLOAT
92.2.6 oracledb.STRING <--> DB: BINARY_FLOAT
92.2.7 oracledb.STRING <--> DB: BINARY_DOUBLE
92.2.8 oracledb.STRING <--> DB: DATE
92.2.9 oracledb.STRING <--> DB: TIMESTAMP
92.2.10 oracledb.STRING <--> DB: RAW
92.2.11 oracledb.STRING <--> DB: CLOB
92.2.12 oracledb.STRING <--> DB: BLOB
92.2.13 oracledb.BUFFER <--> DB: NUMBER
92.2.14 oracledb.BUFFER <--> DB: CHAR
92.2.15 oracledb.BUFFER <--> DB: NCHAR
92.2.16 oracledb.BUFFER <--> DB: VARCHAR2
92.2.17 oracledb.BUFFER <--> DB: FLOAT
92.2.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
92.2.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
92.2.20 oracledb.BUFFER <--> DB: DATE
92.2.21 oracledb.BUFFER <--> DB: TIMESTAMP
92.2.22 oracledb.BUFFER <--> DB: RAW
92.2.23 oracledb.BUFFER <--> DB: CLOB
92.2.24 oracledb.BUFFER <--> DB: BLOB
92.3 insert large value of oracledb.STRING/BUFFER
92.3.1 oracledb.STRING <--> DB: NUMBER
92.3.2 oracledb.STRING <--> DB: CHAR
92.3.3 oracledb.STRING <--> DB: NCHAR
92.3.4 oracledb.STRING <--> DB: VARCHAR2
92.3.5 oracledb.STRING <--> DB: FLOAT
92.3.6 oracledb.STRING <--> DB: BINARY_FLOAT
92.3.7 oracledb.STRING <--> DB: BINARY_DOUBLE
92.3.8 oracledb.STRING <--> DB: DATE
92.3.9 oracledb.STRING <--> DB: TIMESTAMP
92.3.10 oracledb.STRING <--> DB: RAW
92.3.11 oracledb.STRING <--> DB: CLOB
92.3.12 oracledb.STRING <--> DB: BLOB
92.3.13 oracledb.BUFFER <--> DB: NUMBER
92.3.14 oracledb.BUFFER <--> DB: CHAR
92.3.15 oracledb.BUFFER <--> DB: NCHAR
92.3.16 oracledb.BUFFER <--> DB: VARCHAR2
92.3.17 oracledb.BUFFER <--> DB: FLOAT
92.3.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
92.3.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
92.3.20 oracledb.BUFFER <--> DB: DATE
92.3.21 oracledb.BUFFER <--> DB: TIMESTAMP
92.3.22 oracledb.BUFFER <--> DB: RAW
92.3.23 oracledb.BUFFER <--> DB: CLOB
92.3.24 oracledb.BUFFER <--> DB: BLOB
93.binding_procedureBindIn.js
93.1 PLSQL procedure: bind in small value of oracledb.STRING/BUFFER
93.1.1 oracledb.STRING <--> DB: NUMBER
93.1.2 oracledb.STRING <--> DB: CHAR
93.1.3 oracledb.STRING <--> DB: NCHAR
93.1.4 oracledb.STRING <--> DB: VARCHAR2
93.1.5 oracledb.STRING <--> DB: FLOAT
93.1.6 oracledb.STRING <--> DB: BINARY_FLOAT
93.1.7 oracledb.STRING <--> DB: BINARY_DOUBLE
93.1.8 oracledb.STRING <--> DB: DATE
93.1.9 oracledb.STRING <--> DB: TIMESTAMP
93.1.10 oracledb.STRING <--> DB: RAW
93.1.11 oracledb.STRING <--> DB: CLOB
93.1.12 oracledb.STRING <--> DB: BLOB
93.1.13 oracledb.BUFFER <--> DB: NUMBER
93.1.14 oracledb.BUFFER <--> DB: CHAR
93.1.15 oracledb.BUFFER <--> DB: NCHAR
93.1.16 oracledb.BUFFER <--> DB: VARCHAR2
93.1.17 oracledb.BUFFER <--> DB: FLOAT
93.1.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
93.1.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
93.1.20 oracledb.BUFFER <--> DB: DATE
93.1.21 oracledb.BUFFER <--> DB: TIMESTAMP
93.1.22 oracledb.BUFFER <--> DB: RAW
93.1.23 oracledb.BUFFER <--> DB: CLOB
93.1.24 oracledb.BUFFER <--> DB: BLOB
93.2 PLSQL procedure: bind in null value of oracledb.STRING/BUFFER
93.2.1 oracledb.STRING <--> DB: NUMBER
93.2.2 oracledb.STRING <--> DB: CHAR
93.2.3 oracledb.STRING <--> DB: NCHAR
93.2.4 oracledb.STRING <--> DB: VARCHAR2
93.2.5 oracledb.STRING <--> DB: FLOAT
93.2.6 oracledb.STRING <--> DB: BINARY_FLOAT
93.2.7 oracledb.STRING <--> DB: BINARY_DOUBLE
93.2.8 oracledb.STRING <--> DB: DATE
93.2.9 oracledb.STRING <--> DB: TIMESTAMP
93.2.10 oracledb.STRING <--> DB: RAW
93.2.11 oracledb.STRING <--> DB: CLOB
93.2.12 oracledb.STRING <--> DB: BLOB
93.2.13 oracledb.BUFFER <--> DB: NUMBER
93.2.14 oracledb.BUFFER <--> DB: CHAR
93.2.15 oracledb.BUFFER <--> DB: NCHAR
93.2.16 oracledb.BUFFER <--> DB: VARCHAR2
93.2.17 oracledb.BUFFER <--> DB: FLOAT
93.2.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
93.2.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
93.2.20 oracledb.BUFFER <--> DB: DATE
93.2.21 oracledb.BUFFER <--> DB: TIMESTAMP
93.2.22 oracledb.BUFFER <--> DB: RAW
93.2.23 oracledb.BUFFER <--> DB: CLOB
93.2.24 oracledb.BUFFER <--> DB: BLOB
94.binding_procedureBindInout.js
94.1 PLSQL procedure: bind inout small value of oracledb.STRING/BUFFER
94.1.1 oracledb.STRING <--> DB: NUMBER
94.1.2 oracledb.STRING <--> DB: CHAR
94.1.3 oracledb.STRING <--> DB: NCHAR
94.1.4 oracledb.STRING <--> DB: VARCHAR2
94.1.5 oracledb.STRING <--> DB: FLOAT
94.1.6 oracledb.STRING <--> DB: BINARY_FLOAT
94.1.7 oracledb.STRING <--> DB: BINARY_DOUBLE
94.1.8 oracledb.STRING <--> DB: DATE
94.1.9 oracledb.STRING <--> DB: TIMESTAMP
94.1.10 oracledb.STRING <--> DB: RAW
94.1.11 oracledb.STRING <--> DB: CLOB
94.1.12 oracledb.STRING <--> DB: BLOB
94.1.13 oracledb.BUFFER <--> DB: NUMBER
94.1.14 oracledb.BUFFER <--> DB: CHAR
94.1.15 oracledb.BUFFER <--> DB: NCHAR
94.1.16 oracledb.BUFFER <--> DB: VARCHAR2
94.1.17 oracledb.BUFFER <--> DB: FLOAT
94.1.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
94.1.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
94.1.20 oracledb.BUFFER <--> DB: DATE
94.1.21 oracledb.BUFFER <--> DB: TIMESTAMP
94.1.22 oracledb.BUFFER <--> DB: RAW
94.1.23 oracledb.BUFFER <--> DB: CLOB
94.1.24 oracledb.BUFFER <--> DB: BLOB
94.2 PLSQL procedure: bind inout null value of oracledb.STRING/BUFFER
94.2.1 oracledb.STRING <--> DB: NUMBER
94.2.2 oracledb.STRING <--> DB: CHAR
94.2.3 oracledb.STRING <--> DB: NCHAR
94.2.4 oracledb.STRING <--> DB: VARCHAR2
94.2.5 oracledb.STRING <--> DB: FLOAT
94.2.6 oracledb.STRING <--> DB: BINARY_FLOAT
94.2.7 oracledb.STRING <--> DB: BINARY_DOUBLE
94.2.8 oracledb.STRING <--> DB: DATE
94.2.9 oracledb.STRING <--> DB: TIMESTAMP
94.2.10 oracledb.STRING <--> DB: RAW
94.2.11 oracledb.STRING <--> DB: CLOB
94.2.12 oracledb.STRING <--> DB: BLOB
94.2.13 oracledb.BUFFER <--> DB: NUMBER
94.2.14 oracledb.BUFFER <--> DB: CHAR
94.2.15 oracledb.BUFFER <--> DB: NCHAR
94.2.16 oracledb.BUFFER <--> DB: VARCHAR2
94.2.17 oracledb.BUFFER <--> DB: FLOAT
94.2.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
94.2.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
94.2.20 oracledb.BUFFER <--> DB: DATE
94.2.21 oracledb.BUFFER <--> DB: TIMESTAMP
94.2.22 oracledb.BUFFER <--> DB: RAW
94.2.23 oracledb.BUFFER <--> DB: CLOB
94.2.24 oracledb.BUFFER <--> DB: BLOB
95.binding_functionBindInout.js
95.1 PLSQL function: bind inout small value of oracledb.STRING/BUFFER
95.1.1 oracledb.STRING <--> DB: NUMBER
95.1.2 oracledb.STRING <--> DB: CHAR
95.1.3 oracledb.STRING <--> DB: NCHAR
95.1.4 oracledb.STRING <--> DB: VARCHAR2
95.1.5 oracledb.STRING <--> DB: FLOAT
95.1.6 oracledb.STRING <--> DB: BINARY_FLOAT
95.1.7 oracledb.STRING <--> DB: BINARY_DOUBLE
95.1.8 oracledb.STRING <--> DB: DATE
95.1.9 oracledb.STRING <--> DB: TIMESTAMP
95.1.10 oracledb.STRING <--> DB: RAW
95.1.11 oracledb.STRING <--> DB: CLOB
95.1.12 oracledb.STRING <--> DB: BLOB
95.1.13 oracledb.BUFFER <--> DB: NUMBER
95.1.14 oracledb.BUFFER <--> DB: CHAR
95.1.15 oracledb.BUFFER <--> DB: NCHAR
95.1.16 oracledb.BUFFER <--> DB: VARCHAR2
95.1.17 oracledb.BUFFER <--> DB: FLOAT
95.1.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
95.1.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
95.1.20 oracledb.BUFFER <--> DB: DATE
95.1.21 oracledb.BUFFER <--> DB: TIMESTAMP
95.1.22 oracledb.BUFFER <--> DB: RAW
95.1.23 oracledb.BUFFER <--> DB: CLOB
95.1.24 oracledb.BUFFER <--> DB: BLOB
95.2 PLSQL function: bind inout null value of oracledb.STRING/BUFFER
95.2.1 oracledb.STRING <--> DB: NUMBER
95.2.2 oracledb.STRING <--> DB: CHAR
95.2.3 oracledb.STRING <--> DB: NCHAR
95.2.4 oracledb.STRING <--> DB: VARCHAR2
95.2.5 oracledb.STRING <--> DB: FLOAT
95.2.6 oracledb.STRING <--> DB: BINARY_FLOAT
95.2.7 oracledb.STRING <--> DB: BINARY_DOUBLE
95.2.8 oracledb.STRING <--> DB: DATE
95.2.9 oracledb.STRING <--> DB: TIMESTAMP
95.2.10 oracledb.STRING <--> DB: RAW
95.2.11 oracledb.STRING <--> DB: CLOB
95.2.12 oracledb.STRING <--> DB: BLOB
95.2.13 oracledb.BUFFER <--> DB: NUMBER
95.2.14 oracledb.BUFFER <--> DB: CHAR
95.2.15 oracledb.BUFFER <--> DB: NCHAR
95.2.16 oracledb.BUFFER <--> DB: VARCHAR2
95.2.17 oracledb.BUFFER <--> DB: FLOAT
95.2.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
95.2.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
95.2.20 oracledb.BUFFER <--> DB: DATE
95.2.21 oracledb.BUFFER <--> DB: TIMESTAMP
95.2.22 oracledb.BUFFER <--> DB: RAW
95.2.23 oracledb.BUFFER <--> DB: CLOB
95.2.24 oracledb.BUFFER <--> DB: BLOB
96.binding_procedureBindOut.js
96.1 PLSQL procedure: bind out small value to oracledb.STRING/BUFFER
96.1.1 oracledb.STRING <--> DB: NUMBER
96.1.2 oracledb.STRING <--> DB: CHAR
96.1.3 oracledb.STRING <--> DB: NCHAR
96.1.4 oracledb.STRING <--> DB: VARCHAR2
96.1.5 oracledb.STRING <--> DB: FLOAT
96.1.6 oracledb.STRING <--> DB: BINARY_FLOAT
96.1.7 oracledb.STRING <--> DB: BINARY_DOUBLE
96.1.8 oracledb.STRING <--> DB: DATE
96.1.9 oracledb.STRING <--> DB: TIMESTAMP
96.1.10 oracledb.STRING <--> DB: RAW
96.1.11 oracledb.STRING <--> DB: CLOB
96.1.12 oracledb.STRING <--> DB: BLOB
96.1.13 oracledb.BUFFER <--> DB: NUMBER
96.1.14 oracledb.BUFFER <--> DB: CHAR
96.1.15 oracledb.BUFFER <--> DB: NCHAR
96.1.16 oracledb.BUFFER <--> DB: VARCHAR2
96.1.17 oracledb.BUFFER <--> DB: FLOAT
96.1.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
96.1.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
96.1.20 oracledb.BUFFER <--> DB: DATE
96.1.21 oracledb.BUFFER <--> DB: TIMESTAMP
96.1.22 oracledb.BUFFER <--> DB: RAW
96.1.23 oracledb.BUFFER <--> DB: CLOB
96.1.24 oracledb.BUFFER <--> DB: BLOB
96.2 PLSQL procedure: bind out null value to oracledb.STRING/BUFFER
96.2.1 oracledb.STRING <--> DB: NUMBER
96.2.2 oracledb.STRING <--> DB: CHAR
96.2.3 oracledb.STRING <--> DB: NCHAR
96.2.4 oracledb.STRING <--> DB: VARCHAR2
96.2.5 oracledb.STRING <--> DB: FLOAT
96.2.6 oracledb.STRING <--> DB: BINARY_FLOAT
96.2.7 oracledb.STRING <--> DB: BINARY_DOUBLE
96.2.8 oracledb.STRING <--> DB: DATE
96.2.9 oracledb.STRING <--> DB: TIMESTAMP
96.2.10 oracledb.STRING <--> DB: RAW
96.2.11 oracledb.STRING <--> DB: CLOB
96.2.12 oracledb.STRING <--> DB: BLOB
96.2.13 oracledb.BUFFER <--> DB: NUMBER
96.2.14 oracledb.BUFFER <--> DB: CHAR
96.2.15 oracledb.BUFFER <--> DB: NCHAR
96.2.16 oracledb.BUFFER <--> DB: VARCHAR2
96.2.17 oracledb.BUFFER <--> DB: FLOAT
96.2.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
96.2.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
96.2.20 oracledb.BUFFER <--> DB: DATE
96.2.21 oracledb.BUFFER <--> DB: TIMESTAMP
96.2.22 oracledb.BUFFER <--> DB: RAW
96.2.23 oracledb.BUFFER <--> DB: CLOB
96.2.24 oracledb.BUFFER <--> DB: BLOB
97.binding_functionBindOut.js
97.1 PLSQL function: bind out small value to oracledb.STRING/BUFFER
97.1.1 oracledb.STRING <--> DB: NUMBER
97.1.2 oracledb.STRING <--> DB: CHAR
97.1.3 oracledb.STRING <--> DB: NCHAR
97.1.4 oracledb.STRING <--> DB: VARCHAR2
97.1.5 oracledb.STRING <--> DB: FLOAT
97.1.6 oracledb.STRING <--> DB: BINARY_FLOAT
97.1.7 oracledb.STRING <--> DB: BINARY_DOUBLE
97.1.8 oracledb.STRING <--> DB: DATE
97.1.9 oracledb.STRING <--> DB: TIMESTAMP
97.1.10 oracledb.STRING <--> DB: RAW
97.1.11 oracledb.STRING <--> DB: CLOB
97.1.12 oracledb.STRING <--> DB: BLOB
97.1.13 oracledb.BUFFER <--> DB: NUMBER
97.1.14 oracledb.BUFFER <--> DB: CHAR
97.1.15 oracledb.BUFFER <--> DB: NCHAR
97.1.16 oracledb.BUFFER <--> DB: VARCHAR2
97.1.17 oracledb.BUFFER <--> DB: FLOAT
97.1.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
97.1.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
97.1.20 oracledb.BUFFER <--> DB: DATE
97.1.21 oracledb.BUFFER <--> DB: TIMESTAMP
97.1.22 oracledb.BUFFER <--> DB: RAW
97.1.23 oracledb.BUFFER <--> DB: CLOB
97.1.24 oracledb.BUFFER <--> DB: BLOB
97.2 PLSQL function: bind out null value to oracledb.STRING/BUFFER
97.2.1 oracledb.STRING <--> DB: NUMBER
97.2.2 oracledb.STRING <--> DB: CHAR
97.2.3 oracledb.STRING <--> DB: NCHAR
97.2.4 oracledb.STRING <--> DB: VARCHAR2
97.2.5 oracledb.STRING <--> DB: FLOAT
97.2.6 oracledb.STRING <--> DB: BINARY_FLOAT
97.2.7 oracledb.STRING <--> DB: BINARY_DOUBLE
97.2.8 oracledb.STRING <--> DB: DATE
97.2.9 oracledb.STRING <--> DB: TIMESTAMP
97.2.10 oracledb.STRING <--> DB: RAW
97.2.11 oracledb.STRING <--> DB: CLOB
97.2.12 oracledb.STRING <--> DB: BLOB
97.2.13 oracledb.BUFFER <--> DB: NUMBER
97.2.14 oracledb.BUFFER <--> DB: CHAR
97.2.15 oracledb.BUFFER <--> DB: NCHAR
97.2.16 oracledb.BUFFER <--> DB: VARCHAR2
97.2.17 oracledb.BUFFER <--> DB: FLOAT
97.2.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
97.2.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
97.2.20 oracledb.BUFFER <--> DB: DATE
97.2.21 oracledb.BUFFER <--> DB: TIMESTAMP
97.2.22 oracledb.BUFFER <--> DB: RAW
97.2.23 oracledb.BUFFER <--> DB: CLOB
97.2.24 oracledb.BUFFER <--> DB: BLOB
98.binding_DMLReturningInto.js
98.1 bind out small value
98.1.1 oracledb.STRING <--> DB: NUMBER
98.1.2 oracledb.STRING <--> DB: CHAR
98.1.3 oracledb.STRING <--> DB: NCHAR
98.1.4 oracledb.STRING <--> DB: VARCHAR2
98.1.5 oracledb.STRING <--> DB: FLOAT
98.1.6 oracledb.STRING <--> DB: BINARY_FLOAT
98.1.7 oracledb.STRING <--> DB: BINARY_DOUBLE
98.1.8 oracledb.STRING <--> DB: DATE
98.1.9 oracledb.STRING <--> DB: TIMESTAMP
98.1.10 oracledb.STRING <--> DB: RAW
98.1.11 oracledb.STRING <--> DB: CLOB
98.1.12 oracledb.STRING <--> DB: BLOB
98.1.13 oracledb.BUFFER <--> DB: NUMBER
98.1.14 oracledb.BUFFER <--> DB: CHAR
98.1.15 oracledb.BUFFER <--> DB: NCHAR
98.1.16 oracledb.BUFFER <--> DB: VARCHAR2
98.1.17 oracledb.BUFFER <--> DB: FLOAT
98.1.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
98.1.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
98.1.20 oracledb.BUFFER <--> DB: DATE
98.1.21 oracledb.BUFFER <--> DB: TIMESTAMP
98.1.22 oracledb.BUFFER <--> DB: RAW
98.1.23 oracledb.BUFFER <--> DB: CLOB
98.1.24 oracledb.BUFFER <--> DB: BLOB
98.2 bind out null value
98.2.1 oracledb.STRING <--> DB: NUMBER
98.2.2 oracledb.STRING <--> DB: CHAR
98.2.3 oracledb.STRING <--> DB: NCHAR
98.2.4 oracledb.STRING <--> DB: VARCHAR2
98.2.5 oracledb.STRING <--> DB: FLOAT
98.2.6 oracledb.STRING <--> DB: BINARY_FLOAT
98.2.7 oracledb.STRING <--> DB: BINARY_DOUBLE
98.2.8 oracledb.STRING <--> DB: DATE
98.2.9 oracledb.STRING <--> DB: TIMESTAMP
98.2.10 oracledb.STRING <--> DB: RAW
98.2.11 oracledb.STRING <--> DB: CLOB
98.2.12 oracledb.STRING <--> DB: BLOB
98.2.13 oracledb.BUFFER <--> DB: NUMBER
98.2.14 oracledb.BUFFER <--> DB: CHAR
98.2.15 oracledb.BUFFER <--> DB: NCHAR
98.2.16 oracledb.BUFFER <--> DB: VARCHAR2
98.2.17 oracledb.BUFFER <--> DB: FLOAT
98.2.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
98.2.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
98.2.20 oracledb.BUFFER <--> DB: DATE
98.2.21 oracledb.BUFFER <--> DB: TIMESTAMP
98.2.22 oracledb.BUFFER <--> DB: RAW
98.2.23 oracledb.BUFFER <--> DB: CLOB
98.2.24 oracledb.BUFFER <--> DB: BLOB
99.binding_functionBindIn.js
99.1 PLSQL function: bind in small value of oracledb.STRING/BUFFER
99.1.1 oracledb.STRING <--> DB: NUMBER
99.1.2 oracledb.STRING <--> DB: CHAR
99.1.3 oracledb.STRING <--> DB: NCHAR
99.1.4 oracledb.STRING <--> DB: VARCHAR2
99.1.5 oracledb.STRING <--> DB: FLOAT
99.1.6 oracledb.STRING <--> DB: BINARY_FLOAT
99.1.7 oracledb.STRING <--> DB: BINARY_DOUBLE
99.1.8 oracledb.STRING <--> DB: DATE
99.1.9 oracledb.STRING <--> DB: TIMESTAMP
99.1.10 oracledb.STRING <--> DB: RAW
99.1.11 oracledb.STRING <--> DB: CLOB
99.1.12 oracledb.STRING <--> DB: BLOB
99.1.13 oracledb.BUFFER <--> DB: NUMBER
99.1.14 oracledb.BUFFER <--> DB: CHAR
99.1.15 oracledb.BUFFER <--> DB: NCHAR
99.1.16 oracledb.BUFFER <--> DB: VARCHAR2
99.1.17 oracledb.BUFFER <--> DB: FLOAT
99.1.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
99.1.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
99.1.20 oracledb.BUFFER <--> DB: DATE
99.1.21 oracledb.BUFFER <--> DB: TIMESTAMP
99.1.22 oracledb.BUFFER <--> DB: RAW
99.1.23 oracledb.BUFFER <--> DB: CLOB
99.1.24 oracledb.BUFFER <--> DB: BLOB
99.2 PLSQL function: bind in null value of oracledb.STRING/BUFFER
99.2.1 oracledb.STRING <--> DB: NUMBER
99.2.2 oracledb.STRING <--> DB: CHAR
99.2.3 oracledb.STRING <--> DB: NCHAR
99.2.4 oracledb.STRING <--> DB: VARCHAR2
99.2.5 oracledb.STRING <--> DB: FLOAT
99.2.6 oracledb.STRING <--> DB: BINARY_FLOAT
99.2.7 oracledb.STRING <--> DB: BINARY_DOUBLE
99.2.8 oracledb.STRING <--> DB: DATE
99.2.9 oracledb.STRING <--> DB: TIMESTAMP
99.2.10 oracledb.STRING <--> DB: RAW
99.2.11 oracledb.STRING <--> DB: CLOB
99.2.12 oracledb.STRING <--> DB: BLOB
99.2.13 oracledb.BUFFER <--> DB: NUMBER
99.2.14 oracledb.BUFFER <--> DB: CHAR
99.2.15 oracledb.BUFFER <--> DB: NCHAR
99.2.16 oracledb.BUFFER <--> DB: VARCHAR2
99.2.17 oracledb.BUFFER <--> DB: FLOAT
99.2.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
99.2.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
99.2.20 oracledb.BUFFER <--> DB: DATE
99.2.21 oracledb.BUFFER <--> DB: TIMESTAMP
99.2.22 oracledb.BUFFER <--> DB: RAW
99.2.23 oracledb.BUFFER <--> DB: CLOB
99.2.24 oracledb.BUFFER <--> DB: BLOB
100.binding_defaultBindIn.js
100.1 PLSQL procedure: bind in null value with default type and dir
100.1.1 oracledb.STRING <--> DB: NUMBER
100.1.2 oracledb.STRING <--> DB: CHAR
100.1.3 oracledb.STRING <--> DB: NCHAR
100.1.4 oracledb.STRING <--> DB: VARCHAR2
100.1.5 oracledb.STRING <--> DB: FLOAT
100.1.6 oracledb.STRING <--> DB: BINARY_FLOAT
100.1.7 oracledb.STRING <--> DB: BINARY_DOUBLE
100.1.8 oracledb.STRING <--> DB: DATE
100.1.9 oracledb.STRING <--> DB: TIMESTAMP
100.1.10 oracledb.STRING <--> DB: RAW
100.1.11 oracledb.STRING <--> DB: CLOB
100.1.12 oracledb.STRING <--> DB: BLOB
100.1.13 oracledb.BUFFER <--> DB: NUMBER
100.1.14 oracledb.BUFFER <--> DB: CHAR
100.1.15 oracledb.BUFFER <--> DB: NCHAR
100.1.16 oracledb.BUFFER <--> DB: VARCHAR2
100.1.17 oracledb.BUFFER <--> DB: FLOAT
100.1.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
100.1.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
100.1.20 oracledb.BUFFER <--> DB: DATE
100.1.21 oracledb.BUFFER <--> DB: TIMESTAMP
100.1.22 oracledb.BUFFER <--> DB: RAW
100.1.23 oracledb.BUFFER <--> DB: CLOB
100.1.24 oracledb.BUFFER <--> DB: BLOB
100.2 PLSQL function: bind in null value with default type and dir
100.2.1 oracledb.STRING <--> DB: NUMBER
100.2.2 oracledb.STRING <--> DB: CHAR
100.2.3 oracledb.STRING <--> DB: NCHAR
100.2.4 oracledb.STRING <--> DB: VARCHAR2
100.2.5 oracledb.STRING <--> DB: FLOAT
100.2.6 oracledb.STRING <--> DB: BINARY_FLOAT
100.2.7 oracledb.STRING <--> DB: BINARY_DOUBLE
100.2.8 oracledb.STRING <--> DB: DATE
100.2.9 oracledb.STRING <--> DB: TIMESTAMP
100.2.10 oracledb.STRING <--> DB: RAW
100.2.11 oracledb.STRING <--> DB: CLOB
100.2.12 oracledb.STRING <--> DB: BLOB
100.2.13 oracledb.BUFFER <--> DB: NUMBER
100.2.14 oracledb.BUFFER <--> DB: CHAR
100.2.15 oracledb.BUFFER <--> DB: NCHAR
100.2.16 oracledb.BUFFER <--> DB: VARCHAR2
100.2.17 oracledb.BUFFER <--> DB: FLOAT
100.2.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
100.2.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
100.2.20 oracledb.BUFFER <--> DB: DATE
100.2.21 oracledb.BUFFER <--> DB: TIMESTAMP
100.2.22 oracledb.BUFFER <--> DB: RAW
100.2.23 oracledb.BUFFER <--> DB: CLOB
100.2.24 oracledb.BUFFER <--> DB: BLOB
101.binding_defaultBindInout.js
101.1 PLSQL procedure: bind out null value with default type and dir
101.1.1 oracledb.STRING <--> DB: NUMBER
101.1.2 oracledb.STRING <--> DB: CHAR
101.1.3 oracledb.STRING <--> DB: NCHAR
101.1.4 oracledb.STRING <--> DB: VARCHAR2
101.1.5 oracledb.STRING <--> DB: FLOAT
101.1.6 oracledb.STRING <--> DB: BINARY_FLOAT
101.1.7 oracledb.STRING <--> DB: BINARY_DOUBLE
101.1.8 oracledb.STRING <--> DB: DATE
101.1.9 oracledb.STRING <--> DB: TIMESTAMP
101.1.10 oracledb.STRING <--> DB: RAW
101.1.11 oracledb.STRING <--> DB: CLOB
101.1.12 oracledb.STRING <--> DB: BLOB
101.1.13 oracledb.BUFFER <--> DB: NUMBER
101.1.14 oracledb.BUFFER <--> DB: CHAR
101.1.15 oracledb.BUFFER <--> DB: NCHAR
101.1.16 oracledb.BUFFER <--> DB: VARCHAR2
101.1.17 oracledb.BUFFER <--> DB: FLOAT
101.1.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
101.1.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
101.1.20 oracledb.BUFFER <--> DB: DATE
101.1.21 oracledb.BUFFER <--> DB: TIMESTAMP
101.1.22 oracledb.BUFFER <--> DB: RAW
101.1.23 oracledb.BUFFER <--> DB: CLOB
101.1.24 oracledb.BUFFER <--> DB: BLOB
101.2 PLSQL procedure bind out null value with default type and dir
101.2.1 oracledb.STRING <--> DB: NUMBER
101.2.2 oracledb.STRING <--> DB: CHAR
101.2.3 oracledb.STRING <--> DB: NCHAR
101.2.4 oracledb.STRING <--> DB: VARCHAR2
101.2.5 oracledb.STRING <--> DB: FLOAT
101.2.6 oracledb.STRING <--> DB: BINARY_FLOAT
101.2.7 oracledb.STRING <--> DB: BINARY_DOUBLE
101.2.8 oracledb.STRING <--> DB: DATE
101.2.9 oracledb.STRING <--> DB: TIMESTAMP
101.2.10 oracledb.STRING <--> DB: RAW
101.2.11 oracledb.STpRING <--> DB: CLOB
101.2.12 oracledb.STRING <--> DB: BLOB
101.2.13 oracledb.BUFFER <--> DB: NUMBER
101.2.14 oracledb.BUFFER <--> DB: CHAR
101.2.15 oracledb.BUFFER <--> DB: NCHAR
101.2.16 oracledb.BUFFER <--> DB: VARCHAR2
101.2.17 oracledb.BUFFER <--> DB: FLOAT
101.2.18 oracledb.BUFFER <--> DB: BINARY_FLOAT
101.2.19 oracledb.BUFFER <--> DB: BINARY_DOUBLE
101.2.20 oracledb.BUFFER <--> DB: DATE
101.2.21 oracledb.BUFFER <--> DB: TIMESTAMP
101.2.22 oracledb.BUFFER <--> DB: RAW
101.2.23 oracledb.BUFFER <--> DB: CLOB
101.2.24 oracledb.BUFFER <--> DB: BLOB
102. bindTimestamp.js
102.1 DML, IN bind, bind by name
102.2 DML, IN bind, bind by position
102.3 DML, IN bind, Null
102.4 Negative - IN bind, value and type mismatch
102.5 DML, OUT bind, bind by position
102.6 DML, OUT bind, bind by name
102.7 Negative - OUB bind, value and type mismatch
102.8 DML, INOUT bind, bind by position
102.9 DML, INOUT bind, bind by name
102.10 Negative - INOUT bind, in bind value and type mismatch
102.11 Negative - INOUT bind, out bind value and type mismatch
102.12 DML, INOUT bind, Null values
PL/SQL, IN bind
102.13 PL/SQL, IN bind, bind by name
102.14 PL/SQL, IN bind, bind by position
102.15 PL/SQL, IN bind, Null
102.16 Negative - PL/SQL, IN bind, value and type mismatch
102.17 Negative - type and value mismatch, BLOB
102.18 Negative - type and value mismatch, BUFFER
102.19 Negative - type and value mismatch, CLOB
102.20 Negative - type and value mismatch, CURSOR
102.21 Negative - type and value mismatch, DEFAULT
102.22 Negative - type and value mismatch, NUMBER
102.23 Negative - type and value mismatch, STRING
102.24 Negative - type and value mismatch, NOTEXIST
PL/SQL, OUT bind
102.25 PL/SQL, OUT bind, bind by position
102.26 PL/SQL, OUT bind, bind by name
102.27 PL/SQL, OUT bind, Null
102.28 Negative - PL/SQL, OUT bind, value and type mismatch
102.29 Negative - type and value mismatch, BLOB
102.30 Negative - type and value mismatch, BUFFER
102.31 Negative - type and value mismatch, CLOB
102.32 Negative - type and value mismatch, CURSOR
102.33 Negative - type and value mismatch, DEFAULT
102.34 Negative - type and value mismatch, NUMBER
102.35 Negative - type and value mismatch, STRING
102.36 Negative - type and value mismatch, NOTEXIST
PL/SQL, IN OUT bind
102.37 PL/SQL, IN OUT bind, bind by name
102.38 PL/SQL, IN OUT bind, bind by position
102.39 PL/SQL, IN OUT bind, Null
102.40 Negative - value and type mismatch
102.41 Negative - type and value mismatch, BLOB
102.42 Negative - type and value mismatch, BUFFER
102.43 Negative - type and value mismatch, CLOB
102.44 Negative - type and value mismatch, CURSOR
102.45 Negative - type and value mismatch, DEFAULT
102.46 Negative - type and value mismatch, NUMBER
102.47 Negative - type and value mismatch, STRING
103. dataTypeLong.js
103.1 LONG data type support
103.1.1 SELECT query
103.1.2 works well with result set
103.1.3 works well with REF Cursor
103.2 stores null values correctly
103.2.1 testing Null, Empty string and Undefined
104. dataTypeLongRaw.js
104.1 LONG RAW data type support
104.1.1 SELECT query
104.1.2 works well with result set
104.1.3 works well with REF Cursor
104.2 stores null values correctly
104.2.1 testing Null, Empty string and Undefined
105. streamErrorEvent.js
105.1 triggers stream error event
106. fetchRowidAsString.js
106.1 works with fetchInfo option
106.1.1 fetchInfo
106.1.2 fetchInfo, and oracledb.maxRows < actual number of rows
106.1.3 fetchInfo, and oracledb.maxRows = actual number of rows
106.1.4 fetchInfo, and oracledb.maxRows > actual number of rows
106.1.5 fetchInfo, queryStream() and oracledb.maxRows < actual number of rows
106.1.6 fetchInfo, queryStream() and oracledb.maxRows = actual number of rows
106.1.7 fetchInfo, queryStream() and oracledb.maxRows > actual number of rows
106.1.8 fetchInfo, resultSet = true
106.2 works with fetchInfo and outFormat = OBJECT
106.2.1 fetchInfo with outFormat = OBJECT
106.2.2 fetchInfo, outFormat = OBJECT, and resultSet = true
106.2.3 fetchInfo, outFormat = OBJECT, and oracledb.maxRows < actual number of rows
106.2.4 fetchInfo, outFormat = OBJECT, and oracledb.maxRows = actual number of rows
106.2.5 fetchInfo, outFormat = OBJECT, and oracledb.maxRows > actual number of rows
106.2.6 fetchInfo, outFormat = OBJECT, queryStream() and oracledb.maxRows < actual number of rows
106.2.7 fetchInfo, outFormat = OBJECT, queryStream() and oracledb.maxRows = actual number of rows
106.2.8 fetchInfo, outFormat = OBJECT, queryStream() and oracledb.maxRows > actual number of rows
106.3 works with fetchInfo and outFormat = ARRAY
106.3.1 fetchInfo
106.3.2 fetchInfo, and oracledb.maxRows < actual number of rows
106.3.3 fetchInfo, and oracledb.maxRows = actual number of rows
106.3.4 fetchInfo, and oracledb.maxRows > actual number of rows
106.3.5 fetchInfo, queryStream() and oracledb.maxRows < actual number of rows
106.3.6 fetchInfo, queryStream() and oracledb.maxRows = actual number of rows
106.3.7 fetchInfo, queryStream() and oracledb.maxRows > actual number of rows
106.3.8 fetchInfo, resultSet = true
106.4 fetch as string by default
106.4.1 fetch by default
106.4.2 oracledb.maxRows < actual number of rows
106.4.3 oracledb.maxRows = actual number of rows
106.4.4 oracledb.maxRows > actual number of rows
106.4.5 queryStream() and oracledb.maxRows < actual number of rows
106.4.6 queryStream() and oracledb.maxRows = actual number of rows
106.4.7 queryStream() and oracledb.maxRows > actual number of rows
106.4.8 resultSet = true
106.5 fetch as string by default with outFormat = OBJECT
106.5.1 fetch by default
106.5.2 oracledb.maxRows < actual number of rows
106.5.3 oracledb.maxRows = actual number of rows
106.5.4 oracledb.maxRows > actual number of rows
106.5.5 queryStream() and oracledb.maxRows < actual number of rows
106.5.6 queryStream() and oracledb.maxRows = actual number of rows
106.5.7 queryStream() and oracledb.maxRows > actual number of rows
106.5.8 resultSet = true
106.6 fetch as string by default with outFormat = ARRAY
106.6.1 fetch by default
106.6.2 oracledb.maxRows < actual number of rows
106.6.3 oracledb.maxRows = actual number of rows
106.6.4 oracledb.maxRows > actual number of rows
106.6.5 queryStream() and oracledb.maxRows < actual number of rows
106.6.6 queryStream() and oracledb.maxRows = actual number of rows
106.6.7 queryStream() and oracledb.maxRows > actual number of rows
106.6.8 resultSet = true
107. rowidDMLBindAsString.js
107.1 INSERT & SELECT
107.1.1 works with null
107.1.2 works with empty string
107.1.3 works with extended rowid
107.1.4 works with restricted rowid
107.1.5 throws error with number 0
107.1.6 works with string 0
107.1.7 works with substr
107.1.8 bind null with default type/dir - named bind
107.1.9 bind null with default type/dir - positional bind
107.1.10 bind extented rowid with default type/dir - named bind
107.1.11 bind extented rowid with default type/dir - positional bind
107.1.12 works with undefined
107.1.13 bind undefined with default type/dir - named bind
107.1.14 bind undefined with default type/dir - positional bind
107.1.15 works with NaN
107.2 UPDATE
107.2.1 UPDATE null column
107.2.1 UPDATE extented rowid with restricted rowid
107.2.3 UPDATE restricted rowid with null
107.3 RETURNING INTO
107.3.1 INSERT null
107.3.2 INSERT extented rowid
107.3.3 INSERT restricted rowid
107.3.7 UPDATE null with extented rowid
107.3.8 UPDATE extented rowid with null
107.3.9 UPDATE restricted rowid with empty string
107.3.10 UPDATE restricted rowid with extented rowid
107.3.11 INSERT with default type/dir - named bind
107.3.12 INSERT with default type/dir - positional bind
107.3.13 UPDATE with default type/dir - named bind
107.3.14 UPDATE with default type/dir - positional bind
107.4 WHERE
107.4.1 can bind in WHERE clause
108. rowidProcedureBindAsString_bindin.js
108.1 PROCEDURE BIND_IN as rowid
108.1.1 works with null
108.1.2 works with empty string
108.1.3 works with undefined
108.1.4 works with NaN
108.1.5 works with extended rowid
108.1.6 works with restricted rowid
108.1.7 works with string 0
108.1.8 works with number 0
108.1.9 works with default bind type/dir - extended rowid
108.1.10 works with default bind type/dir - null value
108.1.11 works with default bind type/dir - empty string
108.1.12 works with default bind type/dir - undefined
108.1.13 bind error: NJS-037
108.1.14 bind error: NJS-052
108.2 PROCEDURE BIND_IN as string
108.2.1 works with null
108.2.2 works with empty string
108.2.3 works with undefined
108.2.4 works with NaN
108.2.5 works with extended rowid
108.2.6 works with restricted rowid
108.2.7 works with string 0
108.2.8 works with number 0
108.2.9 works with default bind type/dir - extended rowid
108.2.10 works with default bind type/dir - null value
108.2.11 works with default bind type/dir - empty string
108.2.12 works with default bind type/dir - undefined
108.2.13 bind error: NJS-037
108.2.14 bind error: NJS-052
108.3 PROCEDURE BIND_IN, UPDATE
108.3.1 update null with rowid
108.3.2 update empty string with rowid
108.3.3 update undefined with rowid
108.3.4 works with default bind type/dir
108.3.5 works with default bind type/dir - null value
108.3.6 works with default bind type/dir - empty string
108.3.7 works with default bind type/dir - undefined
109. rowidFunctionBindAsString_bind.js
109.1 FUNCTION BIND_IN/OUT as rowid
109.1.1 works with null
109.1.2 works with empty string
109.1.3 works with undefined
109.1.4 works with NaN
109.1.5 works with extended rowid
109.1.6 works with restricted rowid
109.1.7 works with string 0
109.1.8 works with number 0
109.1.9 works with default bind type/dir - extended rowid
109.1.10 works with default bind type/dir - null value
109.1.11 works with default bind type/dir - empty string
109.1.12 works with default bind type/dir - undefined
109.1.13 bind error: NJS-037
109.1.14 bind error: NJS-052
109.2 FUNCTION BIND_IN/OUT as string
109.2.1 works with null
109.2.2 works with empty string
109.2.3 works with undefined
109.2.4 works with NaN
109.2.5 works with extended rowid
109.2.6 works with restricted rowid
109.2.7 works with string 0
109.2.8 works with number 0
109.2.9 works with default bind type/dir - extended rowid
109.2.10 works with default bind type/dir - null value
109.2.11 works with default bind type/dir - empty string
109.2.12 works with default bind type/dir - undefined
109.2.13 bind error: NJS-037
109.2.14 bind error: NJS-052
109.3 FUNCTION BIND_IN, UPDATE
109.3.1 update null with rowid
109.3.2 update empty string with rowid
109.3.3 update undefined with rowid
109.3.4 works with default bind type/dir
109.3.5 works with default bind type/dir - null value
109.3.6 works with default bind type/dir - empty string
109.3.7 works with default bind type/dir - undefined
110. rowidProcedureBindAsString_bindout.js
110.1 PROCEDURE BIND_OUT as rowid
110.1.1 works with null
110.1.2 works with empty string
110.1.3 works with undefined
110.1.4 works with NaN
110.1.5 works with extended rowid
110.1.6 works with restricted rowid
110.1.7 works with string 0
110.1.8 works with number 0
110.1.9 works with default bind type/dir - extended rowid
110.1.10 works with default bind type/dir - null value
110.1.11 works with default bind type/dir - empty string
110.1.12 works with default bind type/dir - undefined
110.1.13 bind error: NJS-037
110.1.14 bind error: NJS-052
110.2 PROCEDURE BIND_OUT as string
110.2.1 works with null
110.2.2 works with empty string
110.2.3 works with undefined
110.2.4 works with NaN
110.2.5 works with extended rowid
110.2.6 works with restricted rowid
110.2.7 works with string 0
110.2.8 works with number 0
110.2.9 works with default bind type/dir - extended rowid
110.2.10 works with default bind type/dir - null value
110.2.11 works with default bind type/dir - empty string
110.2.12 works with default bind type/dir - undefined
110.2.13 bind error: NJS-037
110.2.14 bind error: NJS-052
110.3 PROCEDURE BIND_IN, UPDATE
110.3.1 update null with rowid
110.3.2 update empty string with rowid
110.3.3 update undefined with rowid
110.3.4 works with default bind type/dir
110.3.5 works with default bind type/dir - null value
110.3.6 works with default bind type/dir - empty string
110.3.7 works with default bind type/dir - undefined
111. rowidProcedureBindAsString_bindinout.js
111.1 PROCEDURE BIND_INOUT as rowid
111.1.1 works with null
111.1.2 works with empty string
111.1.3 works with undefined
111.1.4 works with NaN
111.1.5 works with extended rowid
111.1.6 works with restricted rowid
111.1.7 works with string 0
111.1.8 works with number 0
111.1.9 works with default bind type/dir - extended rowid
111.1.10 works with default bind type/dir - null value
111.1.11 works with default bind type/dir - empty string
111.1.12 works with default bind type/dir - undefined
111.1.13 bind error: NJS-037
111.1.14 bind error: NJS-052
111.2 PROCEDURE BIND_INOUT as string
111.2.1 works with null
111.2.2 works with empty string
111.2.3 works with undefined
111.2.4 works with NaN
111.2.5 works with extended rowid
111.2.6 works with restricted rowid
111.2.7 works with string 0
111.2.8 works with number 0
111.2.9 works with default bind type/dir - extended rowid
111.2.10 works with default bind type/dir - null value
111.2.11 works with default bind type/dir - empty string
111.2.12 works with default bind type/dir - undefined
111.2.13 bind error: NJS-037
111.2.14 bind error: NJS-052
111.3 PROCEDURE BIND_IN, UPDATE
111.3.1 update null with rowid
111.3.2 update empty string with rowid
111.3.3 update undefined with rowid
111.3.4 works with default bind type/dir
111.3.5 works with default bind type/dir - null value
111.3.6 works with default bind type/dir - empty string
111.3.7 works with default bind type/dir - undefined
112. rowidFunctionBindAsString_bindinout.js
112.1 FUNCTION BIND_INOUT as rowid
112.1.1 works with null
112.1.2 works with empty string
112.1.3 works with undefined
112.1.4 works with NaN
112.1.5 works with extended rowid
112.1.6 works with restricted rowid
112.1.7 works with string 0
112.1.8 works with number 0
112.1.9 works with default bind type/dir - extended rowid
112.1.10 works with default bind type/dir - null value
112.1.11 works with default bind type/dir - empty string
112.1.12 works with default bind type/dir - undefined
112.1.13 bind error: NJS-037
112.1.14 bind error: NJS-052
112.2 FUNCTION BIND_INOUT as string
112.2.1 works with null
112.2.2 works with empty string
112.2.3 works with undefined
112.2.4 works with NaN
112.2.5 works with extended rowid
112.2.6 works with restricted rowid
112.2.7 works with string 0
112.2.8 works with number 0
112.2.9 works with default bind type/dir - extended rowid
112.2.10 works with default bind type/dir - null value
112.2.11 works with default bind type/dir - empty string
112.2.12 works with default bind type/dir - undefined
112.2.13 bind error: NJS-037
112.2.14 bind error: NJS-052
112.3 FUNCTION BIND_INOUT, UPDATE
112.3.1 update null with rowid
112.3.2 update empty string with rowid
112.3.3 update undefined with rowid
112.3.4 works with default bind type/dir
112.3.5 works with default bind type/dir - null value
112.3.6 works with default bind type/dir - empty string
112.3.7 works with default bind type/dir - undefined
113. dataTypeUrowid.js
113.1 testing ROWID data type
113.1.1 query rowid
113.1.2 works well with result set
113.1.3 works well with REF Cursor
113.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
113.2 stores null value correctly
113.2.1 testing Null, Empty string and Undefined
114. urowidDMLBindAsString1.js
114.1 INSERT & SELECT
114.1.1 works with null
114.1.2 works with empty string
114.1.3 works with extended rowid
114.1.4 works with restricted rowid
114.1.5 throws error with number 0
114.1.6 works with string 0
114.1.7 works with substr
114.1.8 bind null with default type/dir - named bind
114.1.9 bind null with default type/dir - positional bind
114.1.10 bind extented rowid with default type/dir - named bind
114.1.11 bind extented rowid with default type/dir - positional bind
114.1.12 works with undefined
114.1.13 bind undefined with default type/dir - named bind
114.1.14 bind undefined with default type/dir - positional bind
114.1.15 works with NaN
114.2 UPDATE
114.2.1 UPDATE null column
114.2.1 UPDATE extented rowid with restricted rowid
114.2.3 UPDATE restricted rowid with null
114.3 RETURNING INTO
114.3.1 INSERT null
114.3.2 INSERT extented rowid
114.3.3 INSERT restricted rowid
114.3.7 UPDATE null with extented rowid
114.3.8 UPDATE extented rowid with null
114.3.9 UPDATE restricted rowid with empty string
114.3.10 UPDATE restricted rowid with extented rowid
114.3.11 INSERT with default type/dir - named bind
114.3.12 INSERT with default type/dir - positional bind
114.3.13 UPDATE with default type/dir - named bind
114.3.14 UPDATE with default type/dir - positional bind
107.4 WHERE
107.4.1 can bind in WHERE clause
115. urowidDMLBindAsString2.js
115.1 INSERT & SELECT
115.1.1 works with urowid length > 200
115.1.2 works with urowid length > 500
115.1.3 works with maxSize < 200
115.2 UPDATE
115.2.1 update null with urowid length > 200
115.2.2 update empty string with urowid length > 500
115.2.3 update with urowid length > 500
115.2.4 works with maxSize < 200
115.3 RETURNING INTO
115.3.1 urowid length > 200
115.3.2 urowid length > 500
115.4 WHERE
115.4.1 urowid length > 200
115.4.2 urowid length > 500
115.5 queryStream() and oracledb.maxRows = actual rows
115.5.1 urowid length > 200
115.5.2 urowid length > 500
115.6 queryStream() and oracledb.maxRows > actual rows
115.6.1 urowid length > 200
115.6.2 urowid length > 500
115.7 queryStream() and oracledb.maxRows < actual rows
115.7.1 urowid length > 200
115.7.2 urowid length > 500
116. fetchUrowidAsString.js
116.1 works with fetchInfo option
116.1.1 fetchInfo
116.1.2 fetchInfo, and oracledb.maxRows < actual number of rows
116.1.3 fetchInfo, and oracledb.maxRows = actual number of rows
116.1.4 fetchInfo, and oracledb.maxRows > actual number of rows
116.1.5 fetchInfo, queryStream() and oracledb.maxRows < actual number of rows
116.1.6 fetchInfo, queryStream() and oracledb.maxRows = actual number of rows
116.1.7 fetchInfo, queryStream() and oracledb.maxRows > actual number of rows
116.1.8 fetchInfo, resultSet = true
116.2 works with fetchInfo and outFormat = OBJECT
116.2.1 fetchInfo with outFormat = OBJECT
116.2.2 fetchInfo, outFormat = OBJECT, and resultSet = true
116.2.3 fetchInfo, outFormat = OBJECT, and oracledb.maxRows < actual number of rows
116.2.4 fetchInfo, outFormat = OBJECT, and oracledb.maxRows = actual number of rows
116.2.5 fetchInfo, outFormat = OBJECT, and oracledb.maxRows > actual number of rows
116.2.6 fetchInfo, outFormat = OBJECT, queryStream() and oracledb.maxRows < actual number of rows
116.2.7 fetchInfo, outFormat = OBJECT, queryStream() and oracledb.maxRows = actual number of rows
116.2.8 fetchInfo, outFormat = OBJECT, queryStream() and oracledb.maxRows > actual number of rows
116.3 works with fetchInfo and outFormat = ARRAY
116.3.1 fetchInfo
116.3.2 fetchInfo, and oracledb.maxRows < actual number of rows
116.3.3 fetchInfo, and oracledb.maxRows = actual number of rows
116.3.4 fetchInfo, and oracledb.maxRows > actual number of rows
116.3.5 fetchInfo, queryStream() and oracledb.maxRows < actual number of rows
116.3.6 fetchInfo, queryStream() and oracledb.maxRows = actual number of rows
116.3.7 fetchInfo, queryStream() and oracledb.maxRows > actual number of rows
116.3.8 fetchInfo, resultSet = true
116.4 fetch as string by default
116.4.1 fetch by default
116.4.2 oracledb.maxRows < actual number of rows
116.4.3 oracledb.maxRows = actual number of rows
116.4.4 oracledb.maxRows > actual number of rows
116.4.5 queryStream() and oracledb.maxRows < actual number of rows
116.4.6 queryStream() and oracledb.maxRows = actual number of rows
116.4.7 queryStream() and oracledb.maxRows > actual number of rows
116.4.8 resultSet = true
116.5 fetch as string by default with outFormat = OBJECT
116.5.1 fetch by default
116.5.2 oracledb.maxRows < actual number of rows
116.5.3 oracledb.maxRows = actual number of rows
116.5.4 oracledb.maxRows > actual number of rows
116.5.5 queryStream() and oracledb.maxRows < actual number of rows
116.5.6 queryStream() and oracledb.maxRows = actual number of rows
116.5.7 queryStream() and oracledb.maxRows > actual number of rows
116.5.8 resultSet = true
116.6 fetch as string by default with outFormat = ARRAY
116.6.1 fetch by default
116.6.2 oracledb.maxRows < actual number of rows
116.6.3 oracledb.maxRows = actual number of rows
116.6.4 oracledb.maxRows > actual number of rows
116.6.5 queryStream() and oracledb.maxRows < actual number of rows
116.6.6 queryStream() and oracledb.maxRows = actual number of rows
116.6.7 queryStream() and oracledb.maxRows > actual number of rows
116.6.8 resultSet = true
117. fetchUrowidAsString_indexed.js
117.1 works with fetchInfo option and urowid length > 200/500
117.1.1 fetchInfo
117.1.2 oracledb.maxRows < actual number of rows
117.1.3 oracledb.maxRows = actual number of rows
117.1.4 oracledb.maxRows > actual number of rows
117.1.5 resultSet = true
117.1.6 queryStream() and oracledb.maxRows < actual number of rows
117.1.7 queryStream() and oracledb.maxRows = actual number of rows
117.1.8 queryStream() and oracledb.maxRows > actual number of rows
117.2 works with fetchInfo and outFormat = OBJECT, urowid length > 200/500
117.2.1 fetchInfo
117.2.2 oracledb.maxRows < actual number of rows
117.2.3 oracledb.maxRows = actual number of rows
117.2.4 oracledb.maxRows > actual number of rows
117.2.5 resultSet = true
117.2.6 queryStream() and oracledb.maxRows < actual number of rows
117.2.7 queryStream() and oracledb.maxRows = actual number of rows
117.2.8 queryStream() and oracledb.maxRows > actual number of rows
117.3 works with fetchInfo and outFormat = ARRAY, urowid length > 200/500
117.3.1 fetchInfo
117.3.2 oracledb.maxRows < actual number of rows
117.3.3 oracledb.maxRows = actual number of rows
117.3.4 oracledb.maxRows > actual number of rows
117.3.5 resultSet = true
117.3.6 queryStream() and oracledb.maxRows < actual number of rows
117.3.7 queryStream() and oracledb.maxRows = actual number of rows
117.3.8 queryStream() and oracledb.maxRows > actual number of rows
117.4 fetch as string by default, urowid length > 200/500
117.4.1 fetchInfo
117.4.2 oracledb.maxRows < actual number of rows
117.4.3 oracledb.maxRows = actual number of rows
117.4.4 oracledb.maxRows > actual number of rows
117.4.5 resultSet = true
117.4.6 queryStream() and oracledb.maxRows < actual number of rows
117.4.7 queryStream() and oracledb.maxRows = actual number of rows
117.4.8 queryStream() and oracledb.maxRows > actual number of rows
117.5 fetch as string by default with outFormat = OBJECT, urowid length > 200/500
117.5.1 fetchInfo
117.5.2 oracledb.maxRows < actual number of rows
117.5.3 oracledb.maxRows = actual number of rows
117.5.4 oracledb.maxRows > actual number of rows
117.5.5 resultSet = true
117.5.6 queryStream() and oracledb.maxRows < actual number of rows
117.5.7 queryStream() and oracledb.maxRows = actual number of rows
117.5.8 queryStream() and oracledb.maxRows > actual number of rows
117.6 fetch as string by default with outFormat = ARRAY, urowid length > 200/500
117.6.1 fetchInfo
117.6.2 oracledb.maxRows < actual number of rows
117.6.3 oracledb.maxRows = actual number of rows
117.6.4 oracledb.maxRows > actual number of rows
117.6.5 resultSet = true
117.6.6 queryStream() and oracledb.maxRows < actual number of rows
117.6.7 queryStream() and oracledb.maxRows = actual number of rows
117.6.8 queryStream() and oracledb.maxRows > actual number of rows
118. urowidProcedureBindAsString1.js
118.1 PROCEDURE BIND_IN as UROWID
118.1.1 works with null
118.1.2 works with empty string
118.1.3 works with undefined
118.1.4 works with NaN
118.1.5 works with extended ROWID
118.1.6 works with restricted ROWID
118.1.7 works with string 0
118.1.8 works with number 0
118.1.9 works with default bind type/dir - extended ROWID
118.1.10 works with default bind type/dir - null value
118.1.11 works with default bind type/dir - empty string
118.1.12 works with default bind type/dir - undefined
118.1.13 bind error: NJS-037
118.1.14 bind error: NJS-052
118.2 PROCEDURE BIND_IN as string
118.2.1 works with null
118.2.2 works with empty string
118.2.3 works with undefined
118.2.4 works with NaN
118.2.5 works with extended ROWID
118.2.6 works with restricted ROWID
118.2.7 works with string 0
118.2.8 works with number 0
118.2.9 works with default bind type/dir - extended ROWID
118.2.10 works with default bind type/dir - null value
118.2.11 works with default bind type/dir - empty string
118.2.12 works with default bind type/dir - undefined
118.2.13 bind error: NJS-037
118.2.14 bind error: NJS-052
118.3 PROCEDURE BIND_IN, UPDATE
118.3.1 update null with UROWID
118.3.2 update empty string with UROWID
118.3.3 update undefined with UROWID
118.3.4 works with default bind type/dir
118.3.5 works with default bind type/dir - null value
118.3.6 works with default bind type/dir - empty string
118.3.7 works with default bind type/dir - undefined
119. urowidProcedureBindAsString2.js
119.1 PROCEDURE BIND_OUT as UROWID
119.1.1 works with null
119.1.2 works with empty string
119.1.3 works with undefined
119.1.4 works with NaN
119.1.5 works with extended ROWID
119.1.6 works with restricted ROWID
119.1.7 works with string 0
119.1.8 works with number 0
119.1.9 works with default bind type/dir - extended ROWID
119.1.10 works with default bind type/dir - null value
119.1.11 works with default bind type/dir - empty string
119.1.12 works with default bind type/dir - undefined
119.1.13 bind error: NJS-037
119.1.14 bind error: NJS-052
119.2 PROCEDURE BIND_OUT as string
119.2.1 works with null
119.2.2 works with empty string
119.2.3 works with undefined
119.2.4 works with NaN
119.2.5 works with extended ROWID
119.2.6 works with restricted ROWID
119.2.7 works with string 0
119.2.8 works with number 0
119.2.9 works with default bind type/dir - extended ROWID
119.2.10 works with default bind type/dir - null value
119.2.11 works with default bind type/dir - empty string
119.2.12 works with default bind type/dir - undefined
119.2.13 bind error: NJS-037
119.2.14 bind error: NJS-052
119.3 PROCEDURE BIND_IN, UPDATE
119.3.1 update null with UROWID
119.3.2 update empty string with UROWID
119.3.3 update undefined with UROWID
119.3.4 works with default bind type/dir
119.3.5 works with default bind type/dir - null value
119.3.6 works with default bind type/dir - empty string
119.3.7 works with default bind type/dir - undefined
120. urowidProcedureBindAsString3.js
120.1 PROCEDURE BIND_INOUT as UROWID
120.1.1 works with null
120.1.2 works with empty string
120.1.3 works with undefined
120.1.4 works with NaN
120.1.5 works with extended ROWID
120.1.6 works with restricted ROWID
120.1.7 works with string 0
120.1.8 works with number 0
120.1.9 works with default bind type/dir - extended ROWID
120.1.10 works with default bind type/dir - null value
120.1.11 works with default bind type/dir - empty string
120.1.12 works with default bind type/dir - undefined
120.1.13 bind error: NJS-037
120.1.14 bind error: NJS-052
120.2 PROCEDURE BIND_INOUT as string
120.2.1 works with null
120.2.2 works with empty string
120.2.3 works with undefined
120.2.4 works with NaN
120.2.5 works with extended ROWID
120.2.6 works with restricted ROWID
120.2.7 works with string 0
120.2.8 works with number 0
120.2.9 works with default bind type/dir - extended ROWID
120.2.10 works with default bind type/dir - null value
120.2.11 works with default bind type/dir - empty string
120.2.12 works with default bind type/dir - undefined
120.2.13 bind error: NJS-037
120.2.14 bind error: NJS-052
120.3 PROCEDURE BIND_IN, UPDATE
120.3.1 update null with UROWID
120.3.2 update empty string with UROWID
120.3.3 update undefined with UROWID
120.3.4 works with default bind type/dir
120.3.5 works with default bind type/dir - null value
120.3.6 works with default bind type/dir - empty string
120.3.7 works with default bind type/dir - undefined
121. urowidFunctionBindAsString1.js
121.1 FUNCTION BIND_IN/OUT as UROWID
121.1.1 works with null
121.1.2 works with empty string
121.1.3 works with undefined
121.1.4 works with NaN
121.1.5 works with extended ROWID
121.1.6 works with restricted ROWID
121.1.7 works with string 0
121.1.8 works with number 0
121.1.9 works with default bind type/dir - extended ROWID
121.1.10 works with default bind type/dir - null value
121.1.11 works with default bind type/dir - empty string
121.1.12 works with default bind type/dir - undefined
121.1.13 bind error: NJS-037
121.1.14 bind error: NJS-052
121.2 FUNCTION BIND_IN/OUT as string
121.2.1 works with null
121.2.2 works with empty string
121.2.3 works with undefined
121.2.4 works with NaN
121.2.5 works with extended ROWID
121.2.6 works with restricted ROWID
121.2.7 works with string 0
121.2.8 works with number 0
121.2.9 works with default bind type/dir - extended ROWID
121.2.10 works with default bind type/dir - null value
121.2.11 works with default bind type/dir - empty string
121.2.12 works with default bind type/dir - undefined
121.2.13 bind error: NJS-037
121.2.14 bind error: NJS-052
121.3 FUNCTION BIND_IN, UPDATE
121.3.1 update null with UROWID
121.3.2 update empty string with UROWID
121.3.3 update undefined with UROWID
121.3.4 works with default bind type/dir
121.3.5 works with default bind type/dir - null value
121.3.6 works with default bind type/dir - empty string
121.3.7 works with default bind type/dir - undefined
122. urowidFunctionBindAsString2.js
122.1 FUNCTION BIND_INOUT as UROWID
122.1.1 works with null
122.1.2 works with empty string
122.1.3 works with undefined
122.1.4 works with NaN
122.1.5 works with extended ROWID
122.1.6 works with restricted ROWID
122.1.7 works with string 0
122.1.8 works with number 0
122.1.9 works with default bind type/dir - extended ROWID
122.1.10 works with default bind type/dir - null value
122.1.11 works with default bind type/dir - empty string
122.1.12 works with default bind type/dir - undefined
122.1.13 bind error: NJS-037
122.1.14 bind error: NJS-052
122.2 FUNCTION BIND_INOUT as string
122.2.1 works with null
122.2.2 works with empty string
122.2.3 works with undefined
122.2.4 works with NaN
122.2.5 works with extended ROWID
122.2.6 works with restricted ROWID
122.2.7 works with string 0
122.2.8 works with number 0
122.2.9 works with default bind type/dir - extended ROWID
122.2.10 works with default bind type/dir - null value
122.2.11 works with default bind type/dir - empty string
122.2.12 works with default bind type/dir - undefined
122.2.13 bind error: NJS-037
122.2.14 bind error: NJS-052
122.3 FUNCTION BIND_INOUT, UPDATE
122.3.1 update null with UROWID
122.3.2 update empty string with UROWID
122.3.3 update undefined with UROWID
122.3.4 works with default bind type/dir
122.3.5 works with default bind type/dir - null value
122.3.6 works with default bind type/dir - empty string
122.3.7 works with default bind type/dir - undefined
123. dataTypeNclob.js
123.1 insert and stream out
123.1.1 works with data size 100
123.1.2 works with data size 3000
123.1.3 works with lob getData (offset, len)
123.2 insert and fetch as string with fetchInfo
123.2.1 works with data size 100
123.2.2 works with data size 3000
123.2.3 works with resultSet
123.3 insert and fetch as string with oracledb.fetchAsString
123.3.1 works with data size 100
123.3.2 works with data size 3000
123.3.2 works with resultSet
123.4 ref cursor
123.4.1 columns fetched from REF CURSORS can be mapped by fetchInfo settings
123.4.2 columns fetched from REF CURSORS can be mapped by oracledb.fetchAsString
123.5 stores null value correctly
123.5.1 works with Null, Empty string and Undefined
124. nclobDMLBindAsString.js
124.1 DML binding
124.1.1 bind in via INSERT
124.1.2 bind out via RETURNING INTO
124.1.3 bind in via UPDATE
124.1.3 bind in via WHERE
125. longDMLBind.js
125.1 INSERT and SELECT
125.1.1 works with data size 64K - 1
125.1.2 works with data size 64K
125.1.3 works with data size 64K + 1
125.1.4 works with data size 1MB + 1
125.2 UPDATE
125.2.1 works with data size 64K - 1
125.2.2 works with data size 64K
125.2.3 works with data size 64K + 1
125.2.4 works with data size 1MB + 1
125.3 RETURNING INTO
125.3.1 do not support in returning into
126. longrawDMLBind.js
126.1 INSERT and SELECT
126.1.1 works with data size 64K - 1
126.1.2 works with data size 64K
126.1.3 works with data size 64K + 1
126.1.4 works with data size 1MB + 1
126.1.5 works with data size 100
126.1.6 set maxSize to 2000
126.1.7 set maxSize to 4GB
126.2 UPDATE
126.2.1 works with data size 64K - 1
126.2.2 works with data size 64K
126.2.3 works with data size 64K + 1
126.2.4 works with data size 1MB + 1
126.2.5 set maxSize to 2000
126.2.6 set maxSize to 4GB
126.3 RETURNING INTO
126.3.1 do not support in returning into
127.blobStream.js
127.1 stream txt file into BLOB column
127.1.1 works with 64K txt file
127.1.2 works with 64K+1 txt file
127.1.3 works with 1MB+1 txt file
128.clobStream.js
128.1 stream txt file into CLOB column
128.1.1 works with 64KB txt file
128.1.2 works with 64KB+1 txt file
128.1.3 works with 1MB+1 txt file
129. longProcedureBind_inout.js
129.1 PLSQL PROCEDURE BIND IN OUT AS LONG
129.1.1 works with NULL
129.1.2 works with undefined
129.1.3 works with empty string
129.1.4 works with data size 4000
129.1.5 works with data size (32K - 1)
129.1.6 set maxSize to size (32K - 1)
129.1.7 set maxSize to size 1GB
129.2 PLSQL PROCEDURE BIND IN OUT AS STRING
129.2.1 works with NULL
129.2.2 works with undefined
129.2.3 works with empty string
129.2.4 works with data size 4000
129.2.5 works with data size (32K - 1)
129.2.6 set maxSize to size (32K - 1)
129.2.7 set maxSize to size 1GB
130. longProcedureBind_out.js
130.1 PLSQL PROCEDURE BIND OUT AS LONG
130.1.1 works with NULL
130.1.2 works with undefined
130.1.3 works with empty string
130.1.4 works with data size 4000
130.1.5 works with data size (32K - 1)
130.1.6 set maxSize to size (32K - 1)
130.1.7 set maxSize to size 1GB
130.2 PLSQL PROCEDURE BIND OUT AS STRING
130.2.1 works with NULL
130.2.2 works with undefined
130.2.3 works with empty string
130.2.4 works with data size 4000
130.2.5 works with data size (32K - 1)
130.2.6 set maxSize to size (32K - 1)
130.2.7 set maxSize to size 1GB
131. longProcedureBind_in.js
131.1 PLSQL PROCEDURE BIND IN AS LONG
131.1.1 works with NULL
131.1.2 works with undefined
131.1.3 works with empty string
131.1.4 works with data size 4000
131.1.5 works with data size (32K - 1)
131.1.6 set maxSize to size (32K - 1)
131.1.7 set maxSize to size 1GB
131.2 PLSQL PROCEDURE BIND IN AS STRING
131.2.1 works with NULL
131.2.2 works with undefined
131.2.3 works with empty string
131.2.4 works with data size 4000
131.2.5 works with data size (32K - 1)
131.2.6 set maxSize to size (32K - 1)
131.2.7 set maxSize to size 1GB
132. longrawProcedureBind_in.js
132.1 PLSQL PROCEDURE BIND IN AS LONG RAW
132.1.1 works with NULL
132.1.2 works with undefined
132.1.3 works with empty buffer
132.1.4 works with data size 2000
132.1.5 works with data size (32K - 1)
132.1.6 set maxSize to size (32K - 1)
132.1.7 set maxSize to size 1GB
132.2 PLSQL PROCEDURE BIND IN AS RAW
132.2.1 works with NULL
132.2.2 works with undefined
132.2.3 works with empty buffer
132.2.4 works with data size 2000
132.2.5 works with data size 32767
132.2.6 set maxSize to size (32K - 1)
132.2.7 set maxSize to size 1GB
133. longrawProcedureBind_inout.js
133.1 PLSQL PROCEDURE BIND IN OUT AS LONG RAW
133.1.1 works with NULL
133.1.2 works with undefined
133.1.3 works with empty buffer
133.1.4 works with data size 2000
133.1.5 works with data size 32760
133.1.6 set maxSize to size (32K - 1)
133.1.7 set maxSize to size 1GB
133.2 PLSQL PROCEDURE BIND IN OUT AS RAW
133.2.1 works with NULL
133.2.2 works with undefined
133.2.3 works with empty buffer
133.2.4 works with data size 2000
133.2.5 works with data size 32760
133.2.6 set maxSize to size (32K - 1)
133.2.7 set maxSize to size 1GB
134. longrawProcedureBind_out.js
134.1 PLSQL PROCEDURE BIND OUT AS LONG RAW
134.1.1 works with NULL
134.1.2 works with undefined
134.1.3 works with empty buffer
134.1.4 works with data size 2000
134.1.5 works with data size 32760
134.1.6 set maxSize to size (32K - 1)
134.1.7 set maxSize to size 1GB
134.2 PLSQL PROCEDURE BIND OUT AS RAW
134.2.1 works with NULL
134.2.2 works with undefined
134.2.3 works with empty buffer
134.2.4 works with data size 2000
134.2.5 works with data size 32760
134.2.6 set maxSize to size (32K - 1)
134.2.7 set maxSize to size 1GB
135. clobDMLReturningMultipleRowsAsStream.js
135.1 CLOB DML returning multiple rows as stream
135.1.1 CLOB DML returning multiple rows as stream
136. clobDMLReturningMultipleRowsAsString.js
136.1 CLOB DML returning multiple rows as String
136.1.1 CLOB DML returning multiple rows as String
137. blobDMLReturningMultipleRowsAsBuffer.js
137.1 BLOB DML returning multiple rows as buffer
137.1.1 BLOB DML returning multiple rows as buffer
138. blobDMLReturningMultipleRowsAsStream.js
138.1 BLOB DML returning multiple rows as stream
138.1.1 BLOB DML returning multiple rows as stream
139. fetchAsStringWithRefCursor.js
139.1 columns fetched from REF CURSORS can be mapped by fetchInfo settings
139.2 fetchAsString takes effect as well
140. jsObjectGetter1.js
140.1 Negative: overwrite the getter() function of bind in objects
140.1.1 ProcessBindsByName()
140.1.2 ProcessBindsByPos()
140.2 Negative (ProcessBind): OUT bind with properties altered
140.2.1
140.3 Negative: PL/SQL Indexed Table
140.3.1 bind an element being altered-JSON object
140.3.2 GetBindTypeAndSizeFromValue()
140.4 Negative: fetchInfo
140.4.1 changes getter() of fetchInfo itself
140.4.2 changes getter() of the value of fetchInfo object
140.5 Negative: Bool type
140.5.1 option - autoCommit
140.5.2 option - extendedMetaData
140.6 Negative: positive Int type
140.6.1 option - fetchArraySize
140.7 Negative: Pool object
140.7.1 String type - user
140.7.2 String type - password
140.7.3 String type - connectString
140.7.4 poolMin
140.7.5 poolMax
140.7.6 poolIncrement
140.7.7 poolTimeout
140.7.8 poolPingInterval
140.7.9 stmtCacheSize
140.8 Negative: Get Connection
140.8.1 String type: user
140.8.2 String type: password
140.8.3 String type: connectionString
140.8.4 Constant type: privilege
141. insertNaNToNumber.js
141.1 SQL, stores NaN
141.1.1 insert NaN to NUMBER column will report ORA-00984
141.1.2 binding in NaN by name into Oracle NUMBER column throws DPI-1055
141.1.3 binding in NaN by position into Oracle NUMBER column throws DPI-1055
141.2 PL/SQL, Function, bind NaN
141.2.1 binding in NaN by name into Oracle NUMBER column throws DPI-1055
141.2.2 binding in NaN by position into Oracle NUMBER column throws DPI-1055
141.2.3 binding inout NaN by name into Oracle NUMBER column throws DPI-1055
141.2.4 binding inout NaN by position into Oracle NUMBER column throws DPI-1055
141.3 PL/SQL, Procedure, bind NaN
141.3.1 binding in NaN by name into Oracle NUMBER column throws DPI-1055
141.3.2 binding in NaN by position into Oracle NUMBER column throws DPI-1055
141.3.3 binding inout NaN by name into Oracle NUMBER column throws DPI-1055
141.3.4 binding inout NaN by position into Oracle NUMBER column throws DPI-1055
141.4 PL/SQL, Procedure, bind NaN, indexed table
141.4.1 binding in NaN by name into Oracle NUMBER column throws DPI-1055
141.4.2 binding in NaN by position into Oracle NUMBER column throws DPI-1055
141.4.3 binding inout NaN by name into Oracle NUMBER column throws DPI-1055
141.4.4 binding inout NaN by position into Oracle NUMBER column throws DPI-1055
142. urowidFunctionBindAsString3.js
142.1 FUNCTION BIND_IN/OUT as UROWID
142.1.1 urowid length > 200
142.1.2 urowid length > 500
142.1.3 urowid length > 2000
142.2 FUNCTION BIND_IN/OUT as string
142.2.1 urowid length > 200
142.2.2 urowid length > 500
142.2.3 urowid length > 2000
142.3 FUNCTION BIND_IN, UPDATE
142.3.1 update with UROWID > 200
142.3.2 update with UROWID > 500
142.3.3 update with UROWID > 2000
143. urowidFunctionBindAsString4.js
143.1 FUNCTION BIND_INOUT as UROWID
143.1.1 urowid length > 200
143.1.2 urowid length > 500
143.1.3 urowid length > 2000
143.2 FUNCTION BIND_INOUT as string
143.2.1 urowid length > 200
143.2.2 urowid length > 500
143.2.3 urowid length > 2000
143.3 FUNCTION BIND_INOUT, UPDATE
143.3.1 update with UROWID > 200
143.3.2 update with UROWID > 500
143.3.3 update with UROWID > 2000
144. urowidProcedureBindAsString4.js
144.1 PROCEDURE BIND_IN as UROWID
144.1.1 urowid length > 500
144.1.2 urowid length > 1000
144.1.3 urowid length > 2000
144.2 PROCEDURE BIND_IN as string
144.2.1 urowid length > 500
144.2.2 urowid length > 1000
144.2.3 urowid length > 2000
144.3 PROCEDURE BIND_IN, UPDATE
144.3.1 update with urowid length > 500
144.3.2 update with urowid length > 1000
144.3.3 update with urowid length > 2000
145. urowidProcedureBindAsString5.js
145.1 PROCEDURE BIND_OUT as UROWID
145.1.1 urowid length > 500
145.1.2 urowid length > 1000
145.1.3 urowid length > 2000
145.2 PROCEDURE BIND_OUT as STRING
145.2.1 urowid length > 500
145.2.2 urowid length > 1000
145.2.3 urowid length > 2000
146. urowidProcedureBindAsString6.js
146.1 PROCEDURE BIND_INOUT as UROWID
146.1.1 urowid length > 500
146.1.2 urowid length > 1000
146.1.3 urowid length > 2000
146.2 PROCEDURE BIND_INOUT as string
146.2.1 urowid length > 500
146.2.2 urowid length > 1000
146.2.3 urowid length > 2000
146.3 PROCEDURE BIND_INOUT, UPDATE
146.3.1 update with urowid length > 500
146.3.2 update with urowid length > 1000
146.3.3 update with urowid length > 2000
147. prefetchRows.js
147.1 prefetchRows with simple execution
147.1.1 set oracledb.prefetchRows to be 0
147.1.2 Negative - negative value
147.1.3 Negative - NaN
147.1.4 Negative - undefined
147.1.5 Negative - null
147.1.6 Negative - random string
147.1.7 Negative - Boolean
147.1.8 execute() option, value of 0
147.1.9 Negative - negative value
147.1.10 Negative - NaN
147.1.11 execute() option, undefined, get overrided by global attribute
147.1.12 Negative - null
147.1.13 Negative - random string
147.1.14 Negative - Boolean
147.1.15 Query round-trips with no prefetch
147.1.16 Query round-trips with prefetch equal to row count
147.1.17 Query round-trips with prefetch > row count and fetchArraySize > row count
147.1.18 Query round-trips with prefetch > row count and fetchArraySize < row count
147.1.19 Query round-trips with prefetch < row count and fetchArraySize > total rows
147.1.20 Query round-trips with prefetch < row count and fetchArraySize = total rows
147.1.21 Query round-trips with prefetch < row count fetchArraySize < total rows
147.2 prefetchRows with resultSet
147.2.1 set oracledb.prefetchRows to be 0
147.2.2 execute() option, value of 0
147.2.3 Negative - negative value
147.2.4 Negative - NaN
147.2.5 execute() option, undefined, get overrided by global attribute
147.2.6 Negative - null
147.2.7 Negative - random string
147.2.8 Negative - Boolean
147.2.9 Query round-trips with no prefetch
147.2.10 Query round-trips with prefetch equal to row count
147.2.11 Query round-trips with prefetch larger than row count
147.2.12 Query round-trips with prefetch < row count, fetchArraySize < row count and getRows()
147.2.13 Query round-trips with prefetch < row count, fetchArraySize > row count and getRows(n < row count)
147.2.14 Query round-trips with prefetch < row count, fetchArraySize > row count and getRows(n > row count)
147.2.15 Query round-trips with prefetch < row count, fetchArraySize > row count and getRows()
147.3 prefetchRows with queryStream
147.3.1 set oracledb.prefetchRows to be 0
147.3.2 execute() option, value of 0
147.3.3 execute() option, undefined, get overrided by global attribute
147.3.4 Query round-trips with no prefetch
147.3.5 Query round-trips with prefetch equal to row count
147.3.6 Query round-trips with prefetch larger than row count
147.3.7 Query round-trips with prefetch < row count and fetchArraySize < row count
147.3.8 Query round-trips with prefetch < row count and fetchArraySize > row count
148. fetchArraySize1.js
148.1 oracledb.fetchArraySize
148.1.1 oracledb.fetchArraySize = 0
148.1.2 oracledb.fetchArraySize = 1
148.1.3 Negative: oracledb.fetchArraySize = undefined
148.1.4 Negative: oracledb.fetchArraySize = null
148.1.5 Negative: oracledb.fetchArraySize = random string
148.1.6 Negative: oracledb.fetchArraySize = Boolean
148.1.7 Negative: oracledb.fetchArraySize = NaN
148.1.8 oracledb.fetchArraySize = big number
148.2 execute() option fetchArraySize
148.2.1 fetchArraySize = 0
148.2.2 fetchArraySize = 1
148.2.3 fetchArraySize = undefined works as default value 100
148.2.4 Negative: fetchArraySize = null
148.2.5 Negative: fetchArraySize = random string
148.2.6 Negative: fetchArraySize = Boolean
148.2.7 Negative: fetchArraySize = NaN
148.2.8 fetchArraySize = big number
149. fetchArraySize2.js
149.1 basic fetch with different maxRows and oracledb.fetchArraySize
149.1.1 maxRows > table size > oracledb.fetchArraySize
149.1.2 maxRows > oracledb.fetchArraySize > table size
149.1.3 table size > maxRows > oracledb.fetchArraySize
149.1.4 table size > oracledb.fetchArraySize > maxRow
149.1.5 maxRows = oracledb.fetchArraySize < table size
149.1.6 maxRows = oracledb.fetchArraySize = table size
149.1.7 maxRows = oracledb.fetchArraySize > table size
149.1.8 maxRows = oracledb.fetchArraySize/10
149.1.9 maxRows = 10 * oracledb.fetchArraySize
149.1.10 maxRows > fetchArraySize, fetchArraySize = (table size)/10
149.1.11 maxRows = 0, fetchArraySize = table size
149.1.12 maxRows = 9999999, fetchArraySize = table size
149.1.13 maxRows = (table size - 1), fetchArraySize = table size
149.1.14 fetchArraySize = (table size - 1), maxRows = table size
149.2 REF CURSORS with different numRows and oracledb.fetchArraySize
149.2.1 numRows > table size > oracledb.fetchArraySize
149.2.2 numRows > oracledb.fetchArraySize > table size
149.2.3 table size > numRows > oracledb.fetchArraySize
149.2.4 table size > oracledb.fetchArraySize > maxRow
149.2.5 numRows = oracledb.fetchArraySize < table size
149.2.6 numRows = oracledb.fetchArraySize = table size
149.2.7 numRows = oracledb.fetchArraySize > table size
149.2.8 numRows = oracledb.fetchArraySize/10
149.2.9 numRows = 10 * oracledb.fetchArraySize
149.2.10 numRows > fetchArraySize, fetchArraySize = (table size)/10
149.2.11 numRows = (table size - 1), fetchArraySize = table size
149.2.12 fetchArraySize = (table size - 1), numRows = table size
149.3 queryStream() with different maxRows and oracledb.fetchArraySize
149.3.1 maxRows > table size > oracledb.fetchArraySize
149.3.2 maxRows > oracledb.fetchArraySize > table size
149.3.3 table size > maxRows > oracledb.fetchArraySize
149.3.4 table size > oracledb.fetchArraySize > maxRow
149.3.5 maxRows = oracledb.fetchArraySize < table size
149.3.6 maxRows = oracledb.fetchArraySize = table size
149.3.7 maxRows = oracledb.fetchArraySize > table size
149.3.8 maxRows = oracledb.fetchArraySize/10
149.3.9 maxRows = 10 * oracledb.fetchArraySize
149.3.10 maxRows > fetchArraySize, fetchArraySize = (table size)/10
149.3.11 maxRows = 0, fetchArraySize = table size
149.3.12 maxRows = 9999999, fetchArraySize = table size
149.3.13 maxRows = (table size - 1), fetchArraySize = table size
149.3.14 fetchArraySize = (table size - 1), maxRows = table size
150. fetchArraySize3.js
150.1 DML binding
150.1.1 oracledb.fetchArraySize = 1
150.1.2 oracledb.fetchArraySize = tableSize/20
150.1.3 oracledb.fetchArraySize = tableSize/10
150.1.4 oracledb.fetchArraySize = tableSize
150.1.5 oracledb.fetchArraySize = (table size - 1)
150.2 procedure binding
150.2.1 Bind OUT with oracledb.fetchArraySize = 1
150.2.2 Bind OUT with oracledb.fetchArraySize = tableSize/20
150.2.3 Bind OUT with oracledb.fetchArraySize = tableSize/10
150.2.4 Bind OUT with oracledb.fetchArraySize = tableSize
150.2.5 Bind OUT with oracledb.fetchArraySize = (table size - 1)
150.2.6 Bind IN OUT with oracledb.fetchArraySize = 1
150.2.7 Bind IN OUT with oracledb.fetchArraySize = tableSize/20
150.2.8 Bind IN OUT with oracledb.fetchArraySize = tableSize/10
150.2.9 Bind IN OUT with oracledb.fetchArraySize = tableSize
150.2.10 Bind IN OUT with oracledb.fetchArraySize = (table size - 1)
150.3 function binding
150.3.1 Bind OUT with oracledb.fetchArraySize = 1
150.3.2 Bind OUT with oracledb.fetchArraySize = tableSize/20
150.3.3 Bind OUT with oracledb.fetchArraySize = tableSize/10
150.3.4 Bind OUT with oracledb.fetchArraySize = tableSize
150.3.5 Bind OUT with oracledb.fetchArraySize = (table size - 1)
150.3.6 Bind IN OUT with oracledb.fetchArraySize = 1
150.3.7 Bind IN OUT with oracledb.fetchArraySize = tableSize/20
150.3.8 Bind IN OUT with oracledb.fetchArraySize = tableSize/10
150.3.9 Bind IN OUT with oracledb.fetchArraySize = tableSize
150.3.10 Bind IN OUT with oracledb.fetchArraySize = (table size - 1)
151. fetchArraySize4.js
151.1 getRows() of resultSet = true
151.1.1 numRows > table size > oracledb.fetchArraySize
151.1.2 numRows > oracledb.fetchArraySize > table size
151.1.3 table size > numRows > oracledb.fetchArraySize
151.1.4 table size > oracledb.fetchArraySize > maxRow
151.1.5 numRows = oracledb.fetchArraySize < table size
151.1.6 numRows = oracledb.fetchArraySize = table size
151.1.7 numRows = oracledb.fetchArraySize > table size
151.1.8 numRows = oracledb.fetchArraySize/10
151.1.9 numRows = 10 * oracledb.fetchArraySize
151.1.10 numRows > fetchArraySize, fetchArraySize = (table size)/10
151.1.11 numRows = (table size - 1), fetchArraySize = table size
151.1.12 fetchArraySize = (table size - 1), numRows = table size
151.2 getRow() of resultSet = true
151.2.1 oracledb.fetchArraySize = 1
151.2.2 oracledb.fetchArraySize = tableSize/50
151.2.3 oracledb.fetchArraySize = tableSize/20
151.2.4 oracledb.fetchArraySize = tableSize/10
151.2.5 oracledb.fetchArraySize = tableSize/5
151.2.6 oracledb.fetchArraySize = tableSize
151.2.7 oracledb.fetchArraySize = (table size - 1)
151.3 interleaved calls to getRow() and getRows()
151.3.1 oracledb.fetchArraySize = 1
151.3.2 oracledb.fetchArraySize = tableSize/50
151.3.3 oracledb.fetchArraySize = tableSize/20
151.3.4 oracledb.fetchArraySize = tableSize/10
151.3.5 oracledb.fetchArraySize = tableSize/5
151.3.6 oracledb.fetchArraySize = tableSize
151.3.6 oracledb.fetchArraySize = (table size - 1)
152. fetchArraySize5.js
152.1 basic fetch with different maxRows and fetchArraySize
152.1.1 maxRows > table size > fetchArraySize
152.1.2 maxRows > fetchArraySize > table size
152.1.3 table size > maxRows > fetchArraySize
152.1.4 table size > fetchArraySize > maxRow
152.1.5 maxRows = fetchArraySize < table size
152.1.6 maxRows = fetchArraySize = table size
152.1.7 maxRows = fetchArraySize > table size
152.1.8 maxRows = fetchArraySize/10
152.1.9 maxRows = 10 * fetchArraySize
152.1.10 maxRows > fetchArraySize, fetchArraySize = (table size)/10
152.1.11 maxRows = 0, fetchArraySize = table size
152.1.12 maxRows = (table size - 1), fetchArraySize = table size
152.1.13 fetchArraySize = (table size - 1), maxRows = table size
152.2 REF CURSORS with different numRows and fetchArraySize
152.2.1 numRows > table size > fetchArraySize
152.2.2 numRows > fetchArraySize > table size
152.2.3 table size > numRows > fetchArraySize
152.2.4 table size > fetchArraySize > maxRow
152.2.5 numRows = fetchArraySize < table size
152.2.6 numRows = fetchArraySize = table size
152.2.7 numRows = fetchArraySize > table size
152.2.8 numRows = fetchArraySize/10
152.2.9 numRows = 10 * fetchArraySize
152.2.10 numRows > fetchArraySize, fetchArraySize = (table size)/10
152.2.11 numRows = (table size - 1), fetchArraySize = table size
152.2.12 fetchArraySize = (table size - 1), numRows = table size
152.3 queryStream() with different maxRows and fetchArraySize
152.3.1 maxRows > table size > fetchArraySize
152.3.2 maxRows > fetchArraySize > table size
152.3.3 table size > maxRows > fetchArraySize
152.3.4 table size > fetchArraySize > maxRow
152.3.5 maxRows = fetchArraySize < table size
152.3.6 maxRows = fetchArraySize = table size
152.3.7 maxRows = fetchArraySize > table size
152.3.8 maxRows = fetchArraySize/10
152.3.9 maxRows = 10 * fetchArraySize
152.3.10 maxRows > fetchArraySize, fetchArraySize = (table size)/10
152.3.11 maxRows = 0, fetchArraySize = table size
152.3.12 maxRows = (table size - 1), fetchArraySize = table size
152.3.13 fetchArraySize = (table size - 1), maxRows = table size
153. fetchArraySize6.js
153.1 DML binding
153.1.1 fetchArraySize = 1
153.1.2 fetchArraySize = tableSize/20
153.1.3 fetchArraySize = tableSize/10
153.1.4 fetchArraySize = tableSize
153.1.5 fetchArraySize = (table size - 1)
153.2 procedure binding
153.2.1 Bind OUT with fetchArraySize = 1
153.2.2 Bind OUT with fetchArraySize = tableSize/20
153.2.3 Bind OUT with fetchArraySize = tableSize/10
153.2.4 Bind OUT with fetchArraySize = tableSize
153.2.5 Bind OUT with fetchArraySize = (table size - 1)
153.2.6 Bind IN OUT with fetchArraySize = 1
153.2.7 Bind IN OUT with fetchArraySize = tableSize/20
153.2.8 Bind IN OUT with fetchArraySize = tableSize/10
153.2.9 Bind IN OUT with fetchArraySize = tableSize
153.2.10 Bind IN OUT with fetchArraySize = (table size - 1)
153.3 function binding
153.3.1 Bind OUT with fetchArraySize = 1
153.3.2 Bind OUT with fetchArraySize = tableSize/20
153.3.3 Bind OUT with fetchArraySize = tableSize/10
153.3.4 Bind OUT with fetchArraySize = tableSize
153.3.5 Bind OUT with fetchArraySize = (table size - 1)
153.3.6 Bind IN OUT with fetchArraySize = 1
153.3.7 Bind IN OUT with fetchArraySize = tableSize/20
153.3.8 Bind IN OUT with fetchArraySize = tableSize/10
153.3.9 Bind IN OUT with fetchArraySize = tableSize
153.3.10 Bind IN OUT with fetchArraySize = (table size - 1)
154. fetchArraySize7.js
154.1 getRows() of resultSet = true
154.1.1 numRows > table size > fetchArraySize
154.1.2 numRows > fetchArraySize > table size
154.1.3 table size > numRows > fetchArraySize
154.1.4 table size > fetchArraySize > maxRow
154.1.5 numRows = fetchArraySize < table size
154.1.6 numRows = fetchArraySize = table size
154.1.7 numRows = fetchArraySize > table size
154.1.8 numRows = fetchArraySize/10
154.1.9 numRows = 10 * fetchArraySize
154.1.10 numRows > fetchArraySize, fetchArraySize = (table size)/10
154.1.11 numRows = (table size - 1), fetchArraySize = table size
154.1.12 fetchArraySize = (table size - 1), numRows = table size
154.2 getRow() of resultSet = true
154.2.1 fetchArraySize = 1
154.2.2 fetchArraySize = tableSize/50
154.2.3 fetchArraySize = tableSize/20
154.2.4 fetchArraySize = tableSize/10
154.2.5 fetchArraySize = tableSize/5
154.2.6 fetchArraySize = tableSize
154.2.7 fetchArraySize = (table size - 1)
154.3 interleaved calls to getRow() and getRows()
154.3.1 fetchArraySize = 1
154.3.2 fetchArraySize = tableSize/50
154.3.3 fetchArraySize = tableSize/20
154.3.4 fetchArraySize = tableSize/10
154.3.5 fetchArraySize = tableSize/5
154.3.6 fetchArraySize = tableSize
154.3.7 fetchArraySize = (tableSize - 1)
155. fetchArraySize8.js
155.1 Streaming clobs with different oracledb.fetchArraySize
155.1.1 maxRows > table size > oracledb.fetchArraySize
155.1.2 maxRows > oracledb.fetchArraySize > table size
155.1.3 table size > maxRows > oracledb.fetchArraySize
155.1.4 table size > oracledb.fetchArraySize > maxRow
155.1.5 maxRows = oracledb.fetchArraySize < table size
155.1.6 maxRows = oracledb.fetchArraySize = table size
155.1.7 maxRows = oracledb.fetchArraySize > table size
155.1.8 maxRows = oracledb.fetchArraySize/10
155.1.9 maxRows = 10 * oracledb.fetchArraySize
155.1.10 maxRows > fetchArraySize, fetchArraySize = (table size)/10
155.1.11 maxRows = 0, fetchArraySize = table size
155.1.12 maxRows = (table size - 1), fetchArraySize = table size
155.1.13 fetchArraySize = (table size - 1), maxRows = table size
155.2 Streaming clobs with different execute() option fetchArraySize
155.2.1 maxRows > table size > oracledb.fetchArraySize
155.2.2 maxRows > oracledb.fetchArraySize > table size
155.2.3 table size > maxRows > oracledb.fetchArraySize
155.2.4 table size > oracledb.fetchArraySize > maxRow
155.2.5 maxRows = oracledb.fetchArraySize < table size
155.2.6 maxRows = oracledb.fetchArraySize = table size
155.2.7 maxRows = oracledb.fetchArraySize > table size
155.2.8 maxRows = oracledb.fetchArraySize/10
155.2.9 maxRows = 10 * oracledb.fetchArraySize
155.2.10 maxRows > fetchArraySize, fetchArraySize = (table size)/10
155.2.11 maxRows = 0, fetchArraySize = table size
155.2.12 maxRows = (table size - 1), fetchArraySize = table size
155.2.13 fetchArraySize = (table size - 1), maxRows = table size
156. fetchArraySize9.js
156.1 Streaming blobs with different oracledb.fetchArraySize
156.1.1 maxRows > table size > oracledb.fetchArraySize
156.1.2 maxRows > oracledb.fetchArraySize > table size
156.1.3 table size > maxRows > oracledb.fetchArraySize
156.1.4 table size > oracledb.fetchArraySize > maxRow
156.1.5 maxRows = oracledb.fetchArraySize < table size
156.1.6 maxRows = oracledb.fetchArraySize = table size
156.1.7 maxRows = oracledb.fetchArraySize > table size
156.1.8 maxRows = oracledb.fetchArraySize/10
156.1.9 maxRows = 10 * oracledb.fetchArraySize
156.1.10 maxRows > fetchArraySize, fetchArraySize = (table size)/10
156.1.11 maxRows = 0, fetchArraySize = table size
156.1.12 maxRows = (table size - 1), fetchArraySize = table size
156.1.13 fetchArraySize = (table size - 1), maxRows = table size
156.2 Streaming blobs with different execute() option fetchArraySize
156.2.1 maxRows > table size > oracledb.fetchArraySize
156.2.2 maxRows > oracledb.fetchArraySize > table size
156.2.3 table size > maxRows > oracledb.fetchArraySize
156.2.4 table size > oracledb.fetchArraySize > maxRow
156.2.5 maxRows = oracledb.fetchArraySize < table size
156.2.6 maxRows = oracledb.fetchArraySize = table size
156.2.7 maxRows = oracledb.fetchArraySize > table size
156.2.8 maxRows = oracledb.fetchArraySize/10
156.2.9 maxRows = 10 * oracledb.fetchArraySize
156.2.10 maxRows > fetchArraySize, fetchArraySize = (table size)/10
156.2.11 maxRows = 0, fetchArraySize = table size
156.2.12 maxRows = (table size - 1), fetchArraySize = table size
156.2.13 fetchArraySize = (table size - 1), maxRows = table size
157. maxRows.js
157.1 Default maxRows == 0, which means unlimited
157.2 specify the value at execution
157.3 equals to the total amount of rows
157.4 cannot set it to be a negative number
157.5 sets it to be large value
157.6 shows 12c new way to limit the number of records fetched by queries
157.7 oracledb.maxRows > 0 && oracledb.maxRows < totalAmount
157.8 oracledb.maxRows > 0, execute() with maxRows=0
158. insertAll.js
158.1 original case from the issue
158.2 inserts into one table
158.3 inserts into multiple tables
159. end2endTracing.js
159.1 set the end-to-end tracing attribute - module
159.2 set the tracing attribute - action
159.3 set the tracing attribure - clientId
160. editionTest.js
160.1 Default. No edition. Direct connection.
160.2 Default. No edition. Pooled connection.
160.3 Direct connection. Set edition at getting connection.
160.4 Pooled connection. Set edition at creating pool.
160.5 Direct connection. Change session edition.
160.6 Pooled connection. Change session edition.
160.7 sets edition globally. Direct connection.
160.8 sets edition globally. Pooled connection.
160.9 Negative - sets nonexistent edition globally
160.10 Direct connection. Set nonexistent edition.
160.11 Pooled connection. Set nonexistent edition.
160.12 sets to ora$base with direct connection
160.13 resets to ora$base in direct connection
160.14 sets to ora$base with pooled connection
160.15 sets to ora$base globally
160.16 overrides the global setting. Direct connection
160.17 sets to empty string. Direct connection.
160.18 Negative - invalid type. Direct connection.
160.19 Negative - invalid type. Pooled connection.
160.20 sets ORA_EDITION. Direct connection.
160.21 sets ORA_EDITION. Pooled connection.
160.22 sets ORA_EDITION. Direct connection. Set edition at getting connection.
160.23 sets ORA_EDITION. Pooled connection. Set edition at creating pool.
160.24 Negative - Sets ORA_EDITION with nonexistent value. Direct connection.
160.25 Negative - Sets ORA_EDITION with nonexistent value. Pooled connection.
161. changePassword.js
161.1 basic case
161.2 pooled connection
161.3 DBA changes password
161.4 connects with an expired password
161.5 for DBA, the original password is ignored
161.6 Negative: basic case, wrong original password
161.7 Negative: basic case. invalid parameter
161.8 Negative: non-DBA tries to change the password
161.9 Negative: invalid type of 'newPassword'
161.10 sets "newPassword" to be an empty string. password unchanged
161.11 connects with password that is expiring soon
161.12 longer Password tests
161.12.1 basic case with password length 1024 Bytes
161.12.2 pooled connection
161.12.3 DBA changes longer password
161.12.4 connects with an expired password
161.12.5 for DBA, the original password is ignored
161.12.6 Negative: basic case, wrong original password
161.12.7 Negative: basic case. invalid parameter
161.12.8 Negative: basic case. invalid parameter with 1025 bytes
161.12.9 Negative: non-DBA tries to change the password
161.12.10 Negative: invalid type of 'newPassword'
161.12.11 sets "newPassword" to be an empty string. longer password unchanged
162. getStmtInfo.js
162.1 SELECT
162.2 SELECT with data bind
162.3 unknown statement
162.4 Negative - unknown statement, invalid SQL
162.5 UPDATE with data bind
162.6 UPDATE and verify changes do not happen
162.7 DELETE with data bind
162.8 DELETE and verify changes do not happen
162.9 DELETE with subquery
162.10 INSERT with data bind
162.11 INSERT and verify
162.12 Negative - insert nonexistent table
162.13 Negative - INSERT with invalid SQL
162.14 CREATE and verify the data does not get created
162.15 CREATE procedure
162.16 CREATE, DDL statements are not parsed, so syntax errors in them will not be ported.
162.17 DROP
162.18 ALTER
162.19 ALTER with data bind
162.20 ALTER, invalid statement
162.21 BEGIN
162.22 BEGIN with data bind
162.23 DECLARE
162.24 COMMIT
162.25 ROLLBACK
162.26 TRUNCATE
162.27 test various quoted bind names
162.28 PL/SQL block bindname following newline character
162.29 Ignore multiple single line comments having : in sql
162.30 Ignore multiple single and multi line comments having : in sql
162.31 Multiple single line comments with binds before the comment in sql
162.32 Multiple single line comments with binds after the comment in sql
162.33 Bind Variable before, inbetween and after comments in sql
162.34 ignore literals only during bind processing
162.35 Parse and Execute twice
162.36 Multiple line and Multiple Asterisks
163. executeMany1.js
163.1 inserts many rows with bind by name
163.2 inserts rows with bind by position
163.3 DML RETURNING that returns single value
163.4 DML RETURNING that returns multiple values
163.5 calls PL/SQL
163.6 shows dmlRowCounts
163.7 shows batchErrors behavior
163.8 Negative - batchErrors with non-DML statement
163.9 if batchErrors is disabled
163.10 Negative - dmlRowCounts with non-DML statement
163.11 numIterations - only OUT parameters
163.12 numIterations - No parameters
163.13 numIterations - DML RETURNING
163.14 Negative - set numIterations to be negative value
163.15 getting dmlrowcounts after executemany with dmlrowcounts=False
163.16 executemany() with an invalid row
163.17 calls PL/SQL, with round trip count check
164. soda1.js
164.1 getSodaDatabase() creates a sodaDatabase Object
164.2 createCollection() creates a collection
164.3 openCollection() opens an existing collection
164.4 getCollectionNames() gets an array of collection names
164.5 the operation status of collection.drop()
164.6 Negative: the operation status of collection.drop()
164.7 get one document
164.8 get multiple documents
164.9 create index
164.10 the examples/soda1.js case
164.11 Negative: create collection with invalid metaData value
165. soda2.js
165.1 create two sodaDatabase objects which point to the same instance
165.2 create two sodaDatabase objects from two connections
165.3 will open this collection when creating a collection with the existing name
165.4 Negative - createCollection() when collection name is empty string
165.5 connections from a pool concurrently insert documents into the same collection
167 soda3.js
167.1 get collection names
167.2 getCollectionNames() - limit option
167.3 getCollectionNames() - limit is "undefined"
167.4 getCollectionNames() - limit is 0
167.5 getCollectionNames() - limit is null
167.6 getCollectionNames() - limit is an empty string
167.7 getCollectionNames() - limit is a negative number
167.8 startsWith option - basic test
167.9 startsWith is case sensitive
167.10 startsWith is an empty string
167.11 startsWith is null
167.12 Negative - startsWith has invalid type, a Number
167.13 openCollection() basic case 1
167.14 openCollection() basic case 2
167.15 the returned value is null if the requested collection does not exist
167.16 the requested collection name is case sensitive
168. soda4.js
168.1 insertOneAndGet() fetches attributes without content
168.2 content is null
168.3 get mediaType
170. poolDrain.js
170.1 close pool with force flag, and prevent new connection
170.2 close pool without force flag (will give out an error ), and prevent new connections
170.3 pool.status OPEN and DRAINING
170.4 pool.status CLOSED
170.5 basic case - iterate open connections and close them
170.6 pool is closed after drainTime
170.7 closes pool if no connection
170.8 works with poolAlias
170.9 works with and without poolAlias
170.10 Negative - try to modify read-only property pool.status
170.11 drainTime = 0
170.12 drainTime = -3
170.13 drainTime = NaN
170.14 draining a pool will not block the other pool
170.15 draining a pool will not block another aliased pool
171. jsObjectGetter2.js
171.1 oracledb.fetchAsBuffer
171.2 oracledb.fetchAsString
171.3 data bind
172. executeMany2.js
172.1 Negative - incorrect parameters
172.2 Binding tests for invalid binding variables
172.2.1 Negative - Bind by position and by name cannot be mixed
172.2.2 Negative - Bind an array which values are undefined will throw ORA-01008
172.2.3 Negative - Bind an array starts with undefined will throw ORA-01008
172.2.4 Negative - Bind an array contains undefined will throw JS TypeError
172.2.5 Negative - Bind an empty array
172.2.6 Negative - Set number of ierations to 0
173. soda5.js
173.1 create index, basic case
173.2 query row not via indexSpec
173.3 Negative - invalid indexSpec, invalid index property
173.4 collection.drop(), basic case
173.5 drop multiple times, no error thrown
173.6 dropIndex(), basic case
173.7 dropping index does not impact query
173.8 The index is dropped regardless of the auto commit mode
173.9 Negative - dropIndex() no parameter
173.10 option object of dropIndex(), basic case
173.11 option object of dropIndex(), boolean value is false
173.12 getDataGuide(), basic case
174. soda6.js
174.1 filter() basic case
174.2 Negative - fiter(filterSpec) when filterSpec is null
174.3 filterSpec is OK to be an empty object
174.4 Key(), basic case
174.5 Key(), no matched key
174.6 Negative - Key(null)
174.7 Key(), invalid type
174.8 Keys(), basic case
174.9 Keys([]) empty array, it selects all documents
174.10 Negative - keys() no parameter
174.11 Negative - keys(null)
174.12 try to query documents with nonexistent keys
174.13 hint(), basic case
174.14 Negative - no parameter
174.15 Negative - invalid parameter type
175. soda7.js
175.1 count(), basic case
175.2 Negative - skip().count()
175.3 Negative - limit().count()
175.4 keys().count()
175.5 getCursor(), basic case
175.6 getCursor(), asyncIterator
175.7 skip().getCursor()
175.8 getCursor(), empty document matched
175.9 Negative - close document cursor two times
175.10 getDocuments(), basic case
175.11 getDocuments(), no documents matched
175.12 getOne(), basic case
175.13 getOne(), the filter matches multiple documents
175.14 remove(), basic case
175.15 remove(), remove zero document
175.16 remove(), remove multiple times
176. soda8.js
176.1 replaceOne(), basic case with document content
176.2 replaceOne(), basic case with document object
175.3 replaceOne(), no error is reported if the query criteria do not match any document
175.4 Negative - replaceOne(), the key() method must be used
175.5 replaceOneAndGet(), basic case with document content
175.6 replaceOneAndGet(), basic case with document object
175.7 replaceOneAndGet(), updatedDocument does not have document content
175.8 replaceOneAndGet(), no error is reported if it does not match any document
177. soda9.js
177.1 insertOne() with a document content
177.2 insertOne() with a document
177.3 insertOneAndGet() with a document content
177.4 insertOneAndGet() with a document
177.5 createDocument() followd by getContent() i.e. without being inserted
178. soda10.js
178.1 insertMany() with newSodaDocumentArray
178.2 insertMany() with newSodaDocumentContentArray
178.3 insertManyAndGet() with newDocumentArray
178.4 insertManyAndGet() with newDocumentContentArray
178.5 Negative - insertMany() with an empty array
178.6 Negative - insertManyAndGet() with an empty array
178.7 insertManyAndGet() with hint option
178.8 Negative - insertManyAndGet() with invalid options parameter
179. soda11.js
179.1 create collection with metadata
179.2 Negative - create collection with an invalid metadata
179.3 throw error when creating collection with the existing name and different metadata
179.4 customize the key value, String value
179.5 Negative - customize the key value, numeric value
179.6 customize the value of mediaType
179.7 Negative - customize mediaType, invalid type, numeric value
179.8 insert an empty document with customized metadata
180. externalProxyAuth.js
180.1 Non-Pool Connect
180.1.1 Non-Pool Connect: Basic Auth
180.1.2 Non-Pool Connect: External Auth
180.1.3 Non-Pool Connect: Basic Auth with proxy
180.1.4 Non-Pool Connect: External Auth with proxy
180.1.5 Non-Pool Connect: External Auth with proxy no brackets
180.1.6 Non-Pool Connect: External Auth with proxy and session user
180.2 Pooled Connect
180.2.1 Pooled Connect: Basic Auth
180.2.2 Pooled Connect: External Auth
180.2.3 Pooled Connect: Basic Auth with proxy when create pool
180.2.4 Pooled Connect: Basic Auth with proxy when acquire connection
180.2.5 Pooled Connect: Basic Auth with proxy when acquire connection
180.2.6 Pooled Connect: External Auth with proxy when create pool
180.2.7 Pooled Connect: External Auth with proxy no brackets when create pool
180.2.8 Pooled Connect: External Auth with proxy when acquire connection
180.2.9 Pooled Connect: External Auth with proxy no brackets when acquire connection
181. dataTypeXML.js
181.1 basic case, insert XML data and query back
181.2 query XML data as CLOB
181.3 another query as CLOB syntax
181.4 Negative - try to insert Null
184. sessionTag.js
184.1 Remote PL/SQL Callback
184.1.1 Acquire connection without tag
184.1.2 Acquire connection from pool without tag
184.1.3 Acquire connection from pool with empty string tag
184.1.4 Acquire connection from pool with valid tag
184.1.5 Acquire connection from pool with error in callback
184.1.6 Acquire connection from pool twice with same tag
184.1.7 Acquire connection from pool twice with different tag
184.1.8 Acquire connection from pool twice with different tag using matchAnyTag
184.1.9 Acquire connection from pool twice with different multi-tag using matchAnyTag
184.1.10 Acquire connection from pool twice with empty string tag using matchAnyTag
184.1.11 Acquire connection from pool twice with first connection's tag set to ""
184.1.12 Acquire connection from pool twice with different tag after setting first connection's tag
184.2 Local Javascript Callback
184.2.1 Acquire connection without tag
184.2.2 Acquire connection from pool without tag
184.2.3 Acquire connection from pool with empty string tag
184.2.4 Acquire connection from default pool with valid tag
184.2.5 Acquire connection from pool with valid tag
184.2.6 Acquire connection from pool with bad tag using async session callback
184.2.7 Acquire connection from pool with bad tag using sync session callback
184.2.8 Acquire connection from pool twice with same tag
184.2.9 Acquire connection from pool twice with different tag
184.2.10 Acquire connection from pool twice with different tag using matchAnyTag
184.2.11 Acquire connection from pool twice with different multi-tag using matchAnyTag
184.2.12 Acquire connection from pool twice with first connection's tag set to ""
184.2.13 Acquire connection from pool twice with different tag after setting first connection's tag
184.3 Change connection's tag before the connection is closed
184.3.1 Setting connection's tag to undefined triggers error NJS-004
184.3.2 Setting connection's tag to random object triggers error NJS-004
184.3.3 Closing randomly tagged connection triggers error ORA-24488
184.4 Dropping Session From Pool
184.4.1 Acquire connection from pool, close with tag
184.4.2 Acquire connection from pool, drop session
184.4.3 Acquire connection from pool, drop session with tag
184.4.4 Acquire connection from pool, wait for pool ping to call session fixup
184.4.5 Acquire connection from pool, wait for pool timeout to drop
184.4.6 Drop connection from pool with poolMin=0
184.4.7 Close connection from pool with {drop: false}
184.4.8 Close connection from pool with {drop: randomObject}
184.4.9 Close connection from pool with {drop: 0}
184.4.10 Close connection from pool with empty dict
184.4.11 Close connection from pool with {drop: random string}
185. runCQN.js
185.1 examples/cqn1.js
185.2 SQL Delete operation
185.3 Specify the notification only for INSERT operation
185.4 Negative - provide invalid SQL in CQN option
185.5 examples/cqn2.js
185.6 Get the registration ID "regId" for subscriptions
185.7 Negative - unsubscribe multiple times
185.8 Negative - unsubscribe nonexistent subscriptions
185.9 Negative - unsubscribe the invalid subscription
186. sodaInstanceof.js
186.1 instanceof checks for SODA classes
187. plsqlBindList.js
187.1 Positive Cases
187.1.1 Bind Object of List by position with type specified
187.1.2 Bind Object of List by name with type specified
187.1.3 Bind List by position without type specified
187.1.4 Bind List by name without type specified
187.1.5 Bind STRING List by name without type specified
187.1.6 Bind STRING List by position without type specified
187.2 Negative Cases
187.2.1 Bind Empty List by position with type specified
187.2.2 Bind Empty List by position without type specified
187.2.3 Bind Empty List by name with type specified
187.2.4 Bind Empty List by name without type specified
187.2.5 Bind NUMBER List by name with STRING as first element
187.2.6 Bind NUMBER List by position with STRING as second element
187.2.7 Bind STRING List by name while required type is NUMBER
187.2.8 Bind STRING List by position while required type is NUMBER
187.2.9 Bind NUMBER List by name while required type is STRING
187.2.10 Bind NUMBER List by position while required type is STRING
188. fetchRowidAsString.js
188.1 Fetch RAW by default should be oracledb.BUFFER type
188.2 Fetch RAW as string by defining fetchAsString
188.3 Fetch RAW as string by defining fetchInfo
188.4 Fetch number converted RAW as string
188.5 Fetch binary double converted RAW as string
188.6 Fetch binary float converted RAW as string
188.7 Fetch binary integer converted RAW as string
188.8 Insert a string of maximum lenght of RAW then fetch it as string
188.9 Insert a string exceeds maximum lenght of RAW
188.10 Insert null to RAW column then fetch it as string
189. sodaOverwrite.js
189.1 Allows overwriting of public methods on SodaDatabase instance
189.2 Allows overwriting of public methods on SodaDocument instance
189.3 Allows overwriting of public methods on SodaCollection instance
189.4 Allows overwriting of public methods on SodaOperation instance
189.5 Allows overwriting of public methods on SodaDocCursor instance
190. fetchBinaryTypesAsString.js
190.1 Fetch binary double
190.1.1 Fetch binary double should return JS number
190.1.2 Fetch binary double as string using fetchAsString
190.1.3 Fetch binary double as string using fetchInfo
190.1.4 Fetch other types as string do not affect binary double
190.1.5 Fetch binary double in multiple rows
190.2 Fetch binary float
190.2.1 Fetch binary float should return JS number
190.2.2 Fetch binary float as string using fetchAsString
190.2.3 Fetch binary float as string using fetchInfo
190.2.4 Fetch other types as string do not affect binary float
190.2.5 Fetch binary float in multiple rows
191. currentSchema.js
191.1 the value will be empty until it has been explicitly set
191.2 SQL alternative
191.3 Negative - can not set non-existent schema
192. implicitResults.js
192.1 implicit results with rows fetched
192.2 implicit Results with Result Sets
192.3 multiple options, outFormat is OBJECT
193. connProps.js
193.1 the default values of clientInfo and dbOp are null
193.2 clientInfo and dbOp are write-only properties
193.3 check the results of setter()
193.4 Negative - invalid values
193.5 Oracle Database service name associated with the connection
193.6 Oracle Database dbname associated with the connection
193.7 Oracle Database db domain associated with the connection
193.8 maximum cursors that can be opened on a connection
193.9 transactionInProgress = false on a connection for query
193.10 transactionInProgress = true on a connection
196. getDataOfLob.js
196.1 getData() works on CLOB
196.2 getData() returns CLOB as Strings
196.3 getData() on BLOB
196.4 getData() returns BLOB as Buffer
196.5 getData() on empty LOB returns null
196.6 works with temp LOB
197. dbObjectsNestedTable.js
197.1 Insert into table with Nested-table + getValues
197.2 Insert into table with Nested-table + getKeys
197.3 Insert into table with Nested-table + first * next
197.4 Insert into table with Nested-table + last + prev
197.5 Insert into table with Nested-table + getElement
197.6 Insert into table with Nested-table + hasElement
197.7 Insert into table with Nested-table NULL Value for object
197.8 Insert into table with Nested-table NULL Value for object
197.9 Insert into table and use deleteElement()
197.10 Insert into table and use setElement()
197.11 Insert into table and use trim()
200. dbObject1.js
200.1 insert an object with numeric/string values
200.2 insert an object with null numeric values
200.3 insert an object with null string values
200.4 insert an object with undefined numeric values
200.5 insert an object with undefined string values
200.6 insert an empty object - no attributes
200.7 insert data via binding by object
200.8 insert multiple rows using executeMany() with inferred data type
200.9 insert multiple rows using executeMany() with explicit data type
200.10 call procedure with 2 OUT binds of DbObject
201. dbObject2.js
201.1 insert an object with timestamp attributes
???.? directly insert timestamp data
201.2 insert null values for timestamp attribute
201.3 insert undefined values for timestamp attribute
201.4 insert an empty JSON for timestamp attribute
201.5 call procedure with 2 OUT binds of DbObject
202. dbObject3.js
202.1 insert an object with TSZ type attributes
202.2 insert null value for TSZ type attribute
202.3 insert undefined value for TSZ type attribute
202.4 insert an empty JSON
202.5 call procedure with 2 OUT binds of DbObject
203. dbObject4.js
203.1 insert an object with LTZ type attribute
203.2 insert null value for LTZ type attribute
203.3 insert undefined value for LTZ type attribute
203.4 insert an empty JSON
203.5 call procedure with 2 OUT binds of DbObject
204. dbObject5.js
204.1 insert an object with DATE type attribute
204.2 insert null value for DATE type attribute
204.3 insert undefined value for DATE type attribute
204.4 insert an empty JSON
204.5 call procedure with 2 OUT binds of DbObject
205. dbObject6.js
205.1 205.1 examples/selectgeometry.js
206. dbObject7.js
206.1 OUT bind DB Object
206.2 IN OUT bind DB Object
207. dbObject8.js
207.1 examples/selectobject.js
208. dbObject9.js
208.1 REF cursors that fetch object
208.2 Implicit results that fetch objects
208.3 Implicit results that fetch objects with Result Set
208.4 DML RETURNING INTO, explicit bind type
208.5 DML RETURNING INTO, implicit bind type
208.6 DML RETURNING INTO, bind by named values
208.7 DML RETURNING INTO and executeMany()
209. dbObject10.js
209.1 DB Objects which contain PL/SQL methods
209.2 By default, JavaScript Object toString() returns "[object type]"
209.3 The Object literal and JSON.stringify()
210. dbObject11.js
210.1 Attribute names with embedded "$", "#", "&" and spaces
211. dbObject12.js
211.1 examples/plsqlrecord.js
212. dbObject13.js
212.1 examples/plsqlvarrayrecord.js
213. dbObject14.js
213.1 examples/selectvarray.js
214. dbObject15.js
214.1 Getter() - access collection elements directly
214.2 Setter() - access collection element directly
214.3 Negative - delete the collection element directly
214.4 Negative - collection.deleteElement()
215. dbObject16.js
215.1 Collection of DATE, named Oracle type binds
216. dbObject17.js
216.1 VARRAY Collection. Object columns contain TS, TSZ and LTZ
217. aq1.js
217.1 examples/aqraw.js
217.2 examples/aqoptions.js
217.3 examples/aqmulti.js
217.4 one message in enqMany/deqMany
217.5 deqOne on empty queue
217.6 deqMany on empty queue
217.7 get delay property
217.8 get deliveryMode property
217.9 get exceptionQueue property
217.10 get numAttempts attribute
218. aq2.js
218.1 examples/aqobject.js
218.2 The read-only property "payloadTypeClass"
218.3 Negative - enqueue a raw JavaScript object directly
218.4 Negative - getQueue() without options on DB Object data
218.5 Enqueue a DB object as payload attribute
218.6 Enqueue a JavaScript object as payload attribute
218.7 Negative - Set payloadType as oracledb.DB_TYPE_OBJECT
218.8 enqMany() with DB object array
218.9 enqMany() with DB object array as payload
218.10 enqMany() with JavaScript objects as payload
219. aq3.js
219.1 The read-only property "name" of AqQueue Class
219.2 The read-only property "payloadType"
219.3 The read-only property "payloadTypeName"
219.4 Negative - Set "maxMessages" argument to be -5
219.5 Negative - Set "maxMessages" argument to be 0
219.6 Enqueue a Buffer
219.7 enqMany() mixes enqueuing string and buffer
219.8 Get correlation property in deqOne
219.9 Get correlation property in deqOne by specifying same correlation ID
219.10 Negative - Get correlation property in dequeue by changing correlation ID
219.11 get correlation property in deqMany
219.12 Get priority attribute in deqOne
219.13 Get state attribute in deqOne
219.14 Verify state change on expiration
220. examineOwnedProperties.js
220.1 Only examine "owned" properties on objects
221. connectionClass.js
221.1 set the property when using a connection pool
221.2 set the property when using a standalone connection
222. callTimeout.js
222.1 examples/calltimeout.js
222.2 the timeout value is greater than the operation time
222.3 callTimeout is 0
222.4 callTimeout is a negative value
222.5 callTimeout == NaN
222.6 callTimeout is a String
222.7 The callTimeout value applies not to the sum of all round-trips
222.8 The callTimeout value applies to each round-trip individually
222.9 get the callTimeout value
223. accessPropertiesOnClosedObjects.js
223.1 access properties of closed Connection object
223.2 access properties of closed Lob object
224. booleanBind.js
224.1 IN bind boolean value
224.2 Negative: IN bind boolean value for 12.1 DB
224.3 IN bind value "false"
224.4 IN bind value "null"
224.5 Negative - IN bind value type mismatch
224.6 OUT bind value "false"
224.7 OUT bind value "true"
224.8 IN bind array with boolean data
224.9 OUT bind array with boolean data
224.10 INOUT bind record with boolean data
224.11 OUT bind value "null"
226. dbType01.js
226.1 DB_TYPE_VARCHAR
226.2 DB_TYPE_CHAR
226.3 DB_TYPE_NVARCHAR
226.4 DB_TYPE_NCHAR
226.5 DB_TYPE_DATE
226.6 DB_TYPE_TIMESTAMP_LTZ
226.7 DB_TYPE_TIMESTAMP
226.8 DB_TYPE_TIMESTAMP_TZ
226.9 DB_TYPE_NUMBER
226.10 DB_TYPE_BINARY_FLOAT
226.11 DB_TYPE_BINARY_DOUBLE
226.12 Infinity, DB_TYPE_BINARY_FLOAT
226.13 Infinity, DB_TYPE_BINARY_DOUBLE
227. dbType02.js
227.1 DB_TYPE_VARCHAR
227.2 DB_TYPE_CHAR
227.3 DB_TYPE_NVARCHAR
227.4 DB_TYPE_NCHAR
227.5 DB_TYPE_DATE
227.6 DB_TYPE_TIMESTAMP_LTZ
228. lastRowid.js
228.1 examples
228.2 MERGE statement
228.3 Negative - not applicable to executeMany()
228.4 INSERT ALL statement
229. dbType03.js
229.1 IN binds binary_float and binary_double
229.2 OUT binds
229.3 IN bind Infinity number
229.4 OUT bind Infinity number
229.5 IN bind NaN
229.6 OUT bind NaN
230. soda12.js
230.1 example case
230.2 insertOne() and save()
230.3 Negative - client assigned keys are necessary
230.4 Negative - save without arguments
231. soda13.js
231.1 example case
231.2 truncate multiple times
231.3 Negative - invalid parameters
232. nestedCursor01.js
232.1 example/selectnestedcursor.js
233. nestedCursor02.js
233.1 example-nested-cursor.js
234. nestedCursor03.js
234.1 fetch zero row without resultSet option
234.2 fetch zero row with resultSet
234.3 fetch one row without resultSet option
234.4 fetch one row with resultSet option
234.5 fetch multiple rows directly
234.6 fetch multiple rows with resultSet
234.7 directly fetch multiple rows with each contains a nested cursor
234.8 fetch multiple rows with each contains a nested cursor in resultSet
234.9 maxRows option
234.10 maxRows option is ignored when resultSet option is true
235. nestedCursor04.js
235.1 fetch multiple nested cursors which each fetches zero row directly
235.2 fetch zero row with resultSet
235.3 fetch one row directly
235.4 fetch one row with resultSet
235.5 fetch multiple rows directly
235.6 fetch multiple rows with resultSet
235.7 query rows that contain null values and a nested cursor
235.8 maxRows option is respected at all levels of nested cursors
236. nestedCursor05.js
236.1 multi-level nested cursors
236.2 maxRows option is respected at all levels of nested cursors
236.3 fetchArraySize option is respected at all levels of nested cursors
236.4 extendedMetaData option is respected at all levels of nested cursors
236.5 combination of options maxRows, fetchArraySize, extendedMetaData
237. indexedTables01.js
237.1 check VARCHAR2 type support in PL/SQL index-by tables
237.2 DB_TYPE_NVARCHAR
237.3 DB_TYPE_CHAR
237.4 DB_TYPE_NCHAR
237.5 DB_TYPE_NUMBER
237.6 DB_TYPE_BINARY_FLOAT
237.7 DB_TYPE_BINARY_DOUBLE
237.8 DB_TYPE_TIMESTAMP
237.9 DB_TYPE_TIMESTAMP_LTZ
237.10 DB_TYPE_TIMESTAMP_TZ
237.11 DB_TYPE_RAW
238. soda14.js
238.1 the fetchArraySize() method works
238.2 fetchArraySize value is larger than the size of collection
238.3 Negative - call fetchArraySize() without parameter
238.4 fetchArraySize is 0
238.5 Negative - fetchArraySize is a negative value
239. plsqlBindCursorsIN.js
239.1 disable prefetchRows by setting it to be 0
239.2 prefetchRows is enabled with default value
239.3 cursor bind OUT then bind IN
239.4 implicit binding type
239.5 check REF CURSOR round-trips with no prefetching
239.6 check REF CURSOR round-trips with prefetching
239.7 check REF CURSOR bind with re-execute
240. errorOffset.js
240.1 checks the offset value of the error
240.2 database error
240.3 the offset of system error is 0
240.4 PL/SQL syntax error
241. dbType04.js
241.1 JSON type check
241.2 JSON type data binding
241.3 query number type from JSON column
241.4 query number type from JSON column
241.5 query array type
241.6 query JSON
241.7 query json array
241.8 query json object
241.9 binding Number gets converted to a JSON NUMBER value
241.10 binding String gets converted to JSON VARCHAR2 value
241.11 binding Date gets converted to JSON TIMESTAMP value
241.12 binding Buffer gets converted to JSON RAW value
241.13 binding Array gets converted to JSON Array value
241.14 binding simple dbobject with no attributes couldn't get converted to JSON Object value, returns an empty object
241.15 null
241.16 "undefined" gets converted to a JSON "NULL" value
241.17 true
241.18 false
241.19 empty string
241.20 empty json
241.21 NaN
241.22 Negative - implicitly binding JSON
241.23 Negative - type mismatch
241.24 Negative - type mismatch
241.25 Negative - query INTERVAL YEAR TO MONTH
241.26 Negative - query INTERVAL DAY TO SECOND
242. dbObject18.js
242.1 set oracledb.dbObjectAsPojo
242.1.1 oracledb.dbObjectAsPojo could be set without connection
242.1.2 oracledb.dbObjectAsPojo could be set without connection
242.1.3 set oracledb.dbObjectAsPojo to value of oracledb.autoCommit
242.1.4 set oracledb.dbObjectAsPojo to value of Boolean("false")
242.1.5 set oracledb.dbObjectAsPojo to value of JSON.parse('true')
242.1.6 set oracledb.dbObjectAsPojo to value of JSON.parse('false')
242.1.7 set oracledb.dbObjectAsPojo to value of Boolean(true)
242.1.8 set oracledb.dbObjectAsPojo to value of Boolean('false')
242.1.9 set oracledb.dbObjectAsPojo to value of Boolean(false)
242.1.10 negative: set oracledb.dbObjectAsPojo to invalid value: null
242.1.11 negative: set oracledb.dbObjectAsPojo to invalid value: 0
242.1.12 negative: set oracledb.dbObjectAsPojo to invalid value: number
242.1.13 negative: set oracledb.dbObjectAsPojo to invalid value: string true
242.1.14 negative: set oracledb.dbObjectAsPojo to invalid value: string false
242.1.15 negative: set oracledb.dbObjectAsPojo to invalid value: undefined
242.1.16 negative: set oracledb.dbObjectAsPojo to invalid value: NaN
242.1.17 negative: set oracledb.dbObjectAsPojo to invalid value: empty string
242.1.18 negative: set oracledb.dbObjectAsPojo to invalid value: empty json
242.1.19 negative: set oracledb.dbObjectAsPojo to invalid value: oracledb.DATE type
242.1.20 negative: set oracledb.dbObjectAsPojo to invalid value: array
242.2 set dbObjectAsPojo in bind option
242.2.1 dbObjectAsPojo returns database objects as plain old JavaScript objects
242.3 set dbObjectAsPojo in both oracledb.dbObjectAsPojo and bind option
242.3.1 set oracledb.dbObjectAsPojo = true and dbObjectAsPojo:false in bind option
242.3.2 connection must remain open when accessing a DbObject
242.4 set dbObjectAsPojo using oracledb.dbObjectAsPojo
242.4.1 dbObjectAsPojo returns database objects as plain old JavaScript objects
242.4.2 connection can be closed when accessing the plain old JavaScript objects
243. dbObject19.js
243.1 set global attribute oracledb.dbObjectAsPojo to true
243.1.1 OUT bind DB Object
243.1.2 IN OUT bind DB Object
243.2 set dbObjectAsPojo in BIND_OUT and BIND_INOUT options
243.2.1 OUT bind DB Object
243.2.2 IN OUT bind DB Object
243.3 set dbObjectAsPojo in bind variables doesn't work
243.3.1 OUT bind DB Object
244.dataTypeJson.js
244.1 testing JSON data in various lengths
244.1.1 SELECT query
244.1.2 resultSet stores JSON data correctly
244.1.3 works well with REF Cursor
244.1.4 columns fetched from REF CURSORS can be mapped by fetchInfo settings
244.1.5 Negative field name length > 255 bytes - Oracle 21c
244.2 stores null value correctly
244.2.1 testing Null, Empty string and Undefined
244.3 testing JSON with executeMany()
244.3.1 works with executeMany()
244.4 testing JSON with PL/SQL procedure BIND_IN and BIND_OUT
244.4.1 bind by name
244.4.2 bind by position
244.5 testing JSON with PL/SQL procedure BIND_INOUT
244.5.1 bind by name
244.5.2 bind by position
244.6 testing JSON with PL/SQL function BIND_IN and BIND_OUT
244.6.1 bind by name
244.6.2 bind by position
244.7 testing JSON with PL/SQL function BIND_INOUT
244.7.1 bind by name
244.7.2 bind by position
244.8 testing JSON with DML returning into
244.8.1 bind by name
244.8.2 bind by position
244.9 testing JSON with oracledb.fetchAsString and fetchInfo oracledb.STRING
244.9.1 works with oracledb.fetchAsString
244.9.2 could work with fetchInfo oracledb.STRING
244.10 testing JSON with Long Field Names > 255 bytes
244.10.1 single long JSON field name
244.10.2 multiple long JSON field names
244.10.3 multiple long and short JSON field names
244.10.4 negative case for out-of-bounds field length names
244.11 testing compressed JSON with relative offsets
244.11.1 fetch JSON with relative offsets
244.11.2 fetch JSON with relative offsets and shared fields and values
244.11.3 fetch JSON with relative offsets and shared fields, not values
244.12 Verify auto-generated SODA document key
244.12.1 Verify Json Id on select
244.13 Read JSON data on meta data change
244.13.1 table recreate - with oracledb.fetchAsString
244.13.2 table recreate - with fetchInfo oracledb.STRING
245. fetchLobAsStrBuf.js
245.1 CLOB,BLOB Insert
245.1.1 Insert and fetch CLOB,BLOB with EMPTY_CLOB and EMPTY_BLOB
245.1.2 Insert and fetch CLOB,BLOB with String and Buffer of length 32K
245.1.3 Insert and fetch CLOB,BLOB with String and Buffer of length (1MB + 1)
246. dupColNames1.js
246.1 Duplicate Column Names, query with simple execution
246.1.1 Two duplicate columns
246.1.2 Three duplicate columns
246.1.3 Duplicate column with conflicting alias name
246.1.4 Duplicate column with non-conflicting alias name
246.1.5 Negative not-case sensitive
246.1.6 Two Dupliate columns using nested cursor
246.1.7 Three Dupliate columns using nested cursor
246.1.8 Three Dupliate columns using nested cursor
246.1.9 Duplicate column with conflicting alias name using nested cursor
246.1.10 Duplicate column with non-conflicting alias name using nested cursor
246.1.11 Duplicate column with case sensitive alias name using nested cursor
246.1.12 Two Dupliate columns using REF cursor
246.1.13 Three duplicate columns using REF cursor
246.1.14 Duplicate column with Conflicting alias name using REF cursor
246.1.15 Duplicate column with non-conflicting alias name using REF cursor
246.1.16 Duplicate column with case sensitive alias name using REF cursor
246.1.17 Duplicate column with case sensitive alias name from dual
246.1.18 1000 duplicate columns
246.1.19 Negative not-case sensitive prop name
246.2 Duplicate Column Names, query with ResultSet
246.2.1 Two duplicate columns
246.2.2 Three duplicate columns
246.2.3 Duplicate column with conflicting alias name
246.2.4 Duplicate column with non-conflicting alias name
246.2.5 Negative not-case sensitive
246.2.6 Two Dupliate columns using nested cursor
246.2.7 Three Dupliate columns using nested cursor
246.2.8 Three Dupliate columns using nested cursor
246.2.9 Duplicate column with conflicting alias name using nested cursor
246.2.10 Duplicate column with non-conflicting alias name using nested cursor
246.2.11 Duplicate column with case sensitive alias name using nested cursor
246.2.12 Two Dupliate columns using REF cursor
246.2.13 Three duplicate columns using REF cursor
246.2.14 Duplicate column with Conflicting alias name using REF cursor
246.2.15 Duplicate column with non-conflicting alias name using REF cursor
246.2.16 Duplicate column with case sensitive alias name using REF cursor
246.2.17 Duplicate column with case sensitive alias name from dual
247. dupColNames2.js
247.1 Duplicate Column Names, query with stream
247.1.1 Two duplicate columns
247.1.2 Three duplicate columns
247.1.3 Duplicate column with conflicting alias name
247.1.4 Duplicate columns with non-conflicting alias name
247.1.5 Negative not-case sensitive
247.1.6 Two Dupliate columns using nested cursor
247.1.7 Three Dupliate columns using nested cursor
247.1.8 Three Dupliate columns using nested cursor
247.1.9 Duplicate column with conflicting alias name using nested cursor
247.1.10 Duplicate column with non-conflicting alias name using nested cursor
247.1.11 Duplicate column with case sensitive alias name using nested cursor
247.1.12 Two Dupliate columns using REF cursor
247.1.13 Three duplicate columns using REF cursor
247.1.14 Duplicate column with Conflicting alias name using REF cursor
247.1.15 Duplicate column with non-conflicting alias name using REF cursor
247.1.16 Duplicate column with case sensitive alias name using REF cursor
247.1.17 Duplicate column with case sensitive alias name from dual
248. userName.js
248.1 test with different size of username
248.1.1 test with username size 30
248.1.2 test with username size 100
248.1.3 test with username size 128
248.1.4 test with username size 1000
248.1.5 negative test: username = null
248.1.6 negative test: username = "null"
248.1.7 negative test: username = undefined
248.1.8 negative test: username = "undefined"
248.1.9 negative test: username = empty string
248.1.10 negative test: username = NaN
248.1.11 negative test: username in array
248.2 test with different size of user
248.2.1 test with user size 30
248.2.2 test with user size 100
248.2.3 test with user size 128
248.2.4 test with username size 1000
248.2.5 negative test: user = null
248.2.6 negative test: username = "null"
248.2.7 negative test: username = undefined
248.2.8 negative test: username = "undefined"
248.2.9 negative test: username = empty string
248.2.10 negative test: username = NaN
248.2.11 negative test: username in array
249. rsGetAllRows1.js
249.1 ResultSet & getRows()
249.1.1 ResultSet + getRows()
249.1.2 ResultSet + getRows(0)
249.1.3 ResultSet + getRows(125) + getRows()
249.1.4 ResultSet + getRows(125) + getRows(0)
249.1.5 ResultSet + getRow() + getRows()
249.1.6 ResultSet + getRow() + getRows(0)
249.2 REFCURSOR & getRows()
249.2.1 RefCursor getRows()
249.2.2 RefCursor + getRows(0)
249.2.3 RefCursor + getRows(125) & getRows()
249.2.4 RefCursor + getRows(125) & getRows(0)
249.2.5 RefCursor + getRow() & getRows()
249.2.6 RefCursor + getRow() & getRows(0)
249.3 ResultSet & getRows() with fetchArraySize
249.3.1 ResultSet + getRows() with fetchArraySize = total rows
249.3.2 ResultSet + getRows(0) with fetchArraySize = total rows
249.3.3 ResultSet + getRows() with fetchArraySize > total rows
249.3.4 ResultSet + getRows(0) with fetchArraySize > total rows
249.3.5 ResultSet + getRows() with fetchArraySize < total rows
249.3.6 ResultSet + getRows(0) with fetchArraySize < total rows
249.3.7 ResultSet + getRows(125) + getRows() with fetchArraySize > remaining rows
249.3.8 ResultSet + getRows(125) + getRows(0) with fetchArraySize > remaining rows
249.3.9 ResultSet + getRows(125) + getRows() with fetchArraySize < remaining rows
249.3.10 ResultSet + getRows(125) + getRows(0) with fetchArraySize < remaining rows
249.3.11 ResultSet + getRow() + getRows() with fetchArraySize > remaining rows
249.3.12 ResultSet + getRow() + getRows(0) with fetchArraySize > remaining rows
249.3.13 ResultSet + getRow() + getRows() with fetchArraySize < remaining rows
249.3.14 ResultSet + getRow() + getRows(0) with fetchArraySize < remaining rows
249.4 REFCURSOR & getRows() with fetchArraySize
249.4.1 RefCursor getRows() with fetchArraySize > total rows
249.4.2 RefCursor + getRows(0) with fetchArraySize > total rows
249.4.3 RefCursor getRows() with fetchArraySize < total rows
249.4.4 RefCursor + getRows(0) with fetchArraySize < total rows
249.4.5 RefCursor + getRows(125) & getRows() with fetchArraySize < remaining rows
249.4.6 RefCursor + getRows(125) & getRows(0) with fetchArraySize < remaining rows
249.4.7 RefCursor + getRow() & getRows() with fetchArraySize < remaining rows
249.4.8 RefCursor + getRow() & getRows(0) with fetchArraySize < remaining rows
250. rsGetAllRows2.js
250.1 Nested Cursor + getRows() OBJECT outformat
250.2 Nested Cursor + getRows(0) rows ARRAY outformat
250.3 Nested Cursor + getRows(n) + getRows() OBJECT outformat
250.4 Nested Cursor + getRow() + getRows(0) rows ARRAY outformat
250.5 Nested Cursor + getRows(n) + getRows(0) with fetchArraySize < remaining rows inside nested cursor
250.6 Nested Cursor + getRows(n) + getRow() + getRows() with fetchArraySize = 1
251. fetchNClobAsString.js
251.1 NCLOB type in fetchAsString
251.2 NCLOB type in fetchAsString and fetch NCLOB data
251.3 CLOB type in fetchAsString and fetch NCLOB data
251.4 NCLOB type in fetchAsString and fetch CLOB data
251.5 CLOB type in fetchAsString and fetch CLOB data
251.6 CLOB & NCLOB type in fetchAs String and fetch CLOB & NCLOB
252. sodaMetaDataCache.js
252.1 sodaMetaDataCache set to TRUE
252.2 sodaMetaDataCache set to FALSE
252.3 sodaMetaDataCache not specified
252.4 sodaMetaDataCache from closed pool
253. jsonBind1.js
253.1 Map javascript object directly into JSON
253.1.1 Number, String type
253.1.2 Boolean and null value
253.1.3 Array type
253.1.4 Object type
253.1.5 Using JSON_VALUE to extract a value from a JSON column
253.1.6 Using dot-notation to extract a value from a JSON column
253.1.7 Using JSON_OBJECT to extract relational data as JSON
253.1.8 Number, String type with BIND_INOUT
253.1.9 Boolean and null value with BIND_INOUT
253.1.10 Array type with BIND_INOUT
253.1.11 Object type with BIND_INOUT
253.2 Map javascript object using SQL syntax into JSON
253.2.1 Number type
253.2.2 String type
253.2.3 TIMESTAMP type
253.2.4 RAW type
253.2.5 Array type
253.2.6 Object type
253.2.7 CLOB type
253.2.8 BLOB type
253.2.9 DATE type
253.2.10 INTERVAL YEAR TO MONTH type
253.2.11 INTERVAL DAY TO SECOND type
253.2.12 BINARY_DOUBLE type
253.2.13 BINARY_FLOAT type
253.2.14 NULL value
254. jsonBind2.js
254.1 Map javascript object into BLOB
254.1.1 Number, String type
254.1.2 Boolean and null value
254.1.3 Array type
254.1.4 Object type
254.1.5 Using JSON_VALUE to extract a value from a BLOB column
254.1.6 Using dot-notation to extract a value from a BLOB column
254.2 Map javascript object into VARCHAR2
254.2.1 Number, String type
254.2.2 Boolean and null value
254.2.3 Array type
254.2.4 Object type
254.2.5 Using JSON_VALUE to extract a value from a VARCHAR2 column
254.2.6 Using dot-notation to extract a value from a VARCHAR2 column
254.3 Map javascript object into CLOB
254.3.1 Number, String type
254.3.2 Boolean and null value
254.3.3 Array type
254.3.4 Object type
254.3.5 Using JSON_VALUE to extract a value from a CLOB column
254.3.6 Using dot-notation to extract a value from a CLOB column
255. poolReconfigure.js
255.1 poolReconfigure - poolMin/poolMax/poolIncrement properties
255.1.1 Change poolMin - increase
255.1.2 Change poolMin - decrease
255.1.3 Change poolMax - increase
255.1.4 Change poolMax - decrease
255.1.5 Change poolIncrement - increase
255.1.6 Change poolIncrement - decrease
255.1.7 increase poolMin & poolMax
255.1.8 increase poolMin & poolIncrement
255.1.9 increase poolMax & poolIncrement
255.1.10 increase poolMin/poolMax/poolIncrement
255.1.11 Change enableStatistics to true
255.1.12 Change enableStatistics to false
255.1.13 Decreasing poolMax when all connection are in use
255.1.14 reconfigure poolMin/poolMax/poolIncrement multiple times
255.1.15 reconfigure poolMin/poolMax/poolIncrement multiple times
255.1.16 Connection queuing after decreasing poolMax
255.1.17 Connection queuing after increasing poolMax
255.2 poolReconfigure - other properties
255.2.1 change poolPingInterval
255.2.2 change poolTimeout
255.2.3 change maxPerShard
255.2.4 change stmtCacheSize
255.2.5 change resetStatistics with enableStatistics
255.2.6 change resetStatistics
255.2.7 getStatistics
255.2.8 getStatistics - noneditable properties
255.3 poolReconfigure JS layer properties
255.3.1 change queueMax
255.3.2 change queueTimeout
255.3.3 change maxSessionsPerShard
255.3.4 sodaMetaDataCache set to true
255.3.5 sodaMetaDataCache set to false
255.4 Pool properties NOT dynamically configurable, they will be ignored
255.4.1 connectionsInUse
255.4.2 connectionsOpen
255.4.3 connectString
255.4.4 connectionString
255.4.5 edition
255.4.6 events
255.4.7 homogeneous
255.4.8 externalAuth
255.4.9 password
255.4.10 poolAlias
255.4.11 status
255.4.12 username
255.4.13 user
255.4.14 _enableStats
255.5 Negative cases
255.5.1 passing empty config to pool.reconfigure
255.5.2 passing invalid poolMin to pool.reconfigure
255.5.3 passing invalid poolMax to pool.reconfigure
255.5.4 passing invalid poolIncrement to pool.reconfigure
255.5.5 passing invalid enableStatistics to pool.reconfigure
255.5.6 passing invalid poolPingInterval to pool.reconfigure
255.5.7 passing invalid poolTimeout to pool.reconfigure
255.5.8 passing invalid poolMaxPerShard to pool.reconfigure
255.5.9 passing invalid queueMax to pool.reconfigure
255.5.10 passing invalid queueTimeout to pool.reconfigure
255.5.11 passing invalid stmtCacheSize to pool.reconfigure
255.5.12 calling pool.reconfigure multiple times with empty config
255.5.13 calling pool.reconfigure multiple times
255.5.14 reconfigure closed pool
255.5.15 get statistics of a closed pool
255.6 Pool statistics
255.6.1 get pool statistics by setting _enableStats
255.6.2 get pool statistics by setting _enableStats
255.6.3 set enableStatistics to true, _enableStats will be ignored
255.6.4 set enableStatistics to false, _enableStats will be used
255.6.5 set multiple enableStatistics
255.6.6 set multiple _enableStats
255.6.7 get pool statistics by setting enableStatistics
255.6.8 get pool statistics by setting enableStatistics
255.6.9 get pool statistics by setting enableStatistics and _enableStats
255.6.10 logStatistics without enableStatistics
256. executeQueue.js
256.1 Connection.execute()
256.1.1 errorOnConcurrentExecute set to false
256.1.2 errorOnConcurrentExecute set to true
256.1.3 break() not constrained by queue
256.2 SodaDatabase.createCollection()
256.2.1 errorOnConcurrentExecute set to false
256.2.2 errorOnConcurrentExecute set to true
256.3 SodaCollection.insertOne()
256.3.1 errorOnConcurrentExecute set to false
256.3.2 errorOnConcurrentExecute set to true
256.4 SodaOperation.count()
256.4.1 errorOnConcurrentExecute set to false
256.4.2 errorOnConcurrentExecute set to true
256.5 SodaDocCursor.getNext()
256.5.1 errorOnConcurrentExecute set to false
256.5.2 errorOnConcurrentExecute set to true
256.6 Execute queue length
256.6.1 errorOnConcurrentExecute set to false
256.6.2 errorOnConcurrentExecute set to true
256.7 Lob.getData()
256.7.1 errorOnConcurrentExecute set to false
256.7.2 errorOnConcurrentExecute set to true
257. sodahint.js
257.1 insertOneAndGet() with hint option
257.2 Negative - insertOneAndGet() with invalid options parameter
257.3 saveAndGet() with hint option
257.4 Negative - saveAndGet() with invalid options parameter
258. keepInStmtCache.js
258.1 tests for keepInStmtCache & execute
258.1.1 keepInStmtCache & execute default
258.1.2 keepInStmtCache & execute include
258.1.3 keepInStmtCache & execute exclude
258.2 tests using keepInStmtCache & resultSet
257.2.1 keepInStmtCache & resultSet default
258.2.2 keepInStmtCache & resultSet include
258.2.3 keepInStmtCache & resultSet exclude
258.3 tests using keepInStmtCache & queryStream
258.3.1 keepInStmtCache & queryStream default
258.3.2 keepInStmtCache & queryStream include
258.3.3 keepInStmtCache & queryStream exclude
259. tpc.js
259.1 TPC constants
259.1.1 tpc constant TPC_BEGIN_JOIN
259.1.2 tpc constant TPC_BEGIN_NEW
259.1.3 tpc constant TPC_RESUME
259.1.4 tpc constant TPC_PROMOTE
259.1.5 tpc constant TPC_END_NORMAL
259.1.6 tpc constant TPC_END_SUSPEND
259.2 TPC Functions
259.2.1 test tpcBegin, tpcPrepare, tpcRollback
259.2.2 test tpcBegin, tpcPrepare, tpcCommit
259.2.3 test multiple global transactions on same connection
259.2.4 test tpcPrepare with no xid
259.2.5 negative - missing formatId in XID
259.2.6 negative missing globalTxnId in XID
259.2.7 negative missing branchQualifier in XID
259.2.8 negative tpcForget after tpcPrepare
259.2.9 negative tpcForget without tpcPrepare
259.3 TPC Functions with no default values
259.3.1 test tpcBegin, tpcPrepare, tpcRollback
259.3.2 test tpcBegin, tpcPrepare, tpcCommit
259.3.3 test multiple global transactions on same connection
259.3.4 test tpcPrepare with no xid
259.3.5 negative - missing formatId in XID
259.3.6 negative missing globalTxnId in XID
259.3.7 negative missing branchQualifier in XID
259.4 TPC Properties
259.4.1 set and get externalName
259.4.2 set and get internalName
259.4.3 set and query ecid
259.5 TPC Functions using Buffer type
259.5.1 test tpcBegin, tpcPrepare, tpcRollback using Buffer type
259.5.2 test tpcBegin, tpcPrepare, tpcRollback using Buffer type 2
259.6 TPC Functions with invalid # of parameters
259.6.1 tpcBegin invalid number of arguments
259.6.2 tpcCommit invalid number of arguments
259.6.3 tpcEnd invalid number of arguments
259.6.4 tpcForget invalid number of arguments
259.6.5 tpcPrepare invalid number of args
259.6.6 tpcRecover invalid number of args
259.6.7 tpcRollback invalid number of args
260. tpcResume.js
260.1 TPC suspend and resume
261. connHealthy.js
261.1 connection health on stand alone connections
261.1.1 connection health on good connection
261.1.2 connection health on closed connection
262. dbObjectOutBind.js
262.1 call procedure with 2 OUT binds of DbObject
263. asyncStack.js
263.1 stack on error in getConnection
263.2 stack on error in createPool
263.3 stack on error in execute
264. methodName.js
264.1 check for methodName getConnection
267. aq4.js
267.1 empty array or no recipients
267.2 single element in array
267.3 Negative - numbers as recipients
267.4 Negative - number, string, date as recipients
267.5 Negative - null value for recipient
267.6 Negative - undefined value for recipeint
267.7 Negative - dequeue non-existent name
267.8 empty recipient list with enqMany
267.9 recipient list with enqMany
267.10 recipient list with enqMany non-existent in dequeue
267.11 recipient list with enqMany invalid datatype in dequeue
268. procAndFuncs.js
268.1 calling stored procedures
268.1.1 executing a stored procedure
268.1.2 executing a stored procedure with all args keyword args
268.1.3 executing a stored procedure with last arg as keyword arg
268.2 calling stored procedures no args
268.2.1 executing a stored procedure with last arg as keyword arg
268.3 calling functions
268.3.1 executing a stored function
268.3.2 executing a stored function with extra args
268.3.3 executing a stored function with wrong function name
268.3.4 executing a stored function with wrong args
268.3.5 executing a stored function with no args
268.3.6 executing a stored function with only one args
268.4 calling functions without any arguments
268.4.1 executing a stored function without any argument
269. PoolTimeout.js
269.1 poolTimeout as 0, no idle connection removals
269.2 poolTimeout as 1sec, idle connection will get removed
269.3 poolTimeout as 1sec and min connection defined, idle connection will be removed
269.4 check default poolTimeout as 60sec
270. binding_buffer_string.js
270.1 BLOB, PLSQL, BIND_IN
270.1.1 works with buffer
271. fetchTypeHandler.js
271.1 Property value check
271.2 invalid syntax for "type" should result in error
271.3 value attribute "type" must be a valid database type
271.4 attribute "converter" must be a function
271.5 FetchTypeHandler return value attribute "converter" must be a function
271.6 fetchTypeHandler return value must be an object
271.7 Not supported database type conversion
271.8 Fetch number as string
271.9 Fetch DATE column values as STRING by Column name
271.10 fetchTypeHandler will take precedence over fetchInfo
271.11 fetchInfo will take precedence over fetchTypeHandler when "undefined" returned
271.12 Fetch DATE, NUMBER column values STRING by Column name
271.13 Fetch DATE, NUMBER column as STRING by type and override at execute time
271.14 Fetch DATE, NUMBER column as STRING by type with converter
271.15 Negative cases
271.16 Padding numeric values with leading zeroes
271.17 converting dates to use the requested locale specific format
271.18 getting JSON data
271.19 large numbers with fetchTypeHandler
271.20 setting a private property in the metadata
271.21 fetchTypeHandler for nulls with converter function
271.22 converter function to convert column val to string
271.23 converter function with multiple columns
272. jsonDualityViews1.js
272.1 JSON Relational Duality View
272.1.1 fetch results
272.1.2 update query
272.1.3 insert query
272.1.4 delete query
272.1.5 dept view
272.1.6 insert query
272.1.7 update query
272.1.8 delete query
272.1.9 insert query
272.1.10 update query
272.2 run with DV using GraphQL
272.2.1 insert query
272.2.2 update query
272.2.3 insert query
272.2.4 delete query
272.2.5 Primary key to FOREIGN key
272.2.6 Insert query
272.2.7 Update query
272.2.8 Delete query
272.3 DDL tests with GRAPHQL for JSON Duality Views
272.3.1 Insert query
272.3.2 View Name as graphql
272.3.3 Create view with @ directive
272.3.4 Create view using @unnest case 1
272.3.5 Create view using @unnest case 2
272.3.6 Create view Primary key to Foreign key
272.3.7 Create view Foreign key to Primary key
272.3.8 Create view with View Name as Mixed Case and Special Case
272.3.8.1 single quotes for key names are not supported
272.3.8.2 single quotes for key names are not supported
272.3.8.3 Create view with View Name as Special Case
272.3.8.3 case 3
272.3.8.4 single quotes for key names are not supported
272.3.9 View Name with Maximum possible string and maximum possible string +1 (128bytes)
272.3.9.1 case 1
272.3.9.2 case 2
272.3.10 View creation inside a PLSQL Block
272.3.10.1 Query with DBMS_SQL
272.3.10.2 Query with EXECUTE IMMEDIATE
272.3.11 Create view without privilege
272.3.11.1 Query with test1 user
272.3.11.2 Query with test2 user
273. jsonDualityViews2.js
273.1 without base table being available (use force option at view creation)
273.2 Base table name with various sizes (128)
273.3 Perform dbms_metadata.get_ddl() and verify tags were properly added to columns and tables
273.4 Base table name maxSize+1
273.5 Create a column name as NOINSERT and add NOINSERT tag to that column
273.6 Specify DELETE, NODELETE both, BUG number : 34657745
273.7 Repetitive tags
273.8 Verify view creation on different types of tables
273.8.1 View with Heap
273.8.2 View with IOT
273.8.3 View with Partitioned Table
273.8.4 View with cluster
273.8.5 View with GTT
273.9 Table and Views
273.9.1 Base table in one schema and View in another schema
273.9.2 Base table as schema_name__table_name
273.9.3 Base table with Unique Index on it
273.9.4 Base table with COMPOSITE Index on it
273.9.5 Base table with Function based index on it
273.9.6 Base table with bitmap index index on it
273.10 With Redaction on base tables
273.10.1 redaction enabled on a base table
274. jsonDualityViews3.js
274.1 Define Columns of View with WITH READ WRITE or WITH READ ONLY annotations
274.2 Create View on Virtual columns, UNUSED columns
274.3 Have columns of all scalar types, including FLOAT, TIMESTAMP, TIMESTAMP WITH TIME ZONE
274.4 Create a view with column as schema_name.table_name.column_name
274.5 Select over Invisible columns
274.6 Add is (Ex: "deptno" IS d.department_id)
274.7 Add VISIBLE | INVISIBLE options to define columns in view
274.8 Create view on NULL columns empty columns
275. jsonDualityViews4.js
275.1 Test create table, column defaults
275.2 Test with table and column constraints
275.3 Test with virtual columns
275.4 Test with column storage clause
275.5 Test with data dictionary
275.6 Test with dictionary views
275.7 Json Duality view with GraphQL
275.7.1 Create View using GraphQL
275.8 Test with different datatypes
275.8.1 Abstract datatype
275.8.2 XML datatype
275.8.3 JSON datatype
275.8.4 varray
275.9 Test with different types of indexes
275.9.1 Bitmap join index
275.9.2 Partitioned index
275.10 Tests with Attributes like COMPRESS, NOCOMPRESS, PARALLEL
275.10.1 COMPRESS
275.10.2 NOCOMPRESS
275.10.3 PARALLEL
275.11 Tests with Views
275.11.1 Object view
276. jsonDualityViews5.js
276.1 Insert data in table and views
276.2 test with Tags in column level
277. jsonDualityViews6.js
277.1 With tables and without constraints relationship
277.1.1 Insert data in table and views
277.1.2 Sanity DMLs
277.1.3 With Invalid tags
277.2 Queries(SNT,SNT+where clause)
277.2.1 With SNT
277.2.2 SNT+where clause
277.3 PK PK FK
277.3.1 Insert data in table and views
277.3.2 Sanity DMLs
277.3.3 with different keywords
278. Pool expansion
278.1 pool expansion when new connection created and within pool max limit
278.2 pool expansion when new connection created and exceeding pool max limit
278.3 pool expansion not done on creating minimum connection
278.4 no pool expansion while acquiring connection already present in pool
279. Pool Shrinkage
279.1 pool shrinkage during connection acquire always maintain min connection in pool
279.2 pool shrinkage during connection acquire when poolTimeout greater than 0
279.3 pool shrinkage during connection release when poolTimeout greater than 0
279.4 pool shrinkage during connection release will wait for pool timeout time before emitting events
279.5 pool shrinkage during connection release will wait for pool timeout time before emitting events while maintaining min connection
279.6 pool shrinkage during connection release will not happen when poolTimeout equals to 0
279.7 pool shrinkage will not happen when poolTimeout is 0
280. pipelinedTables.js
280.1 Creating and Invoking Pipelined Table Function
280.2 Invoking Pipelined Table Function with invalid syntax
280.3 Invoking normal Table followed by Pipelined table
280.4 Pipelined Table Functions with types
280.5 Parallel Enabled Pipelined Table Functions
281. aq5.js
281.1 subscribe dequeue messages
282. aq6.js
282.1 msgId in QUEUE_PAYLOAD_TYPE as ‘RAW’
282.1.1 msgId in enqOne/deqOne
282.1.2 msgId in enqMany/deqMany
282.2 msgId in QUEUE_PAYLOAD_TYPE as ‘JSON’
282.2.1 enqOne and deqOne Json val as array type
282.2.2 JSON type in enqMany/deqMany
282.3 msgId as Oracle Database Object AQ Messages
282.3.1 msgId in enqOne/deqOne
282.3.2 msgId in deqMany() with DB object array
283. aq7.js
283.1 JSON type in enqOne/deqOne
283.2 JSON type in enqMany/deqMany
283.3 Map JS object directly into JSON - enqOne/deqOne
283.4 Map JS object directly into JSON - enqMany/deqMany
283.5 enqOne and deqOne Null & Boolean in JSON
283.6 enqMany and deqMany Null & Boolean in JSON
283.7 enqOne and deqOne with JSON val as array type
283.8 enqMany and deqMany with JSON val as array type
283.9 enqOne and deqOne JSON val as object type
283.10 enqMany and deqMany with JSON val as object type
283.11 enqOne and deqOne CLOB value into a JSON key
284. errorUrl.js
284.1 checks for error URL in ORA error message
285. aq8.js
285.1 query by messages, payload as RAW Type
285.1.1 enqOne and deqOne by msgId as string in non-sequential order
285.1.2 query by msgId in enqMany and deqOne in non-sequential order
285.1.3 enqOne and deqOne by msgId as string in random order
285.1.4 query by msgId in enqMany and deqOne in random order
285.1.5 Negative - Invalid msgId in deqOptions
285.1.6 enqOne and deqOne by originalMsgId attribute as string in non-sequential order
285.1.7 query by originalMsgId in enqMany and deqOne in random order
285.2 query by msgId in QUEUE_PAYLOAD_TYPE as ‘JSON’
285.2.1 enqOne and deqOne Json val as array type in non-sequential order
285.2.2 enqOne and deqOne Json val as array type in random order
285.2.3 enqMany and deqOne Json val as array type in non-sequential order
285.2.4 enqMany and deqOne Json val as array type in random order
285.3 query by msgId as Oracle Database Object AQ Messages
285.3.1 msgId in enqOne/deqOne in non-sequential order
285.3.2 msgId in enqOne/deqOne in random order
285.3.3 msgId in enqOne/deqOne in non-sequential order
285.3.4 msgId in enqOne/deqOne in random order
286. listIndexes.js
286.1 listIndexes before creating any indexes
286.2 listIndexes after 1-createIndex
286.3 listIndexes after 2-createIndex
286.4 listIndexes after 2-createIndex 1-drop index
286.5 listIndexes after 2-createIndex 2-drop index
286.6 listIndexes after 3-createIndex
287. sodaOpLock.js
287.1 lock on document with multiple connections
287.2 lock on fetching a single document
287.3 lock on fetching multiple documents
287.4 lock on insertOneAndGet()
287.5 lock on filter()
287.6 lock on key()
287.7 lock on hint()
287.8 lock on count()
287.9 lock on keys().count()
287.10 lock on getCursor()
287.11 lock on skip().getCursor()
287.12 lock on getDocuments()
287.13 lock on getOne()
287.14 lock on remove()
287.15 lock on limit()
288. embedded_oid.js
288.1 Test embedded oid normal operations
288.1.1 create collection with No key present in the input doc
288.1.2 Embedded varchar key already present doc
288.1.3 Embedded number key already present in the doc
288.1.4 test replaceOne, for each replace op, use previously retrieved key
288.1.5 test replaceOne, A new string ID is present in the target document
288.1.6 test replaceOne, A new integer ID is present in the target document
288.1.7 test replaceOneAndGet, for each replace op, use previously retrieved key
288.1.8 test replaceOneAndGet, A new string ID is present in the target document
288.1.9 test replaceOneAndGet, A new integer ID is present in the target document
288.1.10 Negative test for save()
288.1.11 Negative test for saveAndGet()
288.2 Test QBEs - filter, skip and limit
288.2.1 filter()
288.2.2 skip() first doc
288.2.3 limit() operation to 1 doc
288.2.4 remove() previously retrieved key
288.2.5 remove() with filter, No key present in the input doc
289. sqlParser.js
289.1 parse SQL containing json_object()
289.2 bind variables between quoted string
289.3 PL/SQL - single line comment
289.4 PL/SQL - constant string
289.5 multiple division operation
289.6 SQL statement starting with parentheses
289.7 statement containing simple strings
289.8 binds between comments
289.9 non-ascii character in the bind name
289.10 apostrophe in single line comment
289.11 single line comment at the end
290. dbObject20.js
290.1 db Object tests with NCHAR datatype
290.1.1 insert an object with numeric/string values in NCHAR datatype
290.1.2 insert an object with null string values
290.1.3 insert an object with undefined string values
290.1.4 insert an empty object - no attributes
290.1.5 insert data via binding by object
290.1.6 insert multiple rows using executeMany() with inferred data type
290.1.7 insert multiple rows using executeMany() with explicit data type
290.1.8 call procedure with 2 OUT binds of DbObject
290.2 db Object tests with NVARCHAR2 datatype
290.2.1 insert an object with numeric/string values in NVARCHAR2 datatype
290.2.2 insert an object with null string values
290.2.3 insert an object with undefined string values
290.2.4 insert an empty object - no attributes
290.2.5 insert data via binding by object
290.2.6 insert multiple rows using executeMany() with inferred data type
290.2.7 insert multiple rows using executeMany() with explicit data type
290.2.8 call procedure with 2 OUT binds of DbObject
290.3 db Object tests with RAW datatype
290.3.1 insert an object with numeric/string values in RAW datatype
290.3.2 insert an object with null string values
290.3.3 insert an object with undefined string values
290.3.4 insert an empty object - no attributes
290.3.5 insert data via binding by object
290.3.6 insert multiple rows using executeMany() with inferred data type
290.3.7 insert multiple rows using executeMany() with explicit data type
290.3.8 call procedure with 2 OUT binds of DbObject
290.3.9 insert an object with buffer value with size 10
290.3.10 insert an object with buffer value with size 100
290.4 db Object tests with Invalid values to attributes
290.4.1 Invalid Values for nested property string
290.4.2 Invalid Values for different datatypes
290.4.3 Invalid Values for collection
290.4.4 Verify table of VARCHAR2 with CHAR/BYTE specifier
290.5 Associative Arrays fetch
290.5.1 verify associative array outbinds
290.6 db Object tests with XML Value type
290.6.1 Verify XML value and metaData inside object
291. dbSchema.js
291.1 dbSchema and Annotations
291.1.1 Verify dbDomain and Annotations
292. passwordExpiryWarning.js
292.1 password expiry warning
292.2 password expiry warning on homogeneous pool
292.3 password expiry warning on heterogeneous pool
292.4 with poolMin=0 with regular user and password
292.5 with poolMin=0 with password in grace time
292.6 with poolMin=1 with password in grace time
292.7 no warning after password change on new connection
293. plsqlWarnings.js
293.1 Warning on executing PL/SQL procedure
293.2 Warning from PL/SQL query on a non-existing table
293.3 Warning from function in a PLSQL query
293.4 with poolMin=0 with password in grace time with heterogeneous pool
293.5 Warning from executeMany
294. dataTypeVector1.js
294.1 standard vector tests with a single table
294.1.1 binding a vector type with various numeric array types
294.1.2 binding a vector type with unsupported typed arrays
294.1.3 binding a vector type with null vector array types
294.1.4 binding a vector type with various number typed arrays
294.1.5 update vector type into table
294.1.6 verify different vector constructors
294.1.7 insert 32 bit vector to 32 bit table
294.1.8 insert Int8 vector to Int8 vector column
294.1.9 insert int8 typed array to float64 vector column
294.1.10 insert int8arr typed array to flex vector column
294.1.11 insert int8arr typed array to float32 vector column
294.1.12 insert a float32 typed array into an int8 vector column
294.1.13 insert a float32 vector into an int8 column (negative)
294.1.14 insert a float64 typed array into an int8 vector column
294.1.15 insert float32 typed array to float64 vector column
294.1.16 insert float32 typed array to flex vector column
294.1.17 insert float64 typed array to float64 vector column
294.1.18 insert float64 typed array to float32 vector column
294.1.19 insert float64 typed array to flex vector column
294.1.20 insert vector with invalid size
294.1.21 insert double array to float32 vector column
294.1.22 inserting vector with invalid values
294.1.23 insert float and double array into vector column of default storage (float32)
294.1.24 insert float and double array into vector column of default storage (float32)
294.1.25 insert an array into vector
294.1.26 insert float and double array into flex vector column
294.1.27 insert an array into vector
294.1.28 returning vector as clob
294.1.29 creating vector with clob
294.1.30 vector_serialize
294.1.31 create table as select
294.1.32 insert float64 typed array to float64 vector column
294.1.33 add drop rename vector column
294.1.34 vector metadata verification
294.1.35 transactional features on vector
294.1.36 validate assm mssm on vector table
294.1.37 Test fuzzing of vector datatype
294.1.38 dml returning vector type
294.1.39 inserting more dimensions than defined in flexible vector column
294.1.40 executeMany with positional args
294.1.41 handling of NULLs and default values for vector types
294.1.42 ORDER BY and GROUP BY with vector types as negative test
294.1.43 selection of top vectors by Euclidean distance
294.1.44 with type Int16Array invalid typed arrays
294.1.45 typed arrays with strings
294.1.46 typed arrays with objects
294.1.47 typed arrays with boolean values
294.1.48 typed arrays with undefined value
294.1.49 typed arrays with null values
294.1.50 inserting empty vector in Fixed and Flex vector columns
294.2 vector tests with tables with different types of VECTOR columns
294.2.1 fetch VECTOR Column as string
294.2.2 fetch VECTOR Column as string using fetchInfo
294.2.3 fetching vector metadata
294.2.4 handling of NULL vector value
294.2.5 insert a float32 vector with 8127 dimensions into a float32 flex column
294.2.6 insert a float32 vector with 65535 dimensions into a vector column of same dimensions
294.2.7 insert a float64 vector with 65535 dimensions into a float64 flex column
294.2.8 insert a float64 vector with 65533 dimensions to float32 vector
294.2.9 insert a float64 vector with 65535 dimensions to flex float32 vector
294.2.10 insert a int8 vector with 65533 dimensions to flex int8 column
294.2.11 insert using executeMany, update, delete and select vectors
294.2.12 insert clob with array of 65535 elements to a vector column
294.2.13 insert vector as clob to Int8 column
294.2.14 insert vector as clob to float64 column
294.2.15 insert vector as clob to float32 column
294.2.16 insert a clob with 65535 elements to float64 vector column
294.2.17 insert and update vector as clob
294.2.18 insert a Float64 vector array with 65535 dimensions to Float32 vector column
294.2.19 Procedure Call with Vector Type Parameters
294.2.20 binding a vector with inf values (negative)
294.2.21 fetch JSON value with an embedded vector
294.2.22 bind JSON value with an embedded vector
294.2.23 fetch VECTOR column as string with table recreate
295. dataTypeVector2.js
295.1 verify fetch information for older clients
295.2 verify default fetched value is an array
295.3 verify fetched value as intermediate long value
295.4 verify fetched value as intermediate string value
296. dataTypeVector3.js
296.1 insert rows into the table
296.2 retrieve rows from the table and verify values
296.3 calculate vector distances to a given embedding
296.4 perform a top 3 similarity search to a given embedding
296.5 find nearest neighbors with distance < 34 for a given embedding
296.6 calculate cosine distances to a given embedding
296.7 calculate inner products with a given embedding
296.8 should handle negative vector components
296.9 should handle large vector components
296.10 should handle zero vector components
297. jsonDualityView7.js
297.1 With tables and without constraints relationship using vectors
297.1.1 Insert float32 vector data in table and views
297.1.2 Insert float32 vector data with dimension 10
297.1.3 Insert float64 vector data
297.1.4 Insert fixed vector data
297.1.5 Insert int8 vector data
297.1.6 insert int8 typed array to float64 vector column
297.1.7 insert int8 typed array to flex vector column
297.1.8 insert int8 typed array to float32 vector column
297.1.9 insert a float32 typed array into an int8 vector column
297.1.10 insert a float64 into an int8 vector column
297.1.11 Insert vector as clob to Int8 column
297.1.12 insert clob with array of 65535 elements to a vector column
297.1.13 insert a float32 vector with 65535 dimensions into a vector column of same dimensions
297.1.14 insert a float64 typed array created from ArrayBuffer
297.2 Sanity DMLs
297.2.1 insert float32 vector data in table and views
297.2.2 insert float32 vector data with dimension 10
297.2.3 insert float64 vector data
297.2.4 insert fixed vector data
297.2.5 insert int8 vector data
297.2.6 insert int8 typed array to float64 vector column
297.2.7 insert int8 typed array to flex vector column
297.2.8 insert int8 typed array to float32 vector column
297.2.9 insert a float32 typed array into an int8 vector column
297.2.10 insert a float64 into an int8 vector column
297.2.11 insert vector as clob to Int8 column
297.2.12 insert clob with array of 65535 elements to a vector column
297.2.13 insert clob with array of less elements to a vector column
297.2.14 insert a float32 vector with 65535 dimensions into a vector column of same dimensions
297.2.15 insert a float32 vector with less dimensions into a vector column of same dimensions
297.2.16 insert a float64 typed array created from ArrayBuffer
297.3 Sanity DMLs
297.3.1 insert a float32 typed array into tables from JSON DV
297.3.2 insert a 65535 dimension float32 typed array into tables from JSON DV
297.3.3 insert a 65536 dimension float32 typed array into tables from JSON DV
297.3.4 insert a float32 typed array into tables from JSON DV wrong dimension
297.3.5 update a float32 typed array into tables from JSON DV
297.3.6 delete a float32 typed array into tables from JSON DV
297.3.7 insert a float64 into tables from JSON DV
297.3.8 update a float64 into tables from JSON DV
297.3.9 delete a float64 into tables from JSON DV
297.3.10 insert a VectorInt8Col typed array into tables from JSON DV
297.3.11 update a VectorInt8Col typed array into tables from JSON DV
297.3.12 delete a VectorInt8Col typed array into tables from JSON DV
298. dataTypeVector4.js
298.1 inserting and fetching vector using parallel execution
298.2 insert data as select all elements
298.3 insert data as select all elements by setting degree of parallelism to 2
298.4 insert and select Min vector distance function
298.5 insert and select Max vector distance function
298.6 sum vector distance function vector columns with parallel execution
298.7 average vector distance function vector columns with parallel execution
298.8 aggregate functions on vector columns vector columns with parallel execution
298.9 parallel delete operation on vector columns
298.10 no parallel delete operation on vector columns
299. invalidNumber.js
299.1 throws error for invalid numbers(largest exponent + 1)
299.2 throws error for invalid numbers(smallest exponent - 1)
300. bigInt.js
300.1 can bind bigInts
300.1.1 with execute
300.1.2 with executeMany
300.2 fetch values
300.2.1 fetches the value as number(default)
300.2.2 use fetchTypeHandler to get BigInt value
300.2.3 fetches values greater than Number.MAX_SAFE_INTEGER correctly
301. aq9.js
301.1 Enqueue messages with transformation single user queue
301.2 Enqueue messages with transformation on multiple users
301.3 Enqueue and dequeue messages with transformation on single user queue
301.4 Enqueue and dequeue messages with transformation on multiple user queue
302. aq10.js
302.1 condition attribute in dequeue
302.2 Negative - wrong identifier in condition attribute
303. aq11.js
303.1 enqueue/dequeue with modes
304. plsqlRowtype.js
304.1 %ROWTYPE
304.2 %ROWTYPE collection
305. dataTypeVector5.js
305.1 tests with vector distance
305.1.1 SELECT query with standard vector distance
305.1.2 SELECT query with EUCLIDEAN vector distance
305.1.3 SELECT query with MANHATTAN vector distance
305.1.4 SELECT query with COSINE vector distance
305.1.5 SELECT query with DOT vector distance
305.1.6 SELECT query with HAMMING vector distance
305.1.7 SELECT query with EUCLIDEAN_SQUARED vector distance
305.1.8 Synonym test for vector distance
305.1.9 Negative test
Reference in New Issue View Git Blame Copy Permalink