292 |
|
Size = 2 |
293 |
|
Value = 0 |
294 |
|
|
295 |
+ |
Results for Cursor: Test Cursor |
296 |
|
EMP_NO = 8 |
297 |
|
FIRST_NAME = Leslie |
298 |
|
LAST_NAME = Johnson |
520 |
|
Size = 2 |
521 |
|
Value = 0 |
522 |
|
|
523 |
+ |
Results for Cursor: Test Cursor |
524 |
|
EMP_NO = 8 |
525 |
|
FIRST_NAME = Leslie |
526 |
|
LAST_NAME = Johnson |
533 |
|
SALARY = 64,635.00 |
534 |
|
FULL_NAME = Johnson, Leslie |
535 |
|
|
536 |
+ |
Scollable Cursors |
537 |
+ |
Do Fetch Next: |
538 |
+ |
EMP_NO = 2 |
539 |
+ |
FIRST_NAME = Robert |
540 |
+ |
LAST_NAME = Nelson |
541 |
+ |
PHONE_EXT = 250 |
542 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
543 |
+ |
DEPT_NO = 600 |
544 |
+ |
JOB_CODE = VP |
545 |
+ |
JOB_GRADE = 2 |
546 |
+ |
JOB_COUNTRY = USA |
547 |
+ |
SALARY = 105,900.00 |
548 |
+ |
FULL_NAME = Nelson, Robert |
549 |
+ |
Do Fetch Last: |
550 |
+ |
EMP_NO = 145 |
551 |
+ |
FIRST_NAME = Mark |
552 |
+ |
LAST_NAME = Guckenheimer |
553 |
+ |
PHONE_EXT = 221 |
554 |
+ |
HIRE_DATE = 1994/05/02 00:00:00.0000 |
555 |
+ |
DEPT_NO = 622 |
556 |
+ |
JOB_CODE = Eng |
557 |
+ |
JOB_GRADE = 5 |
558 |
+ |
JOB_COUNTRY = USA |
559 |
+ |
SALARY = 32,000.00 |
560 |
+ |
FULL_NAME = Guckenheimer, Mark |
561 |
+ |
Do Fetch Prior: |
562 |
+ |
EMP_NO = 144 |
563 |
+ |
FIRST_NAME = John |
564 |
+ |
LAST_NAME = Montgomery |
565 |
+ |
PHONE_EXT = 820 |
566 |
+ |
HIRE_DATE = 1994/03/30 00:00:00.0000 |
567 |
+ |
DEPT_NO = 672 |
568 |
+ |
JOB_CODE = Eng |
569 |
+ |
JOB_GRADE = 5 |
570 |
+ |
JOB_COUNTRY = USA |
571 |
+ |
SALARY = 35,000.00 |
572 |
+ |
FULL_NAME = Montgomery, John |
573 |
+ |
Do Fetch First: |
574 |
+ |
EMP_NO = 2 |
575 |
+ |
FIRST_NAME = Robert |
576 |
+ |
LAST_NAME = Nelson |
577 |
+ |
PHONE_EXT = 250 |
578 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
579 |
+ |
DEPT_NO = 600 |
580 |
+ |
JOB_CODE = VP |
581 |
+ |
JOB_GRADE = 2 |
582 |
+ |
JOB_COUNTRY = USA |
583 |
+ |
SALARY = 105,900.00 |
584 |
+ |
FULL_NAME = Nelson, Robert |
585 |
+ |
Do Fetch Abs 8 : |
586 |
+ |
EMP_NO = 14 |
587 |
+ |
FIRST_NAME = Stewart |
588 |
+ |
LAST_NAME = Hall |
589 |
+ |
PHONE_EXT = 227 |
590 |
+ |
HIRE_DATE = 1990/06/04 00:00:00.0000 |
591 |
+ |
DEPT_NO = 900 |
592 |
+ |
JOB_CODE = Finan |
593 |
+ |
JOB_GRADE = 3 |
594 |
+ |
JOB_COUNTRY = USA |
595 |
+ |
SALARY = 69,482.63 |
596 |
+ |
FULL_NAME = Hall, Stewart |
597 |
+ |
Do Fetch Relative -2 : |
598 |
+ |
EMP_NO = 11 |
599 |
+ |
FIRST_NAME = K. J. |
600 |
+ |
LAST_NAME = Weston |
601 |
+ |
PHONE_EXT = 34 |
602 |
+ |
HIRE_DATE = 1990/01/17 00:00:00.0000 |
603 |
+ |
DEPT_NO = 130 |
604 |
+ |
JOB_CODE = SRep |
605 |
+ |
JOB_GRADE = 4 |
606 |
+ |
JOB_COUNTRY = USA |
607 |
+ |
SALARY = 86,292.94 |
608 |
+ |
FULL_NAME = Weston, K. J. |
609 |
+ |
Do Fetch beyond EOF : |
610 |
+ |
Fetch returned false |
611 |
|
|
612 |
|
|
613 |
|
------------------------------------------------------ |
645 |
|
SALARY = 64,635.00 |
646 |
|
FULL_NAME = Johnson, Leslie |
647 |
|
|
648 |
< |
Current memory = 19,693,312 |
648 |
> |
Current memory = 19,694,032 |
649 |
|
Delta memory = 4,480 |
650 |
< |
Max memory = 19,755,424 |
650 |
> |
Max memory = 19,755,888 |
651 |
|
Elapsed time= 0.001 sec |
652 |
|
Cpu = 0.000 sec |
653 |
|
Buffers = 2048 |
2799 |
|
Database Created: 09/1/2020 13:13:45 |
2800 |
|
Pages Used = 297 |
2801 |
|
Pages Free = 10 |
2802 |
< |
Server Memory = 19195664 |
2802 |
> |
Server Memory = 19196128 |
2803 |
|
Forced Writes = 1 |
2804 |
< |
Max Memory = 19316176 |
2804 |
> |
Max Memory = 19316896 |
2805 |
|
Num Buffers = 2048 |
2806 |
|
Sweep Interval = 20000 |
2807 |
|
Logged in Users: SYSDBA, |
3216 |
|
Error Handled: Field "EMP_NO" not found |
3217 |
|
Case sensitive Param SQL Test |
3218 |
|
Error Handled: Field "EMP_NO" not found |
3219 |
+ |
Stale Reference Check |
3220 |
+ |
First test correct usage |
3221 |
+ |
COUNTER = 42 |
3222 |
+ |
|
3223 |
+ |
New Transaction before param set |
3224 |
+ |
Error Handled: This interface is no longer up-to-date |
3225 |
+ |
New Transaction before Open Cursor |
3226 |
+ |
Error Handled: This interface is no longer up-to-date |
3227 |
+ |
Stop Stale Reference Checks |
3228 |
+ |
New Transaction before param set |
3229 |
+ |
COUNTER = 42 |
3230 |
+ |
|
3231 |
+ |
New Transaction before Open Cursor |
3232 |
+ |
COUNTER = 42 |
3233 |
+ |
|
3234 |
|
Invalid Server Name Test |
3235 |
|
Error Handled: Unable to complete network request to host "unknown". |
3236 |
|
-Failed to locate host machine. |
3344 |
|
|
3345 |
|
|
3346 |
|
------------------------------------------------------ |
3347 |
+ |
Running Test 21: Exercise setting and getting of numeric data types |
3348 |
+ |
SQL Params |
3349 |
+ |
SQLType =SQL_LONG |
3350 |
+ |
sub type = 0 |
3351 |
+ |
Field Name = |
3352 |
+ |
Scale = 0 |
3353 |
+ |
Charset id = 0 |
3354 |
+ |
Not Null |
3355 |
+ |
Size = 4 |
3356 |
+ |
Value = 0 |
3357 |
+ |
|
3358 |
+ |
SQLType =SQL_LONG |
3359 |
+ |
sub type = 0 |
3360 |
+ |
Field Name = |
3361 |
+ |
Scale = 0 |
3362 |
+ |
Charset id = 0 |
3363 |
+ |
Nullable |
3364 |
+ |
Size = 4 |
3365 |
+ |
|
3366 |
+ |
SQLType =SQL_INT64 |
3367 |
+ |
sub type = 0 |
3368 |
+ |
Field Name = |
3369 |
+ |
Scale = 0 |
3370 |
+ |
Charset id = 0 |
3371 |
+ |
Nullable |
3372 |
+ |
Size = 8 |
3373 |
+ |
|
3374 |
+ |
SQLType =SQL_INT64 |
3375 |
+ |
sub type = 0 |
3376 |
+ |
Field Name = |
3377 |
+ |
Scale = -4 |
3378 |
+ |
Charset id = 0 |
3379 |
+ |
Nullable |
3380 |
+ |
Size = 8 |
3381 |
+ |
|
3382 |
+ |
SQLType =SQL_DOUBLE |
3383 |
+ |
sub type = 0 |
3384 |
+ |
Field Name = |
3385 |
+ |
Scale = 0 |
3386 |
+ |
Charset id = 0 |
3387 |
+ |
Nullable |
3388 |
+ |
Size = 8 |
3389 |
+ |
|
3390 |
+ |
SQLType =SQL_INT64 |
3391 |
+ |
sub type = 0 |
3392 |
+ |
Field Name = |
3393 |
+ |
Scale = -6 |
3394 |
+ |
Charset id = 0 |
3395 |
+ |
Nullable |
3396 |
+ |
Size = 8 |
3397 |
+ |
|
3398 |
+ |
Expected Error - Dynamic SQL Error |
3399 |
+ |
-SQL error code = -303 |
3400 |
+ |
-conversion error from string "1,000" |
3401 |
+ |
Expected Error - Dynamic SQL Error |
3402 |
+ |
-SQL error code = -303 |
3403 |
+ |
-conversion error from string "10.0.0" |
3404 |
+ |
ROWID = 1 |
3405 |
+ |
ITYPE = 101 |
3406 |
+ |
I64TYPE = 9223372036854775807 |
3407 |
+ |
CURRTYPE = 10,000.12340000 |
3408 |
+ |
DTYPE = 9,999.12345678 |
3409 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
3410 |
+ |
ROWID = 2 |
3411 |
+ |
ITYPE = -32457 |
3412 |
+ |
I64TYPE = -9223372036854775808 |
3413 |
+ |
CURRTYPE = 1,000,001.12000000 |
3414 |
+ |
DTYPE = 1.7E308 |
3415 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
3416 |
+ |
ROWID = 3 |
3417 |
+ |
ITYPE = 0 |
3418 |
+ |
I64TYPE = 0 |
3419 |
+ |
CURRTYPE = .00000000 |
3420 |
+ |
DTYPE = .00000000 |
3421 |
+ |
FIXEDPOINT = .00000000 |
3422 |
+ |
ROWID = 4 |
3423 |
+ |
ITYPE = 1 |
3424 |
+ |
I64TYPE = 10 |
3425 |
+ |
CURRTYPE = .02300000 |
3426 |
+ |
DTYPE = .00000000 |
3427 |
+ |
FIXEDPOINT = 233.45600000 |
3428 |
+ |
|
3429 |
+ |
|
3430 |
+ |
|
3431 |
+ |
------------------------------------------------------ |
3432 |
|
Test Suite Ends |