293 |
|
Size = 2 |
294 |
|
Value = 0 |
295 |
|
|
296 |
+ |
Results for Cursor: Test Cursor |
297 |
|
EMP_NO = 8 |
298 |
|
FIRST_NAME = Leslie |
299 |
|
LAST_NAME = Johnson |
521 |
|
Size = 2 |
522 |
|
Value = 0 |
523 |
|
|
524 |
+ |
Results for Cursor: Test Cursor |
525 |
|
EMP_NO = 8 |
526 |
|
FIRST_NAME = Leslie |
527 |
|
LAST_NAME = Johnson |
534 |
|
SALARY = 64,635.00 |
535 |
|
FULL_NAME = Johnson, Leslie |
536 |
|
|
537 |
+ |
Scollable Cursors |
538 |
+ |
Do Fetch Next: |
539 |
+ |
EMP_NO = 2 |
540 |
+ |
FIRST_NAME = Robert |
541 |
+ |
LAST_NAME = Nelson |
542 |
+ |
PHONE_EXT = 250 |
543 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
544 |
+ |
DEPT_NO = 600 |
545 |
+ |
JOB_CODE = VP |
546 |
+ |
JOB_GRADE = 2 |
547 |
+ |
JOB_COUNTRY = USA |
548 |
+ |
SALARY = 105,900.00 |
549 |
+ |
FULL_NAME = Nelson, Robert |
550 |
+ |
Do Fetch Last: |
551 |
+ |
EMP_NO = 145 |
552 |
+ |
FIRST_NAME = Mark |
553 |
+ |
LAST_NAME = Guckenheimer |
554 |
+ |
PHONE_EXT = 221 |
555 |
+ |
HIRE_DATE = 1994/05/02 00:00:00.0000 |
556 |
+ |
DEPT_NO = 622 |
557 |
+ |
JOB_CODE = Eng |
558 |
+ |
JOB_GRADE = 5 |
559 |
+ |
JOB_COUNTRY = USA |
560 |
+ |
SALARY = 32,000.00 |
561 |
+ |
FULL_NAME = Guckenheimer, Mark |
562 |
+ |
Do Fetch Prior: |
563 |
+ |
EMP_NO = 144 |
564 |
+ |
FIRST_NAME = John |
565 |
+ |
LAST_NAME = Montgomery |
566 |
+ |
PHONE_EXT = 820 |
567 |
+ |
HIRE_DATE = 1994/03/30 00:00:00.0000 |
568 |
+ |
DEPT_NO = 672 |
569 |
+ |
JOB_CODE = Eng |
570 |
+ |
JOB_GRADE = 5 |
571 |
+ |
JOB_COUNTRY = USA |
572 |
+ |
SALARY = 35,000.00 |
573 |
+ |
FULL_NAME = Montgomery, John |
574 |
+ |
Do Fetch First: |
575 |
+ |
EMP_NO = 2 |
576 |
+ |
FIRST_NAME = Robert |
577 |
+ |
LAST_NAME = Nelson |
578 |
+ |
PHONE_EXT = 250 |
579 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
580 |
+ |
DEPT_NO = 600 |
581 |
+ |
JOB_CODE = VP |
582 |
+ |
JOB_GRADE = 2 |
583 |
+ |
JOB_COUNTRY = USA |
584 |
+ |
SALARY = 105,900.00 |
585 |
+ |
FULL_NAME = Nelson, Robert |
586 |
+ |
Do Fetch Abs 8 : |
587 |
+ |
EMP_NO = 14 |
588 |
+ |
FIRST_NAME = Stewart |
589 |
+ |
LAST_NAME = Hall |
590 |
+ |
PHONE_EXT = 227 |
591 |
+ |
HIRE_DATE = 1990/06/04 00:00:00.0000 |
592 |
+ |
DEPT_NO = 900 |
593 |
+ |
JOB_CODE = Finan |
594 |
+ |
JOB_GRADE = 3 |
595 |
+ |
JOB_COUNTRY = USA |
596 |
+ |
SALARY = 69,482.63 |
597 |
+ |
FULL_NAME = Hall, Stewart |
598 |
+ |
Do Fetch Relative -2 : |
599 |
+ |
EMP_NO = 11 |
600 |
+ |
FIRST_NAME = K. J. |
601 |
+ |
LAST_NAME = Weston |
602 |
+ |
PHONE_EXT = 34 |
603 |
+ |
HIRE_DATE = 1990/01/17 00:00:00.0000 |
604 |
+ |
DEPT_NO = 130 |
605 |
+ |
JOB_CODE = SRep |
606 |
+ |
JOB_GRADE = 4 |
607 |
+ |
JOB_COUNTRY = USA |
608 |
+ |
SALARY = 86,292.94 |
609 |
+ |
FULL_NAME = Weston, K. J. |
610 |
+ |
Do Fetch beyond EOF : |
611 |
+ |
Fetch returned false |
612 |
|
|
613 |
|
|
614 |
|
------------------------------------------------------ |
646 |
|
SALARY = 64,635.00 |
647 |
|
FULL_NAME = Johnson, Leslie |
648 |
|
|
649 |
< |
Current memory = 19,767,232 |
649 |
> |
Current memory = 19,767,952 |
650 |
|
Delta memory = 4,464 |
651 |
< |
Max memory = 19,813,104 |
652 |
< |
Elapsed time= 0.001 sec |
651 |
> |
Max memory = 19,813,568 |
652 |
> |
Elapsed time= 0.000 sec |
653 |
|
Cpu = 0.000 sec |
654 |
|
Buffers = 2048 |
655 |
|
Reads = 0 |
2800 |
|
Database Created: 29/5/2021 16:47:30 |
2801 |
|
Pages Used = 313 |
2802 |
|
Pages Free = 762 |
2803 |
< |
Server Memory = 19483648 |
2803 |
> |
Server Memory = 19484112 |
2804 |
|
Forced Writes = 1 |
2805 |
< |
Max Memory = 19629664 |
2805 |
> |
Max Memory = 19630384 |
2806 |
|
Num Buffers = 2048 |
2807 |
|
Sweep Interval = 20000 |
2808 |
|
Logged in Users: SYSDBA, |
3223 |
|
Error Handled: Field "EMP_NO" not found |
3224 |
|
Case sensitive Param SQL Test |
3225 |
|
Error Handled: Field "EMP_NO" not found |
3226 |
+ |
Stale Reference Check |
3227 |
+ |
First test correct usage |
3228 |
+ |
COUNTER = 42 |
3229 |
+ |
|
3230 |
+ |
New Transaction before param set |
3231 |
+ |
Error Handled: This interface is no longer up-to-date |
3232 |
+ |
New Transaction before Open Cursor |
3233 |
+ |
Error Handled: This interface is no longer up-to-date |
3234 |
+ |
Stop Stale Reference Checks |
3235 |
+ |
New Transaction before param set |
3236 |
+ |
COUNTER = 42 |
3237 |
+ |
|
3238 |
+ |
New Transaction before Open Cursor |
3239 |
+ |
COUNTER = 42 |
3240 |
+ |
|
3241 |
|
Invalid Server Name Test |
3242 |
|
Error Handled: Unable to complete network request to host "unknown". |
3243 |
|
-Failed to locate host machine. |
4560 |
|
|
4561 |
|
|
4562 |
|
------------------------------------------------------ |
4563 |
+ |
Running Test 21: Exercise setting and getting of numeric data types |
4564 |
+ |
SQL Params |
4565 |
+ |
SQLType =SQL_LONG |
4566 |
+ |
sub type = 0 |
4567 |
+ |
Field Name = |
4568 |
+ |
Scale = 0 |
4569 |
+ |
Charset id = 0 |
4570 |
+ |
Not Null |
4571 |
+ |
Size = 4 |
4572 |
+ |
Value = 0 |
4573 |
+ |
|
4574 |
+ |
SQLType =SQL_LONG |
4575 |
+ |
sub type = 0 |
4576 |
+ |
Field Name = |
4577 |
+ |
Scale = 0 |
4578 |
+ |
Charset id = 0 |
4579 |
+ |
Nullable |
4580 |
+ |
Size = 4 |
4581 |
+ |
|
4582 |
+ |
SQLType =SQL_INT64 |
4583 |
+ |
sub type = 0 |
4584 |
+ |
Field Name = |
4585 |
+ |
Scale = 0 |
4586 |
+ |
Charset id = 0 |
4587 |
+ |
Nullable |
4588 |
+ |
Size = 8 |
4589 |
+ |
|
4590 |
+ |
SQLType =SQL_INT64 |
4591 |
+ |
sub type = 0 |
4592 |
+ |
Field Name = |
4593 |
+ |
Scale = -4 |
4594 |
+ |
Charset id = 0 |
4595 |
+ |
Nullable |
4596 |
+ |
Size = 8 |
4597 |
+ |
|
4598 |
+ |
SQLType =SQL_DOUBLE |
4599 |
+ |
sub type = 0 |
4600 |
+ |
Field Name = |
4601 |
+ |
Scale = 0 |
4602 |
+ |
Charset id = 0 |
4603 |
+ |
Nullable |
4604 |
+ |
Size = 8 |
4605 |
+ |
|
4606 |
+ |
SQLType =SQL_INT64 |
4607 |
+ |
sub type = 0 |
4608 |
+ |
Field Name = |
4609 |
+ |
Scale = -6 |
4610 |
+ |
Charset id = 0 |
4611 |
+ |
Nullable |
4612 |
+ |
Size = 8 |
4613 |
+ |
|
4614 |
+ |
Expected Error - SQLCODE: -303 |
4615 |
+ |
Engine Code: 335544569 Incompatible column/host variable data type |
4616 |
+ |
Dynamic SQL Error |
4617 |
+ |
-SQL error code = -303 |
4618 |
+ |
-conversion error from string "1,000" |
4619 |
+ |
Expected Error - SQLCODE: -303 |
4620 |
+ |
Engine Code: 335544569 Incompatible column/host variable data type |
4621 |
+ |
Dynamic SQL Error |
4622 |
+ |
-SQL error code = -303 |
4623 |
+ |
-conversion error from string "10.0.0" |
4624 |
+ |
ROWID = 1 |
4625 |
+ |
ITYPE = 101 |
4626 |
+ |
I64TYPE = 9223372036854775807 |
4627 |
+ |
CURRTYPE = 10,000.12340000 |
4628 |
+ |
DTYPE = 9,999.12345678 |
4629 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
4630 |
+ |
ROWID = 2 |
4631 |
+ |
ITYPE = -32457 |
4632 |
+ |
I64TYPE = -9223372036854775808 |
4633 |
+ |
CURRTYPE = 1,000,001.12000000 |
4634 |
+ |
DTYPE = 1.7E308 |
4635 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
4636 |
+ |
ROWID = 3 |
4637 |
+ |
ITYPE = 0 |
4638 |
+ |
I64TYPE = 0 |
4639 |
+ |
CURRTYPE = .00000000 |
4640 |
+ |
DTYPE = .00000000 |
4641 |
+ |
FIXEDPOINT = .00000000 |
4642 |
+ |
ROWID = 4 |
4643 |
+ |
ITYPE = 1 |
4644 |
+ |
I64TYPE = 10 |
4645 |
+ |
CURRTYPE = .02300000 |
4646 |
+ |
DTYPE = .00000000 |
4647 |
+ |
FIXEDPOINT = 233.45600000 |
4648 |
+ |
|
4649 |
+ |
|
4650 |
+ |
|
4651 |
+ |
------------------------------------------------------ |
4652 |
|
Test Suite Ends |