| 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 |
| 812 |
|
JOB_CODE = Eng |
| 813 |
|
JOB_GRADE = 4 |
| 814 |
|
JOB_COUNTRY = England |
| 815 |
< |
SALARY = 40,000.58 |
| 815 |
> |
SALARY = 40,000.59 |
| 816 |
|
FULL_NAME = Major, Major |
| 817 |
|
|
| 818 |
|
Now Delete the rows |
| 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, |
| 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.12345600 |
| 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.12345600 |
| 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 |
|
|
