/ Usenet 1994 January / usenetsourcesnewsgroupsinfomagicjanuary1994.iso / sources / misc / volume30 / oraperl-v2 / part04

< prev

next >

view JSON data

view as text

open on a Mac

open on a PC

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 4e 65 77 73 67 72 6f 75 | 70 73 3a 20 63 6f 6d 70 |Newsgrou|ps: comp|
|00000010| 2e 73 6f 75 72 63 65 73 | 2e 6d 69 73 63 0a 46 72 |.sources|.misc.Fr|
|00000020| 6f 6d 3a 20 4b 65 76 69 | 6e 20 53 74 6f 63 6b 20 |om: Kevi|n Stock |
|00000030| 3c 6b 73 74 6f 63 6b 40 | 65 6e 63 6f 72 65 2e 63 |<kstock@|encore.c|
|00000040| 6f 6d 3e 0a 53 75 62 6a | 65 63 74 3a 20 20 76 33 |om>.Subj|ect:  v3|
|00000050| 30 69 30 39 30 3a 20 20 | 6f 72 61 70 65 72 6c 2d |0i090:  |oraperl-|
|00000060| 76 32 20 2d 20 45 78 74 | 65 6e 73 69 6f 6e 73 20 |v2 - Ext|ensions |
|00000070| 74 6f 20 50 65 72 6c 20 | 74 6f 20 61 63 63 65 73 |to Perl |to acces|
|00000080| 73 20 4f 72 61 63 6c 65 | 20 64 61 74 61 62 61 73 |s Oracle| databas|
|00000090| 65 2c 20 50 61 72 74 30 | 34 2f 30 35 0a 4d 65 73 |e, Part0|4/05.Mes|
|000000a0| 73 61 67 65 2d 49 44 3a | 20 3c 31 39 39 32 4a 75 |sage-ID:| <1992Ju|
|000000b0| 6e 32 39 2e 31 38 34 33 | 32 31 2e 31 31 38 39 33 |n29.1843|21.11893|
|000000c0| 40 73 70 61 72 6b 79 2e | 69 6d 64 2e 73 74 65 72 |@sparky.|imd.ster|
|000000d0| 6c 69 6e 67 2e 63 6f 6d | 3e 0a 58 2d 4d 64 34 2d |ling.com|>.X-Md4-|
|000000e0| 53 69 67 6e 61 74 75 72 | 65 3a 20 63 35 37 36 35 |Signatur|e: c5765|
|000000f0| 38 35 34 63 61 32 34 63 | 66 65 32 34 64 34 66 62 |854ca24c|fe24d4fb|
|00000100| 34 37 35 65 61 38 31 33 | 66 63 33 0a 44 61 74 65 |475ea813|fc3.Date|
|00000110| 3a 20 4d 6f 6e 2c 20 32 | 39 20 4a 75 6e 20 31 39 |: Mon, 2|9 Jun 19|
|00000120| 39 32 20 31 38 3a 34 33 | 3a 32 31 20 47 4d 54 0a |92 18:43|:21 GMT.|
|00000130| 41 70 70 72 6f 76 65 64 | 3a 20 6b 65 6e 74 40 73 |Approved|: kent@s|
|00000140| 70 61 72 6b 79 2e 69 6d | 64 2e 73 74 65 72 6c 69 |parky.im|d.sterli|
|00000150| 6e 67 2e 63 6f 6d 0a 0a | 53 75 62 6d 69 74 74 65 |ng.com..|Submitte|
|00000160| 64 2d 62 79 3a 20 4b 65 | 76 69 6e 20 53 74 6f 63 |d-by: Ke|vin Stoc|
|00000170| 6b 20 3c 6b 73 74 6f 63 | 6b 40 65 6e 63 6f 72 65 |k <kstoc|k@encore|
|00000180| 2e 63 6f 6d 3e 0a 50 6f | 73 74 69 6e 67 2d 6e 75 |.com>.Po|sting-nu|
|00000190| 6d 62 65 72 3a 20 56 6f | 6c 75 6d 65 20 33 30 2c |mber: Vo|lume 30,|
|000001a0| 20 49 73 73 75 65 20 39 | 30 0a 41 72 63 68 69 76 | Issue 9|0.Archiv|
|000001b0| 65 2d 6e 61 6d 65 3a 20 | 6f 72 61 70 65 72 6c 2d |e-name: |oraperl-|
|000001c0| 76 32 2f 70 61 72 74 30 | 34 0a 45 6e 76 69 72 6f |v2/part0|4.Enviro|
|000001d0| 6e 6d 65 6e 74 3a 20 50 | 65 72 6c 2c 20 4f 72 61 |nment: P|erl, Ora|
|000001e0| 63 6c 65 20 77 69 74 68 | 20 4f 43 49 2c 20 6f 70 |cle with| OCI, op|
|000001f0| 74 69 6f 6e 61 6c 6c 79 | 20 43 75 72 73 65 73 0a |tionally| Curses.|
|00000200| 53 75 70 65 72 73 65 64 | 65 73 3a 20 6f 72 61 70 |Supersed|es: orap|
|00000210| 65 72 6c 3a 20 56 6f 6c | 75 6d 65 20 31 38 2c 20 |erl: Vol|ume 18, |
|00000220| 49 73 73 75 65 20 31 30 | 0a 0a 23 21 20 2f 62 69 |Issue 10|..#! /bi|
|00000230| 6e 2f 73 68 0a 23 20 54 | 68 69 73 20 69 73 20 61 |n/sh.# T|his is a|
|00000240| 20 73 68 65 6c 6c 20 61 | 72 63 68 69 76 65 2e 20 | shell a|rchive. |
|00000250| 20 52 65 6d 6f 76 65 20 | 61 6e 79 74 68 69 6e 67 | Remove |anything|
|00000260| 20 62 65 66 6f 72 65 20 | 74 68 69 73 20 6c 69 6e | before |this lin|
|00000270| 65 2c 20 74 68 65 6e 20 | 66 65 65 64 20 69 74 0a |e, then |feed it.|
|00000280| 23 20 69 6e 74 6f 20 61 | 20 73 68 65 6c 6c 20 76 |# into a| shell v|
|00000290| 69 61 20 22 73 68 20 66 | 69 6c 65 22 20 6f 72 20 |ia "sh f|ile" or |
|000002a0| 73 69 6d 69 6c 61 72 2e | 20 20 54 6f 20 6f 76 65 |similar.|  To ove|
|000002b0| 72 77 72 69 74 65 20 65 | 78 69 73 74 69 6e 67 20 |rwrite e|xisting |
|000002c0| 66 69 6c 65 73 2c 0a 23 | 20 74 79 70 65 20 22 73 |files,.#| type "s|
|000002d0| 68 20 66 69 6c 65 20 2d | 63 22 2e 0a 23 20 54 68 |h file -|c"..# Th|
|000002e0| 65 20 74 6f 6f 6c 20 74 | 68 61 74 20 67 65 6e 65 |e tool t|hat gene|
|000002f0| 72 61 74 65 64 20 74 68 | 69 73 20 61 70 70 65 61 |rated th|is appea|
|00000300| 72 65 64 20 69 6e 20 74 | 68 65 20 63 6f 6d 70 2e |red in t|he comp.|
|00000310| 73 6f 75 72 63 65 73 2e | 75 6e 69 78 20 6e 65 77 |sources.|unix new|
|00000320| 73 67 72 6f 75 70 3b 0a | 23 20 73 65 6e 64 20 6d |sgroup;.|# send m|
|00000330| 61 69 6c 20 74 6f 20 63 | 6f 6d 70 2d 73 6f 75 72 |ail to c|omp-sour|
|00000340| 63 65 73 2d 75 6e 69 78 | 40 75 75 6e 65 74 2e 75 |ces-unix|@uunet.u|
|00000350| 75 2e 6e 65 74 20 69 66 | 20 79 6f 75 20 77 61 6e |u.net if| you wan|
|00000360| 74 20 74 68 61 74 20 74 | 6f 6f 6c 2e 0a 23 20 43 |t that t|ool..# C|
|00000370| 6f 6e 74 65 6e 74 73 3a | 20 20 43 68 61 6e 67 65 |ontents:|  Change|
|00000380| 73 20 44 65 62 75 67 67 | 69 6e 67 20 48 69 6e 74 |s Debugg|ing Hint|
|00000390| 73 20 4d 61 6b 65 66 69 | 6c 65 20 52 65 61 64 6d |s Makefi|le Readm|
|000003a0| 65 20 52 6f 77 5f 63 61 | 63 68 65 20 64 65 62 75 |e Row_ca|che debu|
|000003b0| 67 2e 63 0a 23 20 20 20 | 64 6f 63 2f 6f 72 61 70 |g.c.#   |doc/orap|
|000003c0| 65 72 6c 2e 72 65 66 20 | 65 78 61 6d 70 6c 65 73 |erl.ref |examples|
|000003d0| 2f 63 6f 6d 6d 69 74 2e | 70 6c 20 65 78 61 6d 70 |/commit.|pl examp|
|000003e0| 6c 65 73 2f 6d 6b 64 62 | 2e 70 6c 0a 23 20 20 20 |les/mkdb|.pl.#   |
|000003f0| 65 78 61 6d 70 6c 65 73 | 2f 6f 72 61 64 75 6d 70 |examples|/oradump|
|00000400| 2e 70 6c 20 65 78 61 6d | 70 6c 65 73 2f 73 71 6c |.pl exam|ples/sql|
|00000410| 20 69 6e 73 74 61 6c 6c | 2e 70 6c 20 6f 72 61 66 | install|.pl oraf|
|00000420| 6e 73 2e 68 20 73 74 72 | 74 6f 75 6c 2e 63 0a 23 |ns.h str|toul.c.#|
|00000430| 20 20 20 74 65 73 74 64 | 69 72 2f 63 6f 6d 6d 69 |   testd|ir/commi|
|00000440| 74 2e 70 6c 20 74 65 73 | 74 64 69 72 2f 6d 6b 64 |t.pl tes|tdir/mkd|
|00000450| 62 2e 70 6c 20 75 73 65 | 72 73 75 62 2e 63 0a 23 |b.pl use|rsub.c.#|
|00000460| 20 57 72 61 70 70 65 64 | 20 62 79 20 6b 65 6e 74 | Wrapped| by kent|
|00000470| 40 73 70 61 72 6b 79 20 | 6f 6e 20 4d 6f 6e 20 4a |@sparky |on Mon J|
|00000480| 75 6e 20 32 39 20 31 33 | 3a 32 33 3a 33 38 20 31 |un 29 13|:23:38 1|
|00000490| 39 39 32 0a 50 41 54 48 | 3d 2f 62 69 6e 3a 2f 75 |992.PATH|=/bin:/u|
|000004a0| 73 72 2f 62 69 6e 3a 2f | 75 73 72 2f 75 63 62 20 |sr/bin:/|usr/ucb |
|000004b0| 3b 20 65 78 70 6f 72 74 | 20 50 41 54 48 0a 65 63 |; export| PATH.ec|
|000004c0| 68 6f 20 49 66 20 74 68 | 69 73 20 61 72 63 68 69 |ho If th|is archi|
|000004d0| 76 65 20 69 73 20 63 6f | 6d 70 6c 65 74 65 2c 20 |ve is co|mplete, |
|000004e0| 79 6f 75 20 77 69 6c 6c | 20 73 65 65 20 74 68 65 |you will| see the|
|000004f0| 20 66 6f 6c 6c 6f 77 69 | 6e 67 20 6d 65 73 73 61 | followi|ng messa|
|00000500| 67 65 3a 0a 65 63 68 6f | 20 27 20 20 20 20 20 20 |ge:.echo| '      |
|00000510| 20 20 20 20 22 73 68 61 | 72 3a 20 45 6e 64 20 6f |    "sha|r: End o|
|00000520| 66 20 61 72 63 68 69 76 | 65 20 34 20 28 6f 66 20 |f archiv|e 4 (of |
|00000530| 35 29 2e 22 27 0a 69 66 | 20 74 65 73 74 20 2d 66 |5)."'.if| test -f|
|00000540| 20 27 43 68 61 6e 67 65 | 73 27 20 2d 61 20 22 24 | 'Change|s' -a "$|
|00000550| 7b 31 7d 22 20 21 3d 20 | 22 2d 63 22 20 3b 20 74 |{1}" != |"-c" ; t|
|00000560| 68 65 6e 20 0a 20 20 65 | 63 68 6f 20 73 68 61 72 |hen .  e|cho shar|
|00000570| 3a 20 57 69 6c 6c 20 6e | 6f 74 20 63 6c 6f 62 62 |: Will n|ot clobb|
|00000580| 65 72 20 65 78 69 73 74 | 69 6e 67 20 66 69 6c 65 |er exist|ing file|
|00000590| 20 5c 22 27 43 68 61 6e | 67 65 73 27 5c 22 0a 65 | \"'Chan|ges'\".e|
|000005a0| 6c 73 65 0a 20 20 65 63 | 68 6f 20 73 68 61 72 3a |lse.  ec|ho shar:|
|000005b0| 20 45 78 74 72 61 63 74 | 69 6e 67 20 5c 22 27 43 | Extract|ing \"'C|
|000005c0| 68 61 6e 67 65 73 27 5c | 22 20 5c 28 32 39 30 32 |hanges'\|" \(2902|
|000005d0| 20 63 68 61 72 61 63 74 | 65 72 73 5c 29 0a 20 20 | charact|ers\).  |
|000005e0| 73 65 64 20 22 73 2f 5e | 58 2f 2f 22 20 3e 27 43 |sed "s/^|X//" >'C|
|000005f0| 68 61 6e 67 65 73 27 20 | 3c 3c 27 45 4e 44 5f 4f |hanges' |<<'END_O|
|00000600| 46 5f 46 49 4c 45 27 0a | 58 43 68 61 6e 67 65 73 |F_FILE'.|XChanges|
|00000610| 20 74 6f 20 74 68 65 20 | 4f 72 61 70 65 72 6c 20 | to the |Oraperl |
|00000620| 70 61 63 6b 61 67 65 2e | 0a 58 0a 58 0a 58 56 65 |package.|.X.X.XVe|
|00000630| 72 73 69 6f 6e 20 32 0a | 58 3d 3d 3d 3d 3d 3d 3d |rsion 2.|X=======|
|00000640| 3d 3d 0a 58 0a 58 50 61 | 74 63 68 6c 65 76 65 6c |==.X.XPa|tchlevel|
|00000650| 20 30 3a 0a 58 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d | 0:.X===|========|
|00000660| 3d 3d 0a 58 52 65 70 6c | 61 63 65 64 20 6d 79 20 |==.XRepl|aced my |
|00000670| 64 65 62 75 67 67 69 6e | 67 20 63 6f 64 65 20 77 |debuggin|g code w|
|00000680| 69 74 68 20 46 72 65 64 | 20 46 69 73 68 27 20 44 |ith Fred| Fish' D|
|00000690| 42 55 47 20 70 61 63 6b | 61 67 65 0a 58 41 64 64 |BUG pack|age.XAdd|
|000006a0| 65 64 20 66 65 74 63 68 | 65 64 20 72 6f 77 20 63 |ed fetch|ed row c|
|000006b0| 61 63 68 69 6e 67 20 28 | 24 6f 72 61 5f 63 61 63 |aching (|$ora_cac|
|000006c0| 68 65 20 76 61 72 69 61 | 62 6c 65 2c 20 26 6f 72 |he varia|ble, &or|
|000006d0| 61 5f 6f 70 65 6e 20 74 | 68 69 72 64 20 70 61 72 |a_open t|hird par|
|000006e0| 61 6d 65 74 65 72 29 0a | 58 41 64 64 65 64 20 74 |ameter).|XAdded t|
|000006f0| 68 65 20 26 6f 72 61 5f | 6c 65 6e 67 74 68 73 20 |he &ora_|lengths |
|00000700| 66 75 6e 63 74 69 6f 6e | 0a 58 41 64 64 65 64 20 |function|.XAdded |
|00000710| 74 68 65 20 26 6f 72 61 | 5f 74 79 70 65 73 20 66 |the &ora|_types f|
|00000720| 75 6e 63 74 69 6f 6e 0a | 58 41 64 64 65 64 20 74 |unction.|XAdded t|
|00000730| 68 65 20 26 6f 72 61 5f | 61 75 74 6f 63 6f 6d 6d |he &ora_|autocomm|
|00000740| 69 74 20 66 75 6e 63 74 | 69 6f 6e 0a 58 41 64 64 |it funct|ion.XAdd|
|00000750| 65 64 20 74 68 65 20 24 | 6f 72 61 5f 76 65 72 6e |ed the $|ora_vern|
|00000760| 6f 20 76 61 72 69 61 62 | 6c 65 0a 58 41 64 64 65 |o variab|le.XAdde|
|00000770| 64 20 73 6f 6d 65 20 73 | 75 70 70 6f 72 74 20 66 |d some s|upport f|
|00000780| 6f 72 20 4c 4f 4e 47 20 | 61 6e 64 20 4c 4f 4e 47 |or LONG |and LONG|
|00000790| 52 41 57 20 64 61 74 61 | 20 74 79 70 65 73 20 28 |RAW data| types (|
|000007a0| 24 6f 72 61 5f 6c 6f 6e | 67 2c 20 24 6f 72 61 5f |$ora_lon|g, $ora_|
|000007b0| 74 72 75 6e 63 29 0a 58 | 41 64 64 65 64 20 61 20 |trunc).X|Added a |
|000007c0| 77 61 72 6e 69 6e 67 20 | 28 77 69 74 68 20 2d 77 |warning |(with -w|
|000007d0| 29 20 6f 6e 20 75 73 65 | 20 6f 66 20 24 6f 72 61 |) on use| of $ora|
|000007e0| 5f 64 65 62 75 67 20 69 | 66 20 64 65 62 75 67 67 |_debug i|f debugg|
|000007f0| 69 6e 67 20 69 73 20 6e | 6f 74 20 61 76 61 69 6c |ing is n|ot avail|
|00000800| 61 62 6c 65 0a 58 41 64 | 64 65 64 20 74 61 72 67 |able.XAd|ded targ|
|00000810| 65 74 73 20 22 74 65 73 | 74 22 20 61 6e 64 20 22 |ets "tes|t" and "|
|00000820| 69 6e 73 74 61 6c 6c 22 | 20 74 6f 20 74 68 65 20 |install"| to the |
|00000830| 4d 61 6b 65 66 69 6c 65 | 0a 58 43 68 61 6e 67 65 |Makefile|.XChange|
|00000840| 64 20 6f 72 61 5f 6c 6f | 67 69 6e 28 29 20 74 6f |d ora_lo|gin() to|
|00000850| 20 75 73 65 20 24 4f 52 | 41 43 4c 45 5f 53 49 44 | use $OR|ACLE_SID|
|00000860| 20 69 66 20 74 68 65 20 | 66 69 72 73 74 20 70 61 | if the |first pa|
|00000870| 72 61 6d 65 74 65 72 20 | 69 73 20 65 6d 70 74 79 |rameter |is empty|
|00000880| 0a 58 43 68 61 6e 67 65 | 64 20 6f 72 61 5f 6c 6f |.XChange|d ora_lo|
|00000890| 67 69 6e 28 29 20 74 6f | 20 75 73 65 20 50 65 72 |gin() to| use Per|
|000008a0| 6c 27 73 20 6d 79 5f 73 | 65 74 65 6e 76 20 66 75 |l's my_s|etenv fu|
|000008b0| 6e 63 74 69 6f 6e 0a 58 | 43 68 61 6e 67 65 64 20 |nction.X|Changed |
|000008c0| 6f 72 61 5f 62 69 6e 64 | 28 29 20 74 6f 20 70 61 |ora_bind|() to pa|
|000008d0| 64 20 73 68 6f 72 74 20 | 76 61 72 69 61 62 6c 65 |d short |variable|
|000008e0| 73 0a 58 43 68 61 6e 67 | 65 64 20 6f 72 61 5f 76 |s.XChang|ed ora_v|
|000008f0| 65 72 73 69 6f 6e 28 29 | 20 74 6f 20 72 65 70 6f |ersion()| to repo|
|00000900| 72 74 20 63 6f 6d 70 69 | 6c 65 2d 74 69 6d 65 20 |rt compi|le-time |
|00000910| 6f 70 74 69 6f 6e 73 0a | 58 43 68 61 6e 67 65 64 |options.|XChanged|
|00000920| 20 73 65 74 5f 73 69 64 | 28 29 20 74 6f 20 75 73 | set_sid|() to us|
|00000930| 65 20 50 65 72 6c 27 73 | 20 6d 79 5f 73 65 74 65 |e Perl's| my_sete|
|00000940| 6e 76 28 29 20 66 75 6e | 63 74 69 6f 6e 0a 58 46 |nv() fun|ction.XF|
|00000950| 69 78 65 64 20 61 20 62 | 75 67 20 69 6e 20 6f 72 |ixed a b|ug in or|
|00000960| 61 5f 6f 70 65 6e 28 29 | 20 77 68 65 72 65 20 61 |a_open()| where a|
|00000970| 20 63 75 72 73 6f 72 20 | 77 61 73 20 6e 6f 74 20 | cursor |was not |
|00000980| 72 65 6c 65 61 73 65 64 | 20 69 66 20 6f 6f 70 65 |released| if oope|
|00000990| 6e 20 66 61 69 6c 65 64 | 0a 58 46 69 78 65 64 20 |n failed|.XFixed |
|000009a0| 61 20 62 75 67 20 69 6e | 20 67 65 74 63 75 72 73 |a bug in| getcurs|
|000009b0| 6f 72 28 29 2c 20 77 68 | 69 63 68 20 77 61 73 6e |or(), wh|ich wasn|
|000009c0| 27 74 20 69 6e 69 74 69 | 61 6c 69 73 69 6e 67 20 |'t initi|alising |
|000009d0| 61 6c 6c 20 66 69 65 6c | 64 73 0a 58 46 69 78 65 |all fiel|ds.XFixe|
|000009e0| 64 20 61 20 62 75 67 20 | 69 6e 20 64 72 6f 70 63 |d a bug |in dropc|
|000009f0| 75 72 73 6f 72 28 29 2c | 20 77 68 69 63 68 20 77 |ursor(),| which w|
|00000a00| 61 73 6e 27 74 20 64 72 | 6f 70 70 69 6e 67 20 61 |asn't dr|opping a|
|00000a10| 6c 6c 20 66 69 65 6c 64 | 73 0a 58 4d 65 72 67 65 |ll field|s.XMerge|
|00000a20| 64 20 74 68 65 20 4f 72 | 61 63 6c 65 2d 76 35 20 |d the Or|acle-v5 |
|00000a30| 66 69 6c 65 20 69 6e 74 | 6f 20 74 68 65 20 48 69 |file int|o the Hi|
|00000a40| 6e 74 73 20 66 69 6c 65 | 0a 58 52 65 6f 72 67 61 |nts file|.XReorga|
|00000a50| 6e 69 73 65 64 20 74 68 | 65 20 66 69 6c 65 73 20 |nised th|e files |
|00000a60| 69 6e 74 6f 20 73 75 62 | 64 69 72 65 63 74 6f 72 |into sub|director|
|00000a70| 69 65 73 0a 58 52 65 77 | 72 6f 74 65 20 74 68 65 |ies.XRew|rote the|
|00000a80| 20 64 6f 63 75 6d 65 6e | 74 61 74 69 6f 6e 0a 58 | documen|tation.X|
|00000a90| 0a 58 0a 58 56 65 72 73 | 69 6f 6e 20 31 3a 0a 58 |.X.XVers|ion 1:.X|
|00000aa0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 0a 58 0a 58 50 61 |========|==.X.XPa|
|00000ab0| 74 63 68 20 30 35 0a 58 | 3d 3d 3d 3d 3d 3d 3d 3d |tch 05.X|========|
|00000ac0| 0a 58 41 64 64 65 64 20 | 66 75 6e 63 74 69 6f 6e |.XAdded |function|
|00000ad0| 73 20 66 6f 72 20 63 6f | 6d 6d 69 74 20 61 6e 64 |s for co|mmit and|
|00000ae0| 20 72 6f 6c 6c 62 61 63 | 6b 2c 20 70 6c 75 73 20 | rollbac|k, plus |
|00000af0| 63 6f 6d 6d 69 74 2e 70 | 6c 20 74 6f 20 64 65 6d |commit.p|l to dem|
|00000b00| 6f 6e 73 74 72 61 74 65 | 20 74 68 65 6d 0a 58 41 |onstrate| them.XA|
|00000b10| 64 64 65 64 20 61 20 66 | 75 6e 63 74 69 6f 6e 20 |dded a f|unction |
|00000b20| 74 6f 20 67 65 74 20 74 | 68 65 20 63 6f 6c 75 6d |to get t|he colum|
|00000b30| 6e 20 74 69 74 6c 65 73 | 2c 20 6d 6f 64 69 66 69 |n titles|, modifi|
|00000b40| 65 64 20 73 71 6c 20 63 | 6f 6d 6d 61 6e 64 20 74 |ed sql c|ommand t|
|00000b50| 6f 20 75 73 65 20 69 74 | 0a 58 41 64 64 65 64 20 |o use it|.XAdded |
|00000b60| 74 68 65 20 62 69 6e 64 | 2e 70 6c 20 73 63 72 69 |the bind|.pl scri|
|00000b70| 70 74 0a 58 49 6d 70 72 | 6f 76 65 64 20 65 72 72 |pt.XImpr|oved err|
|00000b80| 6f 72 20 68 61 6e 64 6c | 69 6e 67 20 66 6f 72 20 |or handl|ing for |
|00000b90| 6f 72 61 5f 63 6c 6f 73 | 65 20 61 6e 64 20 6f 72 |ora_clos|e and or|
|00000ba0| 61 5f 6c 6f 67 6f 66 66 | 0a 58 0a 58 50 61 74 63 |a_logoff|.X.XPatc|
|00000bb0| 68 20 30 34 0a 58 3d 3d | 3d 3d 3d 3d 3d 3d 0a 58 |h 04.X==|======.X|
|00000bc0| 41 64 64 65 64 20 22 63 | 6f 72 61 70 65 72 6c 22 |Added "c|oraperl"|
|00000bd0| 20 2d 20 50 65 72 6c 20 | 77 69 74 68 20 4f 72 61 | - Perl |with Ora|
|00000be0| 63 6c 65 20 61 6e 64 20 | 43 75 72 73 65 73 0a 58 |cle and |Curses.X|
|00000bf0| 4d 6f 64 69 66 69 65 64 | 20 6d 6b 64 62 2e 70 6c |Modified| mkdb.pl|
|00000c00| 20 74 6f 20 75 73 65 20 | 74 68 65 20 63 75 72 73 | to use |the curs|
|00000c10| 65 73 20 66 75 6e 63 74 | 69 6f 6e 73 20 69 66 20 |es funct|ions if |
|00000c20| 74 68 65 79 27 72 65 20 | 61 76 61 69 6c 61 62 6c |they're |availabl|
|00000c30| 65 0a 58 41 64 64 65 64 | 20 73 71 6c 2c 20 61 20 |e.XAdded| sql, a |
|00000c40| 73 63 72 69 70 74 20 77 | 68 69 63 68 20 65 78 65 |script w|hich exe|
|00000c50| 63 75 74 65 73 20 53 51 | 4c 20 73 74 61 74 65 6d |cutes SQ|L statem|
|00000c60| 65 6e 74 73 20 66 72 6f | 6d 20 74 68 65 20 63 6f |ents fro|m the co|
|00000c70| 6d 6d 61 6e 64 20 6c 69 | 6e 65 0a 58 41 64 64 65 |mmand li|ne.XAdde|
|00000c80| 64 20 61 20 6e 6f 74 65 | 20 61 62 6f 75 74 20 64 |d a note| about d|
|00000c90| 75 61 6c 2d 75 6e 69 76 | 65 72 73 65 20 6d 61 63 |ual-univ|erse mac|
|00000ca0| 68 69 6e 65 73 20 74 6f | 20 74 68 65 20 48 69 6e |hines to| the Hin|
|00000cb0| 74 73 20 66 69 6c 65 0a | 58 41 64 64 65 64 20 61 |ts file.|XAdded a|
|00000cc0| 20 73 74 72 74 6f 75 6c | 28 29 20 66 75 6e 63 74 | strtoul|() funct|
|00000cd0| 69 6f 6e 0a 58 53 65 70 | 61 72 61 74 65 64 20 74 |ion.XSep|arated t|
|00000ce0| 68 65 20 63 6c 65 61 6e | 20 61 6e 64 20 72 65 61 |he clean| and rea|
|00000cf0| 6c 63 6c 65 61 6e 2f 63 | 6c 6f 62 62 65 72 20 74 |lclean/c|lobber t|
|00000d00| 61 72 67 65 74 73 0a 58 | 43 6c 65 61 6e 65 64 20 |argets.X|Cleaned |
|00000d10| 75 70 20 61 20 66 65 77 | 20 62 69 74 73 20 61 6e |up a few| bits an|
|00000d20| 64 20 70 69 65 63 65 73 | 20 2d 20 73 68 6f 75 6c |d pieces| - shoul|
|00000d30| 64 6e 27 74 20 6d 61 6b | 65 20 61 6e 79 20 64 69 |dn't mak|e any di|
|00000d40| 66 66 65 72 65 6e 63 65 | 0a 58 0a 58 50 61 74 63 |fference|.X.XPatc|
|00000d50| 68 20 30 33 0a 58 3d 3d | 3d 3d 3d 3d 3d 3d 0a 58 |h 03.X==|======.X|
|00000d60| 46 69 78 65 64 20 61 20 | 62 75 67 20 69 6e 20 61 |Fixed a |bug in a|
|00000d70| 6c 6c 6f 63 61 74 69 6e | 67 20 74 68 65 20 64 61 |llocatin|g the da|
|00000d80| 74 61 20 62 75 66 66 65 | 72 73 2c 20 6e 6f 74 61 |ta buffe|rs, nota|
|00000d90| 62 6c 79 20 61 66 66 65 | 63 74 69 6e 67 20 44 41 |bly affe|cting DA|
|00000da0| 54 45 20 66 69 65 6c 64 | 73 0a 58 46 69 78 65 64 |TE field|s.XFixed|
|00000db0| 20 61 20 62 75 67 20 69 | 6e 20 6e 6f 74 20 66 72 | a bug i|n not fr|
|00000dc0| 65 65 69 6e 67 20 74 68 | 65 20 73 70 61 63 65 20 |eeing th|e space |
|00000dd0| 66 6f 72 20 6f 72 61 5f | 62 69 6e 64 20 70 61 72 |for ora_|bind par|
|00000de0| 61 6d 65 74 65 72 73 0a | 58 46 69 78 65 64 20 61 |ameters.|XFixed a|
|00000df0| 20 62 75 67 20 69 6e 20 | 63 72 65 61 74 69 6e 67 | bug in |creating|
|00000e00| 20 61 20 22 64 65 62 75 | 67 22 20 76 61 72 69 61 | a "debu|g" varia|
|00000e10| 62 6c 65 20 77 68 65 6e | 20 69 74 20 77 61 73 6e |ble when| it wasn|
|00000e20| 27 74 20 6e 65 65 64 65 | 64 0a 58 49 6d 70 72 6f |'t neede|d.XImpro|
|00000e30| 76 65 64 20 64 65 62 75 | 67 67 69 6e 67 20 6f 75 |ved debu|gging ou|
|00000e40| 74 70 75 74 2c 20 61 64 | 64 65 64 20 73 75 70 70 |tput, ad|ded supp|
|00000e50| 6f 72 74 20 66 6f 72 20 | 66 6c 61 67 20 33 32 20 |ort for |flag 32 |
|00000e60| 28 73 74 72 69 6e 67 2f | 6e 75 6d 65 72 69 63 20 |(string/|numeric |
|00000e70| 63 6f 6e 76 65 72 73 69 | 6f 6e 29 0a 58 49 6d 70 |conversi|on).XImp|
|00000e80| 72 6f 76 65 64 20 68 61 | 6e 64 6c 69 6e 67 20 6f |roved ha|ndling o|
|00000e90| 66 20 24 6f 72 61 5f 65 | 72 72 73 74 72 0a 58 41 |f $ora_e|rrstr.XA|
|00000ea0| 64 64 65 64 20 63 6f 6e | 66 69 67 75 72 61 74 69 |dded con|figurati|
|00000eb0| 6f 6e 20 66 6c 61 67 73 | 20 66 6f 72 20 76 61 72 |on flags| for var|
|00000ec0| 69 6f 75 73 20 74 68 69 | 6e 67 73 20 74 6f 20 74 |ious thi|ngs to t|
|00000ed0| 68 65 20 4d 61 6b 65 66 | 69 6c 65 0a 58 41 64 64 |he Makef|ile.XAdd|
|00000ee0| 65 64 20 74 61 72 67 65 | 74 73 20 6c 69 73 74 69 |ed targe|ts listi|
|00000ef0| 6e 67 20 61 6e 64 20 64 | 6f 63 73 20 74 6f 20 74 |ng and d|ocs to t|
|00000f00| 68 65 20 4d 61 6b 65 66 | 69 6c 65 0a 58 41 64 64 |he Makef|ile.XAdd|
|00000f10| 65 64 20 74 68 65 20 26 | 6f 72 61 5f 76 65 72 73 |ed the &|ora_vers|
|00000f20| 69 6f 6e 28 29 20 66 75 | 6e 63 74 69 6f 6e 2c 20 |ion() fu|nction, |
|00000f30| 61 6e 61 6c 6f 67 6f 75 | 73 20 74 6f 20 50 65 72 |analogou|s to Per|
|00000f40| 6c 27 73 20 2d 76 20 66 | 6c 61 67 2e 0a 58 41 64 |l's -v f|lag..XAd|
|00000f50| 64 65 64 20 74 68 65 20 | 26 6f 72 61 5f 64 6f 28 |ded the |&ora_do(|
|00000f60| 29 20 66 75 6e 63 74 69 | 6f 6e 2c 20 65 71 75 69 |) functi|on, equi|
|00000f70| 76 61 6c 65 6e 74 20 74 | 6f 20 26 6f 72 61 5f 63 |valent t|o &ora_c|
|00000f80| 6c 6f 73 65 28 26 6f 72 | 61 5f 6f 70 65 6e 28 2e |lose(&or|a_open(.|
|00000f90| 2e 2e 29 29 0a 58 41 64 | 64 65 64 20 68 61 6e 64 |..)).XAd|ded hand|
|00000fa0| 6c 69 6e 67 20 6f 66 20 | 4e 55 4c 4c 20 76 61 6c |ling of |NULL val|
|00000fb0| 75 65 73 20 72 65 74 75 | 72 6e 65 64 20 66 72 6f |ues retu|rned fro|
|00000fc0| 6d 20 74 68 65 20 64 61 | 74 61 62 61 73 65 0a 58 |m the da|tabase.X|
|00000fd0| 41 64 64 65 64 20 61 6e | 20 27 6f 72 61 70 65 72 |Added an| 'oraper|
|00000fe0| 6c 2e 70 68 27 20 66 69 | 6c 65 0a 58 0a 58 50 61 |l.ph' fi|le.X.XPa|
|00000ff0| 74 63 68 20 30 32 0a 58 | 3d 3d 3d 3d 3d 3d 3d 3d |tch 02.X|========|
|00001000| 0a 58 41 64 64 65 64 20 | 73 75 70 70 6f 72 74 20 |.XAdded |support |
|00001010| 66 6f 72 20 64 79 6e 61 | 6d 69 63 61 6c 6c 79 20 |for dyna|mically |
|00001020| 6d 6f 64 69 66 69 61 62 | 6c 65 20 53 51 4c 20 73 |modifiab|le SQL s|
|00001030| 74 61 74 65 6d 65 6e 74 | 73 0a 58 41 64 64 65 64 |tatement|s.XAdded|
|00001040| 20 61 20 48 69 6e 74 73 | 20 66 69 6c 65 0a 58 43 | a Hints| file.XC|
|00001050| 6f 72 72 65 63 74 65 64 | 20 61 6e 20 65 72 72 6f |orrected| an erro|
|00001060| 72 20 69 6e 20 74 68 65 | 20 71 75 69 63 6b 2d 72 |r in the| quick-r|
|00001070| 65 66 65 72 65 6e 63 65 | 20 73 68 65 65 74 0a 58 |eference| sheet.X|
|00001080| 0a 58 50 61 74 63 68 20 | 30 31 0a 58 3d 3d 3d 3d |.XPatch |01.X====|
|00001090| 3d 3d 3d 3d 0a 58 46 69 | 78 65 64 20 61 20 62 75 |====.XFi|xed a bu|
|000010a0| 67 20 69 6e 20 4d 61 6b | 65 66 69 6c 65 20 2d 20 |g in Mak|efile - |
|000010b0| 24 28 4c 49 42 53 29 20 | 77 61 73 20 6e 6f 74 20 |$(LIBS) |was not |
|000010c0| 75 73 65 64 0a 58 41 64 | 64 65 64 20 74 68 65 20 |used.XAd|ded the |
|000010d0| 66 69 6c 65 20 4f 72 61 | 63 6c 65 2d 76 35 20 2d |file Ora|cle-v5 -|
|000010e0| 20 68 69 6e 74 73 20 66 | 6f 72 20 62 75 69 6c 64 | hints f|or build|
|000010f0| 69 6e 67 20 75 6e 64 65 | 72 20 4f 72 61 63 6c 65 |ing unde|r Oracle|
|00001100| 20 76 35 0a 58 43 68 61 | 6e 67 65 64 20 63 6f 70 | v5.XCha|nged cop|
|00001110| 79 72 69 67 68 74 20 6e | 6f 74 69 63 65 73 20 74 |yright n|otices t|
|00001120| 6f 20 61 6c 6c 6f 77 20 | 63 6f 70 79 69 6e 67 20 |o allow |copying |
|00001130| 75 6e 64 65 72 20 4c 61 | 72 72 79 27 73 20 41 72 |under La|rry's Ar|
|00001140| 74 69 73 74 69 63 20 4c | 69 63 65 6e 73 65 0a 58 |tistic L|icense.X|
|00001150| 41 64 64 65 64 20 6e 65 | 74 77 6f 72 6b 20 61 64 |Added ne|twork ad|
|00001160| 64 72 65 73 73 65 73 20 | 74 6f 20 74 68 65 20 6d |dresses |to the m|
|00001170| 61 6e 75 61 6c 20 70 61 | 67 65 73 0a 58 41 64 64 |anual pa|ges.XAdd|
|00001180| 65 64 20 61 20 50 41 54 | 43 48 4c 45 56 45 4c 20 |ed a PAT|CHLEVEL |
|00001190| 66 69 6c 65 0a 58 4e 6f | 20 66 75 6e 63 74 69 6f |file.XNo| functio|
|000011a0| 6e 61 6c 20 63 68 61 6e | 67 65 73 0a 45 4e 44 5f |nal chan|ges.END_|
|000011b0| 4f 46 5f 46 49 4c 45 0a | 20 20 69 66 20 74 65 73 |OF_FILE.|  if tes|
|000011c0| 74 20 32 39 30 32 20 2d | 6e 65 20 60 77 63 20 2d |t 2902 -|ne `wc -|
|000011d0| 63 20 3c 27 43 68 61 6e | 67 65 73 27 60 3b 20 74 |c <'Chan|ges'`; t|
|000011e0| 68 65 6e 0a 20 20 20 20 | 65 63 68 6f 20 73 68 61 |hen.    |echo sha|
|000011f0| 72 3a 20 5c 22 27 43 68 | 61 6e 67 65 73 27 5c 22 |r: \"'Ch|anges'\"|
|00001200| 20 75 6e 70 61 63 6b 65 | 64 20 77 69 74 68 20 77 | unpacke|d with w|
|00001210| 72 6f 6e 67 20 73 69 7a | 65 21 0a 20 20 66 69 0a |rong siz|e!.  fi.|
|00001220| 20 20 23 20 65 6e 64 20 | 6f 66 20 27 43 68 61 6e |  # end |of 'Chan|
|00001230| 67 65 73 27 0a 66 69 0a | 69 66 20 74 65 73 74 20 |ges'.fi.|if test |
|00001240| 2d 66 20 27 44 65 62 75 | 67 67 69 6e 67 27 20 2d |-f 'Debu|gging' -|
|00001250| 61 20 22 24 7b 31 7d 22 | 20 21 3d 20 22 2d 63 22 |a "${1}"| != "-c"|
|00001260| 20 3b 20 74 68 65 6e 20 | 0a 20 20 65 63 68 6f 20 | ; then |.  echo |
|00001270| 73 68 61 72 3a 20 57 69 | 6c 6c 20 6e 6f 74 20 63 |shar: Wi|ll not c|
|00001280| 6c 6f 62 62 65 72 20 65 | 78 69 73 74 69 6e 67 20 |lobber e|xisting |
|00001290| 66 69 6c 65 20 5c 22 27 | 44 65 62 75 67 67 69 6e |file \"'|Debuggin|
|000012a0| 67 27 5c 22 0a 65 6c 73 | 65 0a 20 20 65 63 68 6f |g'\".els|e.  echo|
|000012b0| 20 73 68 61 72 3a 20 45 | 78 74 72 61 63 74 69 6e | shar: E|xtractin|
|000012c0| 67 20 5c 22 27 44 65 62 | 75 67 67 69 6e 67 27 5c |g \"'Deb|ugging'\|
|000012d0| 22 20 5c 28 33 31 35 34 | 20 63 68 61 72 61 63 74 |" \(3154| charact|
|000012e0| 65 72 73 5c 29 0a 20 20 | 73 65 64 20 22 73 2f 5e |ers\).  |sed "s/^|
|000012f0| 58 2f 2f 22 20 3e 27 44 | 65 62 75 67 67 69 6e 67 |X//" >'D|ebugging|
|00001300| 27 20 3c 3c 27 45 4e 44 | 5f 4f 46 5f 46 49 4c 45 |' <<'END|_OF_FILE|
|00001310| 27 0a 58 0a 58 53 74 61 | 72 74 69 6e 67 20 77 69 |'.X.XSta|rting wi|
|00001320| 74 68 20 76 65 72 73 69 | 6f 6e 20 32 2c 20 4f 72 |th versi|on 2, Or|
|00001330| 61 70 65 72 6c 20 69 6e | 63 6f 72 70 6f 72 61 74 |aperl in|corporat|
|00001340| 65 73 20 46 72 65 64 20 | 46 69 73 68 27 20 65 78 |es Fred |Fish' ex|
|00001350| 63 65 6c 6c 65 6e 74 0a | 58 64 65 62 75 67 67 69 |cellent.|Xdebuggi|
|00001360| 6e 67 20 70 61 63 6b 61 | 67 65 2c 20 44 42 55 47 |ng packa|ge, DBUG|
|00001370| 2e 20 54 68 65 20 65 6e | 74 69 72 65 20 70 61 63 |. The en|tire pac|
|00001380| 6b 61 67 65 20 28 69 6e | 63 6c 75 64 69 6e 67 20 |kage (in|cluding |
|00001390| 64 6f 63 75 6d 65 6e 74 | 61 74 69 6f 6e 29 0a 58 |document|ation).X|
|000013a0| 69 73 20 69 6e 63 6c 75 | 64 65 64 20 69 6e 20 74 |is inclu|ded in t|
|000013b0| 68 65 20 64 62 75 67 2f | 20 73 75 62 64 69 72 65 |he dbug/| subdire|
|000013c0| 63 74 6f 72 79 2c 20 73 | 6f 20 79 6f 75 20 63 61 |ctory, s|o you ca|
|000013d0| 6e 20 69 6e 73 74 61 6c | 6c 20 69 74 20 73 65 70 |n instal|l it sep|
|000013e0| 61 72 61 74 65 6c 79 0a | 58 74 6f 20 75 73 65 20 |arately.|Xto use |
|000013f0| 77 69 74 68 20 6f 74 68 | 65 72 20 70 72 6f 67 72 |with oth|er progr|
|00001400| 61 6d 73 2e 20 44 42 55 | 47 20 69 73 20 69 6e 20 |ams. DBU|G is in |
|00001410| 74 68 65 20 70 75 62 6c | 69 63 20 64 6f 6d 61 69 |the publ|ic domai|
|00001420| 6e 2e 0a 58 0a 58 52 65 | 61 64 20 64 62 75 67 2f |n..X.XRe|ad dbug/|
|00001430| 64 62 75 67 2e 70 20 66 | 6f 72 20 66 75 6c 6c 20 |dbug.p f|or full |
|00001440| 64 65 74 61 69 6c 73 20 | 6f 6e 20 74 68 65 20 70 |details |on the p|
|00001450| 61 63 6b 61 67 65 2c 20 | 62 75 74 20 62 72 69 65 |ackage, |but brie|
|00001460| 66 6c 79 20 79 6f 75 20 | 6e 65 65 64 0a 58 74 6f |fly you |need.Xto|
|00001470| 20 61 73 73 69 67 6e 20 | 64 65 62 75 67 67 69 6e | assign |debuggin|
|00001480| 67 20 63 6f 6e 74 72 6f | 6c 20 73 74 72 69 6e 67 |g contro|l string|
|00001490| 73 20 74 6f 20 24 6f 72 | 61 5f 64 65 62 75 67 20 |s to $or|a_debug |
|000014a0| 74 6f 20 69 6e 64 69 63 | 61 74 65 20 74 68 65 20 |to indic|ate the |
|000014b0| 6c 65 76 65 6c 0a 58 6f | 66 20 64 65 62 75 67 67 |level.Xo|f debugg|
|000014c0| 69 6e 67 20 72 65 71 75 | 69 72 65 64 2e 20 41 20 |ing requ|ired. A |
|000014d0| 6c 69 73 74 20 6f 66 20 | 74 68 65 20 64 65 62 75 |list of |the debu|
|000014e0| 67 67 69 6e 67 20 63 6f | 6e 74 72 6f 6c 73 20 69 |gging co|ntrols i|
|000014f0| 73 20 6f 6e 20 70 61 67 | 65 73 20 31 38 0a 58 61 |s on pag|es 18.Xa|
|00001500| 6e 64 20 31 39 20 6f 66 | 20 74 68 65 20 64 6f 63 |nd 19 of| the doc|
|00001510| 75 6d 65 6e 74 61 74 69 | 6f 6e 2e 20 46 6f 72 20 |umentati|on. For |
|00001520| 65 78 61 6d 70 6c 65 2c | 20 69 66 20 79 6f 75 20 |example,| if you |
|00001530| 77 61 6e 74 20 74 6f 20 | 74 72 61 63 65 20 61 6c |want to |trace al|
|00001540| 6c 6f 63 61 74 69 6f 6e | 0a 58 61 6e 64 20 66 72 |location|.Xand fr|
|00001550| 65 65 69 6e 67 20 6f 66 | 20 6d 65 6d 6f 72 79 20 |eeing of| memory |
|00001560| 69 6e 20 74 68 65 20 66 | 75 6e 63 74 69 6f 6e 73 |in the f|unctions|
|00001570| 20 6f 72 61 5f 6f 70 65 | 6e 20 61 6e 64 20 6f 72 | ora_ope|n and or|
|00001580| 61 5f 63 6c 6f 73 65 2c | 20 77 72 69 74 69 6e 67 |a_close,| writing|
|00001590| 0a 58 74 68 65 20 6f 75 | 74 70 75 74 20 74 6f 20 |.Xthe ou|tput to |
|000015a0| 61 20 66 69 6c 65 20 63 | 61 6c 6c 65 64 20 74 72 |a file c|alled tr|
|000015b0| 61 63 65 2c 20 6e 75 6d | 62 65 72 69 6e 67 20 74 |ace, num|bering t|
|000015c0| 68 65 20 6c 69 6e 65 73 | 2c 20 79 6f 75 20 63 6f |he lines|, you co|
|000015d0| 75 6c 64 20 73 61 79 3a | 0a 58 0a 58 20 20 20 20 |uld say:|.X.X    |
|000015e0| 20 20 20 20 20 24 6f 72 | 61 5f 64 65 62 75 67 20 |     $or|a_debug |
|000015f0| 3d 20 27 64 2c 6d 61 6c | 6c 6f 63 2c 66 72 65 65 |= 'd,mal|loc,free|
|00001600| 3a 66 2c 6f 72 61 5f 6f | 70 65 6e 2c 6f 72 61 5f |:f,ora_o|pen,ora_|
|00001610| 63 6c 6f 73 65 3a 6f 2c | 74 72 61 63 65 3a 4e 27 |close:o,|trace:N'|
|00001620| 3b 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |;.X     |        |
|00001630| 20 20 20 20 20 20 20 20 | 20 20 5e 20 20 20 20 20 |        |  ^     |
|00001640| 20 20 20 20 20 20 20 20 | 5e 20 20 20 20 20 20 20 |        |^       |
|00001650| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 5e 20 20 |        |     ^  |
|00001660| 20 20 20 20 20 5e 0a 58 | 20 20 20 20 20 20 20 20 |     ^.X|        |
|00001670| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 7c |        |       ||
|00001680| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 7c 20 20 |        |     |  |
|00001690| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000016a0| 20 20 7c 20 20 20 20 20 | 20 20 7c 0a 58 20 20 20 |  |     |  |.X   |
|000016b0| 20 64 65 62 75 67 67 69 | 6e 67 20 6b 65 79 73 20 | debuggi|ng keys |
|000016c0| 2d 2d 2d 2d 2b 20 20 20 | 20 20 20 20 20 20 20 20 |----+   |        |
|000016d0| 20 20 7c 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |  |     |        |
|000016e0| 20 20 20 20 20 20 20 7c | 20 20 20 20 20 20 20 7c |       ||       ||
|000016f0| 0a 58 20 20 20 20 66 75 | 6e 63 74 69 6f 6e 73 20 |.X    fu|nctions |
|00001700| 74 6f 20 62 65 20 74 72 | 61 63 65 64 20 2d 2d 2d |to be tr|aced ---|
|00001710| 2d 2d 2d 2d 2d 2d 2d 2b | 20 20 20 20 20 20 20 20 |-------+|        |
|00001720| 20 20 20 20 20 20 20 20 | 20 20 20 20 7c 20 20 20 |        |    |   |
|00001730| 20 20 20 20 7c 0a 58 20 | 20 20 20 77 68 65 72 65 |    |.X |   where|
|00001740| 20 74 6f 20 77 72 69 74 | 65 20 6f 75 74 70 75 74 | to writ|e output|
|00001750| 20 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d | -------|--------|
|00001760| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00001770| 2d 2b 20 20 20 20 20 20 | 20 7c 0a 58 20 20 20 20 |-+      | |.X    |
|00001780| 6e 75 6d 62 65 72 20 6f | 75 74 70 75 74 20 6c 69 |number o|utput li|
|00001790| 6e 65 73 20 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |nes ----|--------|
|000017a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000017b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2b 0a |--------|------+.|
|000017c0| 58 0a 58 54 68 65 20 64 | 65 62 75 67 67 69 6e 67 |X.XThe d|ebugging|
|000017d0| 20 6b 65 79 77 6f 72 64 | 73 20 28 66 6f 72 20 74 | keyword|s (for t|
|000017e0| 68 65 20 27 64 27 20 70 | 61 72 61 6d 65 74 65 72 |he 'd' p|arameter|
|000017f0| 29 20 75 73 65 64 20 61 | 72 65 20 74 68 65 20 66 |) used a|re the f|
|00001800| 6f 6c 6c 6f 77 69 6e 67 | 3a 0a 58 0a 58 20 20 20 |ollowing|:.X.X   |
|00001810| 20 20 63 6f 6e 76 20 20 | 20 20 72 65 70 6f 72 74 |  conv  |  report|
|00001820| 20 73 74 72 69 6e 67 2f | 64 6f 75 62 6c 65 20 63 | string/|double c|
|00001830| 6f 6e 76 65 72 73 69 6f | 6e 73 20 28 6f 6e 6c 79 |onversio|ns (only|
|00001840| 20 66 6f 72 20 61 64 64 | 72 65 73 73 65 73 29 0a | for add|resses).|
|00001850| 58 20 20 20 20 20 65 6e | 74 72 79 20 20 20 72 65 |X     en|try   re|
|00001860| 70 6f 72 74 20 66 75 6e | 63 74 69 6f 6e 20 65 6e |port fun|ction en|
|00001870| 74 72 79 2c 20 77 69 74 | 68 20 70 61 72 61 6d 65 |try, wit|h parame|
|00001880| 74 65 72 73 0a 58 20 20 | 20 20 20 65 78 69 74 20 |ters.X  |   exit |
|00001890| 20 20 20 72 65 70 6f 72 | 74 20 66 75 6e 63 74 69 |   repor|t functi|
|000018a0| 6f 6e 20 65 78 69 74 2c | 20 77 69 74 68 20 72 65 |on exit,| with re|
|000018b0| 74 75 72 6e 20 76 61 6c | 75 65 73 0a 58 20 20 20 |turn val|ues.X   |
|000018c0| 20 20 66 72 65 65 20 20 | 20 20 72 65 70 6f 72 74 |  free  |  report|
|000018d0| 20 6d 65 6d 6f 72 79 20 | 66 72 65 65 69 6e 67 0a | memory |freeing.|
|000018e0| 58 20 20 20 20 20 69 6e | 66 6f 20 20 20 20 72 65 |X     in|fo    re|
|000018f0| 70 6f 72 74 20 6f 74 68 | 65 72 20 69 6e 66 6f 72 |port oth|er infor|
|00001900| 6d 61 74 69 6f 6e 20 6f | 66 20 69 6e 74 65 72 65 |mation o|f intere|
|00001910| 73 74 0a 58 20 20 20 20 | 20 6d 61 6c 6c 6f 63 20 |st.X    | malloc |
|00001920| 20 72 65 70 6f 72 74 20 | 6d 65 6d 6f 72 79 20 61 | report |memory a|
|00001930| 6c 6c 6f 63 61 74 69 6f | 6e 2c 20 73 75 63 63 65 |llocatio|n, succe|
|00001940| 73 73 20 6f 72 20 66 61 | 69 6c 75 72 65 0a 58 0a |ss or fa|ilure.X.|
|00001950| 58 44 65 62 75 67 67 69 | 6e 67 20 69 73 20 74 75 |XDebuggi|ng is tu|
|00001960| 72 6e 65 64 20 6f 66 66 | 20 62 79 20 61 73 73 69 |rned off| by assi|
|00001970| 67 6e 69 6e 67 20 61 6e | 20 65 6d 70 74 79 20 73 |gning an| empty s|
|00001980| 74 72 69 6e 67 20 74 6f | 20 24 6f 72 61 5f 64 65 |tring to| $ora_de|
|00001990| 62 75 67 2e 0a 58 0a 58 | 49 74 20 69 73 20 73 74 |bug..X.X|It is st|
|000019a0| 69 6c 6c 20 70 6f 73 73 | 69 62 6c 65 20 74 6f 20 |ill poss|ible to |
|000019b0| 61 73 73 69 67 6e 20 61 | 20 6e 75 6d 65 72 69 63 |assign a| numeric|
|000019c0| 20 76 61 6c 75 65 20 74 | 6f 20 24 6f 72 61 5f 64 | value t|o $ora_d|
|000019d0| 65 62 75 67 2c 20 66 6f | 72 0a 58 63 6f 6d 70 61 |ebug, fo|r.Xcompa|
|000019e0| 74 69 62 69 6c 69 74 79 | 20 77 69 74 68 20 65 78 |tibility| with ex|
|000019f0| 69 73 74 69 6e 67 20 70 | 72 6f 67 72 61 6d 73 20 |isting p|rograms |
|00001a00| 61 6e 64 20 74 6f 20 61 | 6c 6c 6f 77 20 63 6f 6e |and to a|llow con|
|00001a10| 74 69 6e 75 65 64 20 75 | 73 65 20 6f 66 0a 58 50 |tinued u|se of.XP|
|00001a20| 65 72 6c 27 73 20 2d 44 | 20 66 6c 61 67 2e 20 56 |erl's -D| flag. V|
|00001a30| 61 6c 75 65 73 20 61 72 | 65 20 74 72 61 6e 73 6c |alues ar|e transl|
|00001a40| 61 74 65 64 20 61 63 63 | 6f 72 64 69 6e 67 20 74 |ated acc|ording t|
|00001a50| 6f 20 74 68 65 20 66 6f | 6c 6c 6f 77 69 6e 67 20 |o the fo|llowing |
|00001a60| 74 61 62 6c 65 3a 0a 58 | 0a 58 20 20 20 20 20 20 |table:.X|.X      |
|00001a70| 76 61 6c 75 65 20 20 20 | 20 6b 65 79 77 6f 72 64 |value   | keyword|
|00001a80| 73 0a 58 20 20 20 20 20 | 20 2d 2d 2d 2d 2d 20 20 |s.X     | -----  |
|00001a90| 20 20 2d 2d 2d 2d 2d 2d | 2d 2d 0a 58 20 20 20 20 |  ------|--.X    |
|00001aa0| 20 20 20 20 20 38 20 20 | 20 20 20 65 6e 74 72 79 |     8  |   entry|
|00001ab0| 20 65 78 69 74 20 69 6e | 66 6f 0a 58 20 20 20 20 | exit in|fo.X    |
|00001ac0| 20 20 20 20 33 32 20 20 | 20 20 20 63 6f 6e 76 0a |    32  |   conv.|
|00001ad0| 58 20 20 20 20 20 20 20 | 31 32 38 20 20 20 20 20 |X       |128     |
|00001ae0| 6d 61 6c 6c 6f 63 20 66 | 72 65 65 0a 58 0a 58 54 |malloc f|ree.X.XT|
|00001af0| 68 65 73 65 20 76 61 6c | 75 65 73 20 6d 61 79 20 |hese val|ues may |
|00001b00| 63 6f 6d 62 69 6e 65 64 | 2c 20 73 6f 20 74 68 61 |combined|, so tha|
|00001b10| 74 20 24 6f 72 61 5f 64 | 65 62 75 67 20 3d 20 31 |t $ora_d|ebug = 1|
|00001b20| 36 38 20 74 75 72 6e 73 | 20 6f 6e 20 61 6c 6c 20 |68 turns| on all |
|00001b30| 64 65 62 75 67 67 69 6e | 67 2e 0a 58 49 66 20 74 |debuggin|g..XIf t|
|00001b40| 68 65 20 72 65 73 75 6c | 74 69 6e 67 20 76 61 6c |he resul|ting val|
|00001b50| 75 65 20 63 6f 6e 74 61 | 69 6e 73 20 6e 6f 20 76 |ue conta|ins no v|
|00001b60| 61 6c 69 64 20 66 6c 61 | 67 73 2c 20 64 65 62 75 |alid fla|gs, debu|
|00001b70| 67 67 69 6e 67 20 69 73 | 20 74 75 72 6e 65 64 20 |gging is| turned |
|00001b80| 6f 66 66 3b 0a 58 74 68 | 75 73 20 22 24 6f 72 61 |off;.Xth|us "$ora|
|00001b90| 5f 64 65 62 75 67 20 3d | 20 30 22 20 73 74 69 6c |_debug =| 0" stil|
|00001ba0| 6c 20 77 6f 72 6b 73 2e | 20 57 68 65 6e 20 61 20 |l works.| When a |
|00001bb0| 6e 75 6d 65 72 69 63 61 | 6c 20 76 61 6c 75 65 20 |numerica|l value |
|00001bc0| 69 73 20 75 73 65 64 2c | 20 74 68 65 0a 58 63 6f |is used,| the.Xco|
|00001bd0| 6e 74 72 6f 6c 73 20 27 | 3a 74 3a 4e 27 20 61 72 |ntrols '|:t:N' ar|
|00001be0| 65 20 61 70 70 65 6e 64 | 65 64 20 74 6f 20 73 68 |e append|ed to sh|
|00001bf0| 6f 77 20 74 68 65 20 66 | 75 6e 63 74 69 6f 6e 20 |ow the f|unction |
|00001c00| 6e 65 73 74 69 6e 67 20 | 61 6e 64 20 6e 75 6d 62 |nesting |and numb|
|00001c10| 65 72 20 74 68 65 0a 58 | 6f 75 74 70 75 74 20 6c |er the.X|output l|
|00001c20| 69 6e 65 73 2e 0a 58 0a | 58 49 66 20 79 6f 75 72 |ines..X.|XIf your|
|00001c30| 20 75 70 65 72 6c 2e 6f | 20 77 61 73 20 62 75 69 | uperl.o| was bui|
|00001c40| 6c 74 20 77 69 74 68 20 | 2d 44 44 45 42 55 47 47 |lt with |-DDEBUGG|
|00001c50| 49 4e 47 2c 20 79 6f 75 | 20 63 61 6e 20 64 65 66 |ING, you| can def|
|00001c60| 69 6e 65 20 50 45 52 4c | 5f 44 45 42 55 47 47 49 |ine PERL|_DEBUGGI|
|00001c70| 4e 47 0a 58 61 74 20 63 | 6f 6d 70 69 6c 61 74 69 |NG.Xat c|ompilati|
|00001c80| 6f 6e 20 61 6e 64 20 74 | 68 65 20 6f 72 61 70 65 |on and t|he orape|
|00001c90| 72 6c 20 64 65 62 75 67 | 67 69 6e 67 20 77 69 6c |rl debug|ging wil|
|00001ca0| 6c 20 62 65 20 69 6e 69 | 74 69 61 6c 69 61 73 65 |l be ini|tialiase|
|00001cb0| 64 20 66 72 6f 6d 20 74 | 68 65 20 2d 44 0a 58 66 |d from t|he -D.Xf|
|00001cc0| 6c 61 67 2e 20 49 66 20 | 6e 6f 74 2c 20 79 6f 75 |lag. If |not, you|
|00001cd0| 20 63 61 6e 20 73 74 69 | 6c 6c 20 64 65 66 69 6e | can sti|ll defin|
|00001ce0| 65 20 44 45 42 55 47 47 | 49 4e 47 2c 20 62 75 74 |e DEBUGG|ING, but|
|00001cf0| 20 79 6f 75 20 77 69 6c | 6c 20 68 61 76 65 20 74 | you wil|l have t|
|00001d00| 6f 20 73 65 74 0a 58 6f | 72 61 5f 64 65 62 75 67 |o set.Xo|ra_debug|
|00001d10| 20 66 72 6f 6d 20 77 69 | 74 68 69 6e 20 79 6f 75 | from wi|thin you|
|00001d20| 72 20 70 72 6f 67 72 61 | 6d 2e 0a 58 0a 58 4f 6e |r progra|m..X.XOn|
|00001d30| 65 20 69 64 65 61 20 77 | 6f 75 6c 64 20 62 65 20 |e idea w|ould be |
|00001d40| 74 6f 20 69 6e 63 6c 75 | 64 65 20 61 20 66 6c 61 |to inclu|de a fla|
|00001d50| 67 20 69 6e 20 61 6c 6c | 20 79 6f 75 72 20 70 72 |g in all| your pr|
|00001d60| 6f 67 72 61 6d 73 20 77 | 68 69 63 68 20 77 6f 75 |ograms w|hich wou|
|00001d70| 6c 64 20 61 6c 6c 6f 77 | 0a 58 61 20 64 65 62 75 |ld allow|.Xa debu|
|00001d80| 67 67 69 6e 67 20 73 74 | 72 69 6e 67 20 74 6f 20 |gging st|ring to |
|00001d90| 62 65 20 65 6e 74 65 72 | 65 64 20 6f 6e 20 74 68 |be enter|ed on th|
|00001da0| 65 20 63 6f 6d 6d 61 6e | 64 20 6c 69 6e 65 2e 20 |e comman|d line. |
|00001db0| 54 68 65 20 61 75 74 68 | 6f 72 20 6f 66 20 74 68 |The auth|or of th|
|00001dc0| 65 0a 58 44 42 55 47 20 | 70 61 63 6b 61 67 65 20 |e.XDBUG |package |
|00001dd0| 72 65 63 6f 6d 6d 65 6e | 64 73 20 2d 23 20 28 61 |recommen|ds -# (a|
|00001de0| 6e 64 20 73 6f 20 74 68 | 65 20 72 6f 75 74 69 6e |nd so th|e routin|
|00001df0| 65 73 20 77 69 6c 6c 20 | 72 65 6d 6f 76 65 20 61 |es will |remove a|
|00001e00| 20 6c 65 61 64 69 6e 67 | 20 2d 23 0a 58 66 72 6f | leading| -#.Xfro|
|00001e10| 6d 20 74 68 65 20 63 6f | 6e 74 72 6f 6c 20 73 74 |m the co|ntrol st|
|00001e20| 72 69 6e 67 20 69 66 20 | 74 68 65 72 65 20 69 73 |ring if |there is|
|00001e30| 20 6f 6e 65 29 2e 20 46 | 6f 72 20 65 78 61 6d 70 | one). F|or examp|
|00001e40| 6c 65 2c 20 49 20 75 73 | 65 20 74 68 69 73 20 6c |le, I us|e this l|
|00001e50| 69 6e 65 3a 0a 58 0a 58 | 09 24 6f 72 61 5f 64 65 |ine:.X.X|.$ora_de|
|00001e60| 62 75 67 20 3d 20 73 68 | 69 66 74 20 69 66 20 24 |bug = sh|ift if $|
|00001e70| 41 52 47 56 5b 30 5d 20 | 3d 7e 20 2f 2d 23 2f 3b |ARGV[0] |=~ /-#/;|
|00001e80| 0a 58 0a 58 49 66 20 79 | 6f 75 20 77 61 6e 74 20 |.X.XIf y|ou want |
|00001e90| 74 6f 20 74 72 61 63 65 | 20 73 6f 6d 65 74 68 69 |to trace| somethi|
|00001ea0| 6e 67 20 65 6c 73 65 2c | 20 79 6f 75 20 63 61 6e |ng else,| you can|
|00001eb0| 20 61 64 64 20 79 6f 75 | 72 20 6f 77 6e 20 44 42 | add you|r own DB|
|00001ec0| 55 47 5f 50 52 49 4e 54 | 0a 58 73 74 61 74 65 6d |UG_PRINT|.Xstatem|
|00001ed0| 65 6e 74 73 20 74 6f 20 | 74 68 65 20 63 6f 64 65 |ents to |the code|
|00001ee0| 20 77 68 65 72 65 76 65 | 72 20 79 6f 75 20 77 61 | whereve|r you wa|
|00001ef0| 6e 74 2e 20 49 20 77 6f | 75 6c 64 20 72 65 63 6f |nt. I wo|uld reco|
|00001f00| 6d 6d 65 6e 64 20 74 68 | 61 74 20 79 6f 75 20 75 |mmend th|at you u|
|00001f10| 73 65 0a 58 61 20 6b 65 | 79 77 6f 72 64 20 74 68 |se.Xa ke|yword th|
|00001f20| 61 74 20 69 73 6e 27 74 | 20 73 70 65 63 69 66 69 |at isn't| specifi|
|00001f30| 65 64 20 68 65 72 65 20 | 28 70 6f 73 73 69 62 6c |ed here |(possibl|
|00001f40| 79 20 62 65 67 69 6e 6e | 69 6e 67 20 77 69 74 68 |y beginn|ing with|
|00001f50| 20 79 6f 75 72 20 69 6e | 69 74 69 61 6c 73 29 0a | your in|itials).|
|00001f60| 58 73 6f 20 74 68 61 74 | 20 79 6f 75 20 63 61 6e |Xso that| you can|
|00001f70| 20 65 61 73 69 6c 79 20 | 64 69 73 74 69 6e 67 75 | easily |distingu|
|00001f80| 69 73 68 20 62 65 74 77 | 65 65 6e 20 6d 79 20 64 |ish betw|een my d|
|00001f90| 65 62 75 67 67 69 6e 67 | 20 61 6e 64 20 79 6f 75 |ebugging| and you|
|00001fa0| 72 73 2e 0a 45 4e 44 5f | 4f 46 5f 46 49 4c 45 0a |rs..END_|OF_FILE.|
|00001fb0| 20 20 69 66 20 74 65 73 | 74 20 33 31 35 34 20 2d |  if tes|t 3154 -|
|00001fc0| 6e 65 20 60 77 63 20 2d | 63 20 3c 27 44 65 62 75 |ne `wc -|c <'Debu|
|00001fd0| 67 67 69 6e 67 27 60 3b | 20 74 68 65 6e 0a 20 20 |gging'`;| then.  |
|00001fe0| 20 20 65 63 68 6f 20 73 | 68 61 72 3a 20 5c 22 27 |  echo s|har: \"'|
|00001ff0| 44 65 62 75 67 67 69 6e | 67 27 5c 22 20 75 6e 70 |Debuggin|g'\" unp|
|00002000| 61 63 6b 65 64 20 77 69 | 74 68 20 77 72 6f 6e 67 |acked wi|th wrong|
|00002010| 20 73 69 7a 65 21 0a 20 | 20 66 69 0a 20 20 23 20 | size!. | fi.  # |
|00002020| 65 6e 64 20 6f 66 20 27 | 44 65 62 75 67 67 69 6e |end of '|Debuggin|
|00002030| 67 27 0a 66 69 0a 69 66 | 20 74 65 73 74 20 2d 66 |g'.fi.if| test -f|
|00002040| 20 27 48 69 6e 74 73 27 | 20 2d 61 20 22 24 7b 31 | 'Hints'| -a "${1|
|00002050| 7d 22 20 21 3d 20 22 2d | 63 22 20 3b 20 74 68 65 |}" != "-|c" ; the|
|00002060| 6e 20 0a 20 20 65 63 68 | 6f 20 73 68 61 72 3a 20 |n .  ech|o shar: |
|00002070| 57 69 6c 6c 20 6e 6f 74 | 20 63 6c 6f 62 62 65 72 |Will not| clobber|
|00002080| 20 65 78 69 73 74 69 6e | 67 20 66 69 6c 65 20 5c | existin|g file \|
|00002090| 22 27 48 69 6e 74 73 27 | 5c 22 0a 65 6c 73 65 0a |"'Hints'|\".else.|
|000020a0| 20 20 65 63 68 6f 20 73 | 68 61 72 3a 20 45 78 74 |  echo s|har: Ext|
|000020b0| 72 61 63 74 69 6e 67 20 | 5c 22 27 48 69 6e 74 73 |racting |\"'Hints|
|000020c0| 27 5c 22 20 5c 28 34 35 | 37 39 20 63 68 61 72 61 |'\" \(45|79 chara|
|000020d0| 63 74 65 72 73 5c 29 0a | 20 20 73 65 64 20 22 73 |cters\).|  sed "s|
|000020e0| 2f 5e 58 2f 2f 22 20 3e | 27 48 69 6e 74 73 27 20 |/^X//" >|'Hints' |
|000020f0| 3c 3c 27 45 4e 44 5f 4f | 46 5f 46 49 4c 45 27 0a |<<'END_O|F_FILE'.|
|00002100| 58 54 68 69 73 20 66 69 | 6c 65 20 63 6f 6e 74 61 |XThis fi|le conta|
|00002110| 69 6e 73 20 68 69 6e 74 | 73 20 61 6e 64 20 74 69 |ins hint|s and ti|
|00002120| 70 73 20 61 62 6f 75 74 | 20 4f 72 61 70 65 72 6c |ps about| Oraperl|
|00002130| 2c 20 64 65 61 6c 69 6e | 67 20 77 69 74 68 20 70 |, dealin|g with p|
|00002140| 72 6f 62 6c 65 6d 73 20 | 77 68 69 63 68 0a 58 68 |roblems |which.Xh|
|00002150| 61 76 65 20 61 72 69 73 | 65 6e 20 69 6e 20 74 68 |ave aris|en in th|
|00002160| 65 20 70 61 73 74 2e 0a | 58 0a 58 54 68 65 20 74 |e past..|X.XThe t|
|00002170| 6f 70 69 63 73 20 64 65 | 61 6c 74 20 77 69 74 68 |opics de|alt with|
|00002180| 20 61 72 65 20 74 68 65 | 20 66 6f 6c 6c 6f 77 69 | are the| followi|
|00002190| 6e 67 3a 0a 58 0a 58 09 | 4d 65 6d 6f 72 79 20 55 |ng:.X.X.|Memory U|
|000021a0| 73 61 67 65 0a 58 09 42 | 75 69 6c 64 69 6e 67 20 |sage.X.B|uilding |
|000021b0| 6f 6e 20 61 20 43 6f 6e | 76 65 78 20 6d 61 63 68 |on a Con|vex mach|
|000021c0| 69 6e 65 0a 58 09 42 75 | 69 6c 64 69 6e 67 20 6f |ine.X.Bu|ilding o|
|000021d0| 6e 20 44 75 61 6c 20 55 | 6e 69 76 65 72 73 65 20 |n Dual U|niverse |
|000021e0| 6d 61 63 68 69 6e 65 73 | 0a 58 09 42 75 69 6c 64 |machines|.X.Build|
|000021f0| 69 6e 67 20 77 69 74 68 | 20 50 65 72 6c 20 76 33 |ing with| Perl v3|
|00002200| 0a 58 09 55 73 69 6e 67 | 20 42 69 6e 64 20 56 61 |.X.Using| Bind Va|
|00002210| 72 69 61 62 6c 65 73 0a | 58 09 42 75 69 6c 64 69 |riables.|X.Buildi|
|00002220| 6e 67 20 77 69 74 68 20 | 4f 72 61 63 6c 65 20 76 |ng with |Oracle v|
|00002230| 35 0a 58 0a 58 0a 58 4d | 65 6d 6f 72 79 20 55 73 |5.X.X.XM|emory Us|
|00002240| 61 67 65 0a 58 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |age.X===|========|
|00002250| 3d 0a 58 0a 58 57 69 74 | 68 20 76 65 72 73 69 6f |=.X.XWit|h versio|
|00002260| 6e 73 20 6f 66 20 50 65 | 72 6c 20 70 72 69 6f 72 |ns of Pe|rl prior|
|00002270| 20 74 6f 20 34 2e 30 33 | 34 2c 20 74 68 65 72 65 | to 4.03|4, there|
|00002280| 20 69 73 20 61 20 6d 65 | 6d 6f 72 79 20 6c 65 61 | is a me|mory lea|
|00002290| 6b 20 77 68 65 6e 0a 58 | 72 65 70 65 61 74 65 64 |k when.X|repeated|
|000022a0| 20 63 61 6c 6c 73 20 74 | 6f 20 26 6f 72 61 5f 66 | calls t|o &ora_f|
|000022b0| 65 74 63 68 28 29 20 61 | 72 65 20 6d 61 64 65 20 |etch() a|re made |
|000022c0| 77 69 74 68 69 6e 20 61 | 20 77 68 69 6c 65 28 29 |within a| while()|
|000022d0| 20 6c 6f 6f 70 2e 0a 58 | 0a 58 54 68 65 20 63 6f | loop..X|.XThe co|
|000022e0| 72 72 65 63 74 20 73 6f | 6c 75 74 69 6f 6e 20 69 |rrect so|lution i|
|000022f0| 73 20 74 6f 20 75 70 67 | 72 61 64 65 20 74 6f 20 |s to upg|rade to |
|00002300| 34 2e 30 33 34 2e 20 48 | 6f 77 65 76 65 72 2c 20 |4.034. H|owever, |
|00002310| 69 66 20 74 68 61 74 20 | 69 73 0a 58 6e 6f 74 20 |if that |is.Xnot |
|00002320| 70 6f 73 73 69 62 6c 65 | 20 66 6f 72 20 73 6f 6d |possible| for som|
|00002330| 65 20 72 65 61 73 6f 6e | 2c 20 74 68 65 72 65 20 |e reason|, there |
|00002340| 69 73 20 61 20 77 6f 72 | 6b 61 72 6f 75 6e 64 2e |is a wor|karound.|
|00002350| 0a 58 0a 58 43 72 65 61 | 74 65 20 61 20 50 65 72 |.X.XCrea|te a Per|
|00002360| 6c 20 73 75 62 72 6f 75 | 74 69 6e 65 20 77 68 69 |l subrou|tine whi|
|00002370| 63 68 20 72 65 74 75 72 | 6e 73 20 61 20 72 6f 77 |ch retur|ns a row|
|00002380| 20 66 72 6f 6d 20 61 20 | 64 61 74 61 62 61 73 65 | from a |database|
|00002390| 20 61 6e 64 0a 58 63 61 | 6c 6c 20 74 68 69 73 20 | and.Xca|ll this |
|000023a0| 69 6e 73 74 65 61 64 2e | 20 53 6f 20 69 6e 73 74 |instead.| So inst|
|000023b0| 65 61 64 20 6f 66 0a 58 | 0a 58 09 77 68 69 6c 65 |ead of.X|.X.while|
|000023c0| 20 28 40 64 61 74 61 20 | 3d 20 26 6f 72 61 5f 66 | (@data |= &ora_f|
|000023d0| 65 74 63 68 28 24 63 73 | 72 29 29 0a 58 09 7b 0a |etch($cs|r)).X.{.|
|000023e0| 58 09 20 20 20 20 2e 2e | 2e 0a 58 09 7d 0a 58 0a |X.    ..|..X.}.X.|
|000023f0| 58 79 6f 75 20 73 68 6f | 75 6c 64 20 75 73 65 20 |Xyou sho|uld use |
|00002400| 73 6f 6d 65 74 68 69 6e | 67 20 6c 69 6b 65 20 74 |somethin|g like t|
|00002410| 68 69 73 3a 0a 58 0a 58 | 09 73 75 62 20 67 65 74 |his:.X.X|.sub get|
|00002420| 72 6f 77 0a 58 09 7b 0a | 58 09 20 20 20 20 6c 6f |row.X.{.|X.    lo|
|00002430| 63 61 6c 28 24 63 73 72 | 29 20 3d 20 40 5f 3b 0a |cal($csr|) = @_;.|
|00002440| 58 09 20 20 20 20 6c 6f | 63 61 6c 28 40 64 61 74 |X.    lo|cal(@dat|
|00002450| 61 29 3b 0a 58 0a 58 09 | 20 20 20 20 40 64 61 74 |a);.X.X.|    @dat|
|00002460| 61 20 3d 20 26 6f 72 61 | 5f 66 65 74 63 68 28 24 |a = &ora|_fetch($|
|00002470| 63 73 72 29 3b 0a 58 09 | 7d 0a 58 0a 58 09 2e 2e |csr);.X.|}.X.X...|
|00002480| 2e 0a 58 0a 58 09 77 68 | 69 6c 65 20 28 40 64 61 |..X.X.wh|ile (@da|
|00002490| 74 61 20 3d 20 26 67 65 | 74 72 6f 77 28 24 63 73 |ta = &ge|trow($cs|
|000024a0| 72 29 29 0a 58 09 7b 0a | 58 09 20 20 20 20 2e 2e |r)).X.{.|X.    ..|
|000024b0| 2e 0a 58 09 7d 0a 58 0a | 58 0a 58 42 75 69 6c 64 |..X.}.X.|X.XBuild|
|000024c0| 69 6e 67 20 6f 6e 20 61 | 20 43 6f 6e 76 65 78 20 |ing on a| Convex |
|000024d0| 6d 61 63 68 69 6e 65 0a | 58 3d 3d 3d 3d 3d 3d 3d |machine.|X=======|
|000024e0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000024f0| 3d 3d 3d 3d 3d 0a 58 0a | 58 43 6f 6d 6d 65 6e 74 |=====.X.|XComment|
|00002500| 20 6f 75 74 20 74 68 65 | 20 64 65 66 69 6e 69 74 | out the| definit|
|00002510| 69 6f 6e 20 6f 66 20 53 | 54 52 54 4f 55 4c 20 69 |ion of S|TRTOUL i|
|00002520| 6e 20 74 68 65 20 4d 61 | 6b 65 66 69 6c 65 2e 0a |n the Ma|kefile..|
|00002530| 58 0a 58 0a 58 42 75 69 | 6c 64 69 6e 67 20 6f 6e |X.X.XBui|lding on|
|00002540| 20 44 75 61 6c 20 55 6e | 69 76 65 72 73 65 20 6d | Dual Un|iverse m|
|00002550| 61 63 68 69 6e 65 73 0a | 58 3d 3d 3d 3d 3d 3d 3d |achines.|X=======|
|00002560| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00002570| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 0a 58 0a 58 54 |========|===.X.XT|
|00002580| 68 69 73 20 77 61 73 20 | 72 65 70 6f 72 74 65 64 |his was |reported|
|00002590| 20 6f 6e 20 61 20 50 79 | 72 61 6d 69 64 20 6d 61 | on a Py|ramid ma|
|000025a0| 63 68 69 6e 65 2c 20 62 | 75 74 20 49 20 74 68 69 |chine, b|ut I thi|
|000025b0| 6e 6b 20 69 74 20 61 70 | 70 6c 69 65 73 20 74 6f |nk it ap|plies to|
|000025c0| 20 6d 6f 73 74 20 28 69 | 66 0a 58 6e 6f 74 20 61 | most (i|f.Xnot a|
|000025d0| 6c 6c 29 20 64 75 61 6c | 2d 75 6e 69 76 65 72 73 |ll) dual|-univers|
|000025e0| 65 20 73 79 73 74 65 6d | 73 20 28 53 65 71 75 65 |e system|s (Seque|
|000025f0| 6e 74 2c 20 47 6f 75 6c | 64 2c 20 65 74 63 29 2e |nt, Goul|d, etc).|
|00002600| 20 20 41 6c 74 68 6f 75 | 67 68 20 70 61 63 6b 61 |  Althou|gh packa|
|00002610| 67 65 73 0a 58 62 75 69 | 6c 74 20 69 6e 20 6f 6e |ges.Xbui|lt in on|
|00002620| 65 20 75 6e 69 76 65 72 | 73 65 20 77 69 6c 6c 20 |e univer|se will |
|00002630| 72 75 6e 20 63 6f 72 72 | 65 63 74 6c 79 20 69 6e |run corr|ectly in|
|00002640| 20 74 68 65 20 6f 74 68 | 65 72 2c 20 68 79 62 72 | the oth|er, hybr|
|00002650| 69 64 73 20 28 70 61 63 | 6b 61 67 65 73 0a 58 62 |ids (pac|kages.Xb|
|00002660| 75 69 6c 74 20 70 61 72 | 74 6c 79 20 69 6e 20 6f |uilt par|tly in o|
|00002670| 6e 65 20 75 6e 69 76 65 | 72 73 65 20 61 6e 64 20 |ne unive|rse and |
|00002680| 70 61 72 74 6c 79 20 69 | 6e 20 74 68 65 20 6f 74 |partly i|n the ot|
|00002690| 68 65 72 29 20 77 69 6c | 6c 20 6e 6f 74 20 77 6f |her) wil|l not wo|
|000026a0| 72 6b 0a 58 70 72 6f 70 | 65 72 6c 79 20 69 6e 20 |rk.Xprop|erly in |
|000026b0| 65 69 74 68 65 72 2e 20 | 4f 6e 20 74 68 65 20 50 |either. |On the P|
|000026c0| 79 72 61 6d 69 64 2c 20 | 74 68 65 20 73 79 6d 70 |yramid, |the symp|
|000026d0| 74 6f 6d 20 77 61 73 20 | 74 68 61 74 20 6f 75 74 |tom was |that out|
|000026e0| 70 75 74 20 77 61 73 20 | 62 65 69 6e 67 0a 58 6c |put was |being.Xl|
|000026f0| 6f 73 74 2c 20 61 6c 74 | 68 6f 75 67 68 20 61 20 |ost, alt|hough a |
|00002700| 64 65 62 75 67 67 69 6e | 67 20 74 72 61 63 65 20 |debuggin|g trace |
|00002710| 73 68 6f 77 65 64 20 74 | 68 61 74 20 74 68 65 20 |showed t|hat the |
|00002720| 70 72 6f 67 72 61 6d 20 | 77 61 73 20 77 6f 72 6b |program |was work|
|00002730| 69 6e 67 0a 58 70 72 6f | 70 65 72 6c 79 2e 0a 58 |ing.Xpro|perly..X|
|00002740| 0a 58 53 69 6e 63 65 20 | 4f 72 61 63 6c 65 20 73 |.XSince |Oracle s|
|00002750| 70 65 63 69 66 69 65 73 | 20 74 68 61 74 20 69 74 |pecifies| that it|
|00002760| 20 69 73 20 74 6f 20 62 | 65 20 69 6e 73 74 61 6c | is to b|e instal|
|00002770| 6c 65 64 20 69 6e 20 74 | 68 65 20 41 54 54 20 75 |led in t|he ATT u|
|00002780| 6e 69 76 65 72 73 65 2c | 20 79 6f 75 0a 58 6d 75 |niverse,| you.Xmu|
|00002790| 73 74 20 61 6c 73 6f 20 | 63 6f 6d 70 69 6c 65 20 |st also |compile |
|000027a0| 50 65 72 6c 20 61 6e 64 | 20 4f 72 61 70 65 72 6c |Perl and| Oraperl|
|000027b0| 20 28 61 6e 64 20 74 68 | 65 20 63 75 72 73 65 73 | (and th|e curses|
|000027c0| 20 75 73 65 72 73 75 62 | 73 2c 20 69 66 20 79 6f | usersub|s, if yo|
|000027d0| 75 20 61 72 65 0a 58 62 | 75 69 6c 64 69 6e 67 20 |u are.Xb|uilding |
|000027e0| 43 6f 72 61 70 65 72 6c | 29 20 69 6e 20 74 68 65 |Coraperl|) in the|
|000027f0| 20 41 54 54 20 75 6e 69 | 76 65 72 73 65 20 74 6f | ATT uni|verse to|
|00002800| 20 61 6c 6c 6f 77 20 74 | 68 65 6d 20 74 6f 20 62 | allow t|hem to b|
|00002810| 65 20 6c 69 6e 6b 65 64 | 20 74 6f 67 65 74 68 65 |e linked| togethe|
|00002820| 72 2e 0a 58 0a 58 0a 58 | 42 75 69 6c 64 69 6e 67 |r..X.X.X|Building|
|00002830| 20 77 69 74 68 20 50 65 | 72 6c 20 76 33 0a 58 3d | with Pe|rl v3.X=|
|00002840| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00002850| 3d 3d 3d 3d 0a 58 0a 58 | 49 64 65 61 6c 6c 79 2c |====.X.X|Ideally,|
|00002860| 20 67 65 74 20 68 6f 6c | 64 20 6f 66 20 76 34 2e | get hol|d of v4.|
|00002870| 20 48 6f 77 65 76 65 72 | 2c 20 69 66 20 79 6f 75 | However|, if you|
|00002880| 20 68 61 76 65 20 74 6f | 20 77 6f 72 6b 20 77 69 | have to| work wi|
|00002890| 74 68 20 76 33 2c 20 75 | 6e 63 6f 6d 6d 65 6e 74 |th v3, u|ncomment|
|000028a0| 0a 58 74 68 65 20 64 65 | 66 69 6e 69 74 69 6f 6e |.Xthe de|finition|
|000028b0| 20 6f 66 20 53 54 52 5f | 32 4d 4f 52 54 41 4c 20 | of STR_|2MORTAL |
|000028c0| 69 6e 20 74 68 65 20 4d | 61 6b 65 66 69 6c 65 2e |in the M|akefile.|
|000028d0| 20 4e 6f 74 65 20 61 6c | 73 6f 20 74 68 65 20 73 | Note al|so the s|
|000028e0| 65 63 74 69 6f 6e 20 6f | 6e 0a 58 6d 65 6d 6f 72 |ection o|n.Xmemor|
|000028f0| 79 20 75 73 61 67 65 20 | 61 62 6f 76 65 2e 0a 58 |y usage |above..X|
|00002900| 0a 58 0a 58 55 73 69 6e | 67 20 42 69 6e 64 20 56 |.X.XUsin|g Bind V|
|00002910| 61 72 69 61 62 6c 65 73 | 0a 58 3d 3d 3d 3d 3d 3d |ariables|.X======|
|00002920| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 0a 58 |========|======.X|
|00002930| 0a 58 54 68 65 20 73 75 | 70 70 6f 72 74 20 66 6f |.XThe su|pport fo|
|00002940| 72 20 62 69 6e 64 20 76 | 61 72 69 61 62 6c 65 73 |r bind v|ariables|
|00002950| 20 64 6f 65 73 20 6e 6f | 74 20 72 65 66 6c 65 63 | does no|t reflec|
|00002960| 74 20 74 68 65 20 66 75 | 6c 6c 20 70 6f 74 65 6e |t the fu|ll poten|
|00002970| 74 69 61 6c 20 6f 66 20 | 50 72 6f 2a 43 2e 0a 58 |tial of |Pro*C..X|
|00002980| 0a 58 46 69 72 73 74 6c | 79 2c 20 62 69 6e 64 20 |.XFirstl|y, bind |
|00002990| 76 61 72 69 61 62 6c 65 | 73 20 6d 61 79 20 6f 6e |variable|s may on|
|000029a0| 6c 79 20 62 65 20 6e 75 | 6d 65 72 69 63 3b 20 6e |ly be nu|meric; n|
|000029b0| 61 6d 65 64 20 62 69 6e | 64 20 76 61 72 69 61 62 |amed bin|d variab|
|000029c0| 6c 65 73 20 61 72 65 20 | 6e 6f 74 0a 58 73 75 70 |les are |not.Xsup|
|000029d0| 70 6f 72 74 65 64 2e 20 | 54 68 65 79 20 6d 75 73 |ported. |They mus|
|000029e0| 74 20 72 75 6e 20 69 6e | 20 73 65 71 75 65 6e 63 |t run in| sequenc|
|000029f0| 65 20 66 72 6f 6d 20 31 | 2e 20 28 54 68 69 73 20 |e from 1|. (This |
|00002a00| 69 73 20 74 6f 20 6d 61 | 6b 65 20 69 74 20 65 61 |is to ma|ke it ea|
|00002a10| 73 79 20 66 6f 72 0a 58 | 26 6f 72 61 5f 62 69 6e |sy for.X|&ora_bin|
|00002a20| 64 28 29 20 74 6f 20 63 | 68 65 63 6b 20 74 68 61 |d() to c|heck tha|
|00002a30| 74 20 69 74 20 68 61 73 | 20 72 65 63 65 69 76 65 |t it has| receive|
|00002a40| 64 20 74 68 65 20 63 6f | 72 72 65 63 74 20 6e 75 |d the co|rrect nu|
|00002a50| 6d 62 65 72 20 6f 66 20 | 70 61 72 61 6d 65 74 65 |mber of |paramete|
|00002a60| 72 73 2e 29 0a 58 0a 58 | 53 65 63 6f 6e 64 6c 79 |rs.).X.X|Secondly|
|00002a70| 2c 20 74 68 65 79 20 6d | 61 79 20 6f 6e 6c 79 20 |, they m|ay only |
|00002a80| 62 65 20 75 73 65 64 20 | 74 6f 20 6d 6f 64 69 66 |be used |to modif|
|00002a90| 79 20 76 61 6c 75 65 73 | 20 77 69 74 68 69 6e 20 |y values| within |
|00002aa0| 74 68 65 20 53 51 4c 20 | 73 74 61 74 65 6d 65 6e |the SQL |statemen|
|00002ab0| 74 2c 0a 58 6e 6f 74 20 | 66 69 65 6c 64 20 6f 72 |t,.Xnot |field or|
|00002ac0| 20 74 61 62 6c 65 20 6e | 61 6d 65 73 2e 20 54 68 | table n|ames. Th|
|00002ad0| 75 73 0a 58 0a 58 09 69 | 6e 73 65 72 74 20 69 6e |us.X.X.i|nsert in|
|00002ae0| 74 6f 20 74 65 6c 6e 6f | 20 76 61 6c 75 65 73 20 |to telno| values |
|00002af0| 28 3a 31 2c 20 3a 32 29 | 0a 58 0a 58 69 73 20 76 |(:1, :2)|.X.Xis v|
|00002b00| 61 6c 69 64 2c 20 62 75 | 74 0a 58 0a 58 09 73 65 |alid, bu|t.X.X.se|
|00002b10| 6c 65 63 74 20 2a 20 66 | 72 6f 6d 20 74 65 6c 6e |lect * f|rom teln|
|00002b20| 6f 20 6f 72 64 65 72 20 | 62 79 20 3a 31 0a 58 0a |o order |by :1.X.|
|00002b30| 58 69 73 20 6e 6f 74 2e | 20 54 68 69 73 20 6d 61 |Xis not.| This ma|
|00002b40| 64 65 20 74 68 65 20 69 | 6e 74 65 72 61 63 74 69 |de the i|nteracti|
|00002b50| 6f 6e 20 62 65 74 77 65 | 65 6e 20 26 6f 72 61 5f |on betwe|en &ora_|
|00002b60| 6f 70 65 6e 28 29 20 61 | 6e 64 20 26 6f 72 61 5f |open() a|nd &ora_|
|00002b70| 62 69 6e 64 28 29 20 73 | 69 6d 70 6c 65 72 2c 0a |bind() s|impler,.|
|00002b80| 58 62 75 74 20 69 66 20 | 69 74 27 73 20 61 20 73 |Xbut if |it's a s|
|00002b90| 65 72 69 6f 75 73 20 72 | 65 73 74 72 69 63 74 69 |erious r|estricti|
|00002ba0| 6f 6e 20 66 6f 72 20 79 | 6f 75 20 6c 65 74 20 6d |on for y|ou let m|
|00002bb0| 65 20 6b 6e 6f 77 2c 20 | 61 6e 64 20 49 27 6c 6c |e know, |and I'll|
|00002bc0| 20 6c 6f 6f 6b 20 69 6e | 74 6f 0a 58 65 78 74 65 | look in|to.Xexte|
|00002bd0| 6e 64 69 6e 67 20 69 74 | 2e 20 28 4f 66 20 63 6f |nding it|. (Of co|
|00002be0| 75 72 73 65 2c 20 74 68 | 65 72 65 27 73 20 6e 6f |urse, th|ere's no|
|00002bf0| 74 68 69 6e 67 20 74 6f | 20 73 74 6f 70 20 79 6f |thing to| stop yo|
|00002c00| 75 20 64 6f 69 6e 67 3a | 0a 58 0a 58 09 24 6f 72 |u doing:|.X.X.$or|
|00002c10| 64 65 72 5f 62 79 20 3d | 20 22 6e 61 6d 65 22 3b |der_by =| "name";|
|00002c20| 0a 58 09 26 6f 72 61 5f | 6f 70 65 6e 28 24 6c 64 |.X.&ora_|open($ld|
|00002c30| 61 2c 20 22 73 65 6c 65 | 63 74 20 2a 20 66 72 6f |a, "sele|ct * fro|
|00002c40| 6d 20 74 65 6c 6e 6f 20 | 6f 72 64 65 72 20 62 79 |m telno |order by|
|00002c50| 20 24 6f 72 64 65 72 5f | 62 79 22 29 3b 0a 58 0a | $order_|by");.X.|
|00002c60| 58 73 6f 20 49 20 64 6f | 6e 27 74 20 74 68 69 6e |Xso I do|n't thin|
|00002c70| 6b 20 69 74 20 73 68 6f | 75 6c 64 20 62 65 20 74 |k it sho|uld be t|
|00002c80| 6f 6f 20 62 69 67 20 61 | 20 70 72 6f 62 6c 65 6d |oo big a| problem|
|00002c90| 2e 29 0a 58 0a 58 0a 58 | 42 75 69 6c 64 69 6e 67 |.).X.X.X|Building|
|00002ca0| 20 77 69 74 68 20 4f 72 | 61 63 6c 65 20 76 35 0a | with Or|acle v5.|
|00002cb0| 58 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |X=======|========|
|00002cc0| 3d 3d 3d 3d 3d 3d 3d 3d | 0a 58 0a 58 5b 20 54 68 |========|.X.X[ Th|
|00002cd0| 69 73 20 69 6e 66 6f 72 | 6d 61 74 69 6f 6e 20 77 |is infor|mation w|
|00002ce0| 61 73 20 6f 72 69 67 69 | 6e 61 6c 6c 79 20 69 6e |as origi|nally in|
|00002cf0| 20 61 20 73 65 70 61 72 | 61 74 65 20 66 69 6c 65 | a separ|ate file|
|00002d00| 2c 20 4f 72 61 63 6c 65 | 2d 76 35 29 20 20 20 20 |, Oracle|-v5)    |
|00002d10| 5d 0a 58 5b 20 59 6f 75 | 20 77 69 6c 6c 20 68 61 |].X[ You| will ha|
|00002d20| 76 65 20 74 6f 20 61 64 | 61 70 74 20 74 68 69 73 |ve to ad|apt this|
|00002d30| 20 73 6c 69 67 68 74 6c | 79 20 61 73 20 74 68 65 | slightl|y as the|
|00002d40| 20 4d 61 6b 65 66 69 6c | 65 20 68 61 73 20 63 68 | Makefil|e has ch|
|00002d50| 61 6e 67 65 64 2e 20 5d | 0a 58 0a 58 54 68 65 20 |anged. ]|.X.XThe |
|00002d60| 4d 61 6b 65 66 69 6c 65 | 20 69 6e 63 6c 75 64 65 |Makefile| include|
|00002d70| 73 20 6c 69 62 72 61 72 | 79 20 64 65 66 69 6e 69 |s librar|y defini|
|00002d80| 74 69 6f 6e 73 20 77 68 | 69 63 68 20 61 72 65 20 |tions wh|ich are |
|00002d90| 73 75 69 74 61 62 6c 65 | 20 66 6f 72 20 4f 72 61 |suitable| for Ora|
|00002da0| 63 6c 65 20 76 36 0a 58 | 6f 6e 20 61 6e 20 45 6e |cle v6.X|on an En|
|00002db0| 63 6f 72 65 20 4d 75 6c | 74 69 6d 61 78 20 72 75 |core Mul|timax ru|
|00002dc0| 6e 6e 69 6e 67 20 55 4d | 41 58 20 56 2e 20 49 20 |nning UM|AX V. I |
|00002dd0| 64 6f 20 6e 6f 74 20 68 | 61 76 65 20 61 63 63 65 |do not h|ave acce|
|00002de0| 73 73 20 74 6f 20 61 6e | 79 20 6f 74 68 65 72 0a |ss to an|y other.|
|00002df0| 58 63 6f 6e 66 69 67 75 | 72 61 74 69 6f 6e 20 74 |Xconfigu|ration t|
|00002e00| 6f 20 74 65 73 74 20 4f | 72 61 70 65 72 6c 2e 0a |o test O|raperl..|
|00002e10| 58 0a 58 4f 72 61 70 65 | 72 6c 20 6a 75 73 74 20 |X.XOrape|rl just |
|00002e20| 6c 69 6e 6b 73 20 74 6f | 20 74 68 65 20 4f 72 61 |links to| the Ora|
|00002e30| 63 6c 65 20 50 72 6f 2a | 43 20 6c 69 62 72 61 72 |cle Pro*|C librar|
|00002e40| 69 65 73 20 69 6e 20 74 | 68 65 20 73 61 6d 65 20 |ies in t|he same |
|00002e50| 77 61 79 20 61 73 20 61 | 6e 79 0a 58 6f 74 68 65 |way as a|ny.Xothe|
|00002e60| 72 20 50 72 6f 2a 43 20 | 70 72 6f 67 72 61 6d 2c |r Pro*C |program,|
|00002e70| 20 73 6f 20 67 69 76 65 | 20 69 74 20 74 68 65 20 | so give| it the |
|00002e80| 73 61 6d 65 20 6c 69 62 | 72 61 72 69 65 73 20 61 |same lib|raries a|
|00002e90| 73 20 79 6f 75 20 77 6f | 75 6c 64 20 67 69 76 65 |s you wo|uld give|
|00002ea0| 20 6f 6e 65 0a 58 6f 66 | 20 79 6f 75 72 20 6f 77 | one.Xof| your ow|
|00002eb0| 6e 20 70 72 6f 67 72 61 | 6d 73 2e 20 53 65 65 20 |n progra|ms. See |
|00002ec0| 79 6f 75 72 20 50 72 6f | 2a 43 20 6d 61 6e 75 61 |your Pro|*C manua|
|00002ed0| 6c 20 6f 72 20 65 78 61 | 6d 70 6c 65 20 70 72 6f |l or exa|mple pro|
|00002ee0| 67 72 61 6d 73 20 66 6f | 72 20 64 65 74 61 69 6c |grams fo|r detail|
|00002ef0| 73 2e 0a 58 0a 58 48 6f | 77 65 76 65 72 2c 20 74 |s..X.XHo|wever, t|
|00002f00| 77 6f 20 70 65 6f 70 6c | 65 20 73 65 6e 74 20 6d |wo peopl|e sent m|
|00002f10| 65 20 74 68 65 69 72 20 | 6d 6f 64 69 66 69 65 64 |e their |modified|
|00002f20| 20 4d 61 6b 65 66 69 6c | 65 73 20 66 6f 72 20 4f | Makefil|es for O|
|00002f30| 72 61 63 6c 65 20 76 35 | 2e 20 53 69 6e 63 65 0a |racle v5|. Since.|
|00002f40| 58 74 68 65 79 20 61 72 | 65 20 64 69 66 66 65 72 |Xthey ar|e differ|
|00002f50| 65 6e 74 20 69 6e 20 65 | 66 66 65 63 74 2c 20 6e |ent in e|ffect, n|
|00002f60| 6f 74 20 6f 6e 6c 79 20 | 69 6e 20 70 72 65 73 65 |ot only |in prese|
|00002f70| 6e 74 61 74 69 6f 6e 2c | 20 49 20 61 73 73 75 6d |ntation,| I assum|
|00002f80| 65 20 74 68 61 74 20 74 | 68 65 0a 58 64 69 72 65 |e that t|he.Xdire|
|00002f90| 63 74 6f 72 79 20 73 74 | 72 75 63 74 75 72 65 20 |ctory st|ructure |
|00002fa0| 6f 66 20 4f 72 61 63 6c | 65 20 76 61 72 69 65 73 |of Oracl|e varies|
|00002fb0| 20 62 65 74 77 65 65 6e | 20 73 79 73 74 65 6d 73 | between| systems|
|00002fc0| 2e 20 54 68 65 20 74 77 | 6f 20 73 65 74 75 70 73 |. The tw|o setups|
|00002fd0| 20 49 20 77 61 73 0a 58 | 73 65 6e 74 20 61 72 65 | I was.X|sent are|
|00002fe0| 20 72 65 70 72 6f 64 75 | 63 65 64 20 62 65 6c 6f | reprodu|ced belo|
|00002ff0| 77 2e 20 4d 61 79 62 65 | 20 6f 6e 65 20 6f 66 20 |w. Maybe| one of |
|00003000| 74 68 65 6d 20 77 69 6c | 6c 20 62 65 20 73 75 69 |them wil|l be sui|
|00003010| 74 61 62 6c 65 20 66 6f | 72 20 79 6f 75 72 0a 58 |table fo|r your.X|
|00003020| 73 79 73 74 65 6d 20 69 | 66 20 6d 69 6e 65 20 69 |system i|f mine i|
|00003030| 73 6e 27 74 2e 0a 58 0a | 58 46 69 72 73 74 20 6d |sn't..X.|XFirst m|
|00003040| 65 74 68 6f 64 20 2d 20 | 74 68 69 73 20 61 73 73 |ethod - |this ass|
|00003050| 75 6d 65 73 20 74 68 61 | 74 20 74 68 65 20 6c 69 |umes tha|t the li|
|00003060| 62 72 61 72 69 65 73 20 | 6c 69 76 65 20 75 6e 64 |braries |live und|
|00003070| 65 72 20 24 4f 52 41 43 | 4c 45 5f 48 4f 4d 45 2f |er $ORAC|LE_HOME/|
|00003080| 63 2f 6c 69 62 73 0a 58 | 61 6e 64 20 24 4f 52 41 |c/libs.X|and $ORA|
|00003090| 43 4c 45 5f 48 4f 4d 45 | 2f 72 64 62 6d 73 2f 6c |CLE_HOME|/rdbms/l|
|000030a0| 69 62 73 2c 20 61 73 20 | 77 65 6c 6c 20 61 73 20 |ibs, as |well as |
|000030b0| 72 65 71 75 69 72 69 6e | 67 20 61 6e 20 61 64 64 |requirin|g an add|
|000030c0| 69 74 69 6f 6e 61 6c 20 | 2e 6f 20 66 69 6c 65 2e |itional |.o file.|
|000030d0| 0a 58 0a 58 3e 20 4f 52 | 41 4c 49 42 53 09 3d 20 |.X.X> OR|ALIBS.= |
|000030e0| 2d 6c 6f 63 69 63 20 2d | 6c 6f 72 61 63 6c 65 20 |-locic -|loracle |
|000030f0| 2d 6c 75 70 69 20 2d 6c | 6f 73 64 20 2d 6c 6f 73 |-lupi -l|osd -los|
|00003100| 6e 20 2d 6c 6f 72 61 63 | 6c 65 20 5c 0a 58 3e 09 |n -lorac|le \.X>.|
|00003110| 24 28 4f 52 41 43 4c 45 | 5f 48 4f 4d 45 29 2f 72 |$(ORACLE|_HOME)/r|
|00003120| 64 62 6d 73 2f 6c 69 62 | 73 2f 6f 73 6e 74 61 62 |dbms/lib|s/osntab|
|00003130| 2e 6f 20 2d 6c 75 74 74 | 20 2d 6c 6f 73 64 20 2d |.o -lutt| -losd -|
|00003140| 6c 6f 73 6e 20 2d 6c 63 | 6c 69 62 30 0a 58 3e 0a |losn -lc|lib0.X>.|
|00003150| 58 3e 20 4c 44 46 4c 41 | 47 53 09 3d 20 2d 4c 24 |X> LDFLA|GS.= -L$|
|00003160| 28 4f 52 41 43 4c 45 5f | 48 4f 4d 45 29 2f 63 2f |(ORACLE_|HOME)/c/|
|00003170| 6c 69 62 73 20 2d 4c 24 | 28 4f 52 41 43 4c 45 5f |libs -L$|(ORACLE_|
|00003180| 48 4f 4d 45 29 2f 72 64 | 62 6d 73 2f 6c 69 62 73 |HOME)/rd|bms/libs|
|00003190| 0a 58 3e 0a 58 3e 20 6f | 72 61 70 65 72 6c 3a 20 |.X>.X> o|raperl: |
|000031a0| 24 28 53 52 43 29 2f 75 | 70 65 72 6c 2e 6f 20 24 |$(SRC)/u|perl.o $|
|000031b0| 28 4f 42 4a 53 29 0a 58 | 3e 20 09 24 28 43 43 29 |(OBJS).X|> .$(CC)|
|000031c0| 20 2d 6f 20 6f 72 61 70 | 65 72 6c 20 24 28 4c 44 | -o orap|erl $(LD|
|000031d0| 46 4c 41 47 53 29 20 24 | 28 53 52 43 29 2f 75 70 |FLAGS) $|(SRC)/up|
|000031e0| 65 72 6c 2e 6f 20 24 28 | 4f 42 4a 53 29 20 24 28 |erl.o $(|OBJS) $(|
|000031f0| 4f 52 41 4c 49 42 53 29 | 20 24 28 4c 49 42 53 29 |ORALIBS)| $(LIBS)|
|00003200| 0a 58 0a 58 53 65 63 6f | 6e 64 20 6d 65 74 68 6f |.X.XSeco|nd metho|
|00003210| 64 20 2d 20 6d 75 63 68 | 20 73 69 6d 70 6c 65 72 |d - much| simpler|
|00003220| 2e 20 4f 6e 6c 79 20 73 | 65 65 6d 73 20 74 6f 20 |. Only s|eems to |
|00003230| 72 65 71 75 69 72 65 20 | 74 68 65 20 66 69 72 73 |require |the firs|
|00003240| 74 20 74 77 6f 20 6c 69 | 62 72 61 72 69 65 73 0a |t two li|braries.|
|00003250| 58 28 6c 69 62 6f 63 69 | 63 20 61 6e 64 20 6c 69 |X(liboci|c and li|
|00003260| 62 6f 72 61 63 6c 65 29 | 20 6f 66 20 74 68 65 20 |boracle)| of the |
|00003270| 70 72 65 76 69 6f 75 73 | 20 6d 65 74 68 6f 64 2c |previous| method,|
|00003280| 20 62 75 74 20 74 68 69 | 73 20 74 69 6d 65 20 74 | but thi|s time t|
|00003290| 68 65 79 20 6c 69 76 65 | 20 75 6e 64 65 72 0a 58 |hey live| under.X|
|000032a0| 24 4f 52 41 43 4c 45 5f | 48 4f 4d 45 2f 70 72 6f |$ORACLE_|HOME/pro|
|000032b0| 2e 0a 58 0a 58 3e 20 4f | 54 48 45 52 4c 49 42 53 |..X.X> O|THERLIBS|
|000032c0| 09 3d 0a 58 3e 20 43 4c | 49 42 53 09 09 3d 20 24 |.=.X> CL|IBS..= $|
|000032d0| 28 4f 54 48 45 52 4c 49 | 42 53 29 0a 58 3e 20 4f |(OTHERLI|BS).X> O|
|000032e0| 43 49 4c 49 42 09 3d 20 | 24 28 4f 52 41 43 4c 45 |CILIB.= |$(ORACLE|
|000032f0| 5f 48 4f 4d 45 29 2f 70 | 72 6f 2f 6c 69 62 6f 63 |_HOME)/p|ro/liboc|
|00003300| 69 63 2e 61 0a 58 3e 20 | 4e 45 54 4c 49 42 53 09 |ic.a.X> |NETLIBS.|
|00003310| 3d 0a 58 3e 20 4f 52 41 | 4c 49 42 53 09 3d 20 24 |=.X> ORA|LIBS.= $|
|00003320| 28 4f 52 41 43 4c 45 5f | 48 4f 4d 45 29 2f 70 72 |(ORACLE_|HOME)/pr|
|00003330| 6f 2f 6c 69 62 6f 72 61 | 63 6c 65 2e 61 0a 58 0a |o/libora|cle.a.X.|
|00003340| 58 54 68 61 6e 6b 73 20 | 74 6f 20 4d 61 72 6b 20 |XThanks |to Mark |
|00003350| 41 64 61 6d 73 20 61 6e | 64 20 4e 6f 72 6d 61 6e |Adams an|d Norman|
|00003360| 20 46 72 65 63 68 20 66 | 6f 72 20 74 68 65 69 72 | Frech f|or their|
|00003370| 20 68 65 6c 70 2e 0a 45 | 4e 44 5f 4f 46 5f 46 49 | help..E|ND_OF_FI|
|00003380| 4c 45 0a 20 20 69 66 20 | 74 65 73 74 20 34 35 37 |LE.  if |test 457|
|00003390| 39 20 2d 6e 65 20 60 77 | 63 20 2d 63 20 3c 27 48 |9 -ne `w|c -c <'H|
|000033a0| 69 6e 74 73 27 60 3b 20 | 74 68 65 6e 0a 20 20 20 |ints'`; |then.   |
|000033b0| 20 65 63 68 6f 20 73 68 | 61 72 3a 20 5c 22 27 48 | echo sh|ar: \"'H|
|000033c0| 69 6e 74 73 27 5c 22 20 | 75 6e 70 61 63 6b 65 64 |ints'\" |unpacked|
|000033d0| 20 77 69 74 68 20 77 72 | 6f 6e 67 20 73 69 7a 65 | with wr|ong size|
|000033e0| 21 0a 20 20 66 69 0a 20 | 20 23 20 65 6e 64 20 6f |!.  fi. | # end o|
|000033f0| 66 20 27 48 69 6e 74 73 | 27 0a 66 69 0a 69 66 20 |f 'Hints|'.fi.if |
|00003400| 74 65 73 74 20 2d 66 20 | 27 4d 61 6b 65 66 69 6c |test -f |'Makefil|
|00003410| 65 27 20 2d 61 20 22 24 | 7b 31 7d 22 20 21 3d 20 |e' -a "$|{1}" != |
|00003420| 22 2d 63 22 20 3b 20 74 | 68 65 6e 20 0a 20 20 65 |"-c" ; t|hen .  e|
|00003430| 63 68 6f 20 73 68 61 72 | 3a 20 57 69 6c 6c 20 6e |cho shar|: Will n|
|00003440| 6f 74 20 63 6c 6f 62 62 | 65 72 20 65 78 69 73 74 |ot clobb|er exist|
|00003450| 69 6e 67 20 66 69 6c 65 | 20 5c 22 27 4d 61 6b 65 |ing file| \"'Make|
|00003460| 66 69 6c 65 27 5c 22 0a | 65 6c 73 65 0a 20 20 65 |file'\".|else.  e|
|00003470| 63 68 6f 20 73 68 61 72 | 3a 20 45 78 74 72 61 63 |cho shar|: Extrac|
|00003480| 74 69 6e 67 20 5c 22 27 | 4d 61 6b 65 66 69 6c 65 |ting \"'|Makefile|
|00003490| 27 5c 22 20 5c 28 34 30 | 37 37 20 63 68 61 72 61 |'\" \(40|77 chara|
|000034a0| 63 74 65 72 73 5c 29 0a | 20 20 73 65 64 20 22 73 |cters\).|  sed "s|
|000034b0| 2f 5e 58 2f 2f 22 20 3e | 27 4d 61 6b 65 66 69 6c |/^X//" >|'Makefil|
|000034c0| 65 27 20 3c 3c 27 45 4e | 44 5f 4f 46 5f 46 49 4c |e' <<'EN|D_OF_FIL|
|000034d0| 45 27 0a 58 23 20 4d 61 | 6b 65 66 69 6c 65 20 66 |E'.X# Ma|kefile f|
|000034e0| 6f 72 20 4f 72 61 70 65 | 72 6c 20 61 6e 64 20 43 |or Orape|rl and C|
|000034f0| 6f 72 61 70 65 72 6c 0a | 58 0a 58 23 20 43 68 61 |oraperl.|X.X# Cha|
|00003500| 6e 67 65 20 74 68 65 73 | 65 20 74 6f 20 79 6f 75 |nge thes|e to you|
|00003510| 72 20 4f 52 41 43 4c 45 | 20 69 6e 73 74 61 6c 6c |r ORACLE| install|
|00003520| 61 74 69 6f 6e 20 64 69 | 72 65 63 74 6f 72 79 20 |ation di|rectory |
|00003530| 61 6e 64 20 50 65 72 6c | 20 73 6f 75 72 63 65 20 |and Perl| source |
|00003540| 64 69 72 65 63 74 6f 72 | 79 0a 58 23 0a 58 4f 52 |director|y.X#.XOR|
|00003550| 41 43 4c 45 5f 48 4f 4d | 45 09 3d 20 2f 75 73 72 |ACLE_HOM|E.= /usr|
|00003560| 2f 73 6f 66 74 2f 6f 72 | 61 63 6c 65 0a 58 53 52 |/soft/or|acle.XSR|
|00003570| 43 09 09 3d 20 2f 75 73 | 72 2f 73 6f 66 74 2f 70 |C..= /us|r/soft/p|
|00003580| 75 62 6c 69 63 2f 70 65 | 72 6c 0a 58 0a 58 23 20 |ublic/pe|rl.X.X# |
|00003590| 4f 72 61 63 6c 65 20 44 | 65 66 69 6e 69 74 69 6f |Oracle D|efinitio|
|000035a0| 6e 73 2c 20 63 6f 70 69 | 65 64 20 66 72 6f 6d 20 |ns, copi|ed from |
|000035b0| 24 28 4f 52 41 43 4c 45 | 5f 48 4f 4d 45 29 2f 63 |$(ORACLE|_HOME)/c|
|000035c0| 2f 64 65 6d 6f 2f 70 72 | 6f 63 2e 6d 6b 0a 58 23 |/demo/pr|oc.mk.X#|
|000035d0| 20 41 4c 4c 5f 4f 52 41 | 5f 4c 49 42 53 20 69 73 | ALL_ORA|_LIBS is|
|000035e0| 20 74 68 65 20 6f 6e 6c | 79 20 65 6e 74 72 79 20 | the onl|y entry |
|000035f0| 74 68 61 74 20 74 68 65 | 20 4d 61 6b 65 66 69 6c |that the| Makefil|
|00003600| 65 20 61 63 74 75 61 6c | 6c 79 20 75 73 65 73 3b |e actual|ly uses;|
|00003610| 0a 58 23 20 63 68 61 6e | 67 65 20 69 74 20 74 6f |.X# chan|ge it to|
|00003620| 20 77 68 61 74 65 76 65 | 72 20 79 6f 75 20 6e 65 | whateve|r you ne|
|00003630| 65 64 20 74 6f 20 6c 69 | 6e 6b 20 50 72 6f 2a 43 |ed to li|nk Pro*C|
|00003640| 20 70 72 6f 67 72 61 6d | 73 0a 58 23 0a 58 4f 54 | program|s.X#.XOT|
|00003650| 48 45 52 4c 49 42 53 09 | 3d 20 60 63 61 74 20 24 |HERLIBS.|= `cat $|
|00003660| 28 4f 52 41 43 4c 45 5f | 48 4f 4d 45 29 2f 72 64 |(ORACLE_|HOME)/rd|
|00003670| 62 6d 73 2f 6c 69 62 2f | 73 79 73 6c 69 62 6c 69 |bms/lib/|syslibli|
|00003680| 73 74 60 0a 58 43 4c 49 | 42 53 09 09 3d 20 24 28 |st`.XCLI|BS..= $(|
|00003690| 4f 54 48 45 52 4c 49 42 | 53 29 0a 58 4f 43 49 4c |OTHERLIB|S).XOCIL|
|000036a0| 49 42 09 09 3d 20 24 28 | 4f 52 41 43 4c 45 5f 48 |IB..= $(|ORACLE_H|
|000036b0| 4f 4d 45 29 2f 72 64 62 | 6d 73 2f 6c 69 62 2f 6c |OME)/rdb|ms/lib/l|
|000036c0| 69 62 6f 63 69 63 2e 61 | 0a 58 4e 45 54 4c 49 42 |ibocic.a|.XNETLIB|
|000036d0| 53 09 09 3d 20 24 28 4f | 52 41 43 4c 45 5f 48 4f |S..= $(O|RACLE_HO|
|000036e0| 4d 45 29 2f 72 64 62 6d | 73 2f 6c 69 62 2f 6f 73 |ME)/rdbm|s/lib/os|
|000036f0| 6e 74 61 62 2e 6f 20 5c | 0a 58 09 09 09 24 28 4f |ntab.o \|.X...$(O|
|00003700| 52 41 43 4c 45 5f 48 4f | 4d 45 29 2f 72 64 62 6d |RACLE_HO|ME)/rdbm|
|00003710| 73 2f 6c 69 62 2f 6c 69 | 62 73 71 6c 6e 65 74 2e |s/lib/li|bsqlnet.|
|00003720| 61 20 0a 58 4f 52 41 4c | 49 42 53 09 09 3d 20 24 |a .XORAL|IBS..= $|
|00003730| 28 4f 52 41 43 4c 45 5f | 48 4f 4d 45 29 2f 72 64 |(ORACLE_|HOME)/rd|
|00003740| 62 6d 73 2f 6c 69 62 2f | 6c 69 62 6f 72 61 2e 61 |bms/lib/|libora.a|
|00003750| 0a 58 0a 58 41 4c 4c 5f | 4f 52 41 5f 4c 49 42 53 |.X.XALL_|ORA_LIBS|
|00003760| 09 3d 20 24 28 43 4c 49 | 42 53 29 20 24 28 4f 43 |.= $(CLI|BS) $(OC|
|00003770| 49 4c 49 42 29 20 24 28 | 4e 45 54 4c 49 42 53 29 |ILIB) $(|NETLIBS)|
|00003780| 20 24 28 4f 52 41 4c 49 | 42 53 29 0a 58 0a 58 23 | $(ORALI|BS).X.X#|
|00003790| 20 50 65 72 6c 20 44 65 | 66 69 6e 69 74 69 6f 6e | Perl De|finition|
|000037a0| 73 2c 20 74 61 6b 65 6e | 20 66 72 6f 6d 20 24 53 |s, taken| from $S|
|000037b0| 52 43 2f 75 73 75 62 2f | 4d 61 6b 65 66 69 6c 65 |RC/usub/|Makefile|
|000037c0| 0a 58 23 20 44 6f 6e 27 | 74 20 69 6e 63 6c 75 64 |.X# Don'|t includ|
|000037d0| 65 20 74 68 65 20 63 75 | 72 73 65 73 20 6c 69 62 |e the cu|rses lib|
|000037e0| 72 61 72 69 65 73 20 68 | 65 72 65 20 2d 20 74 68 |raries h|ere - th|
|000037f0| 65 79 20 67 6f 20 69 6e | 20 43 55 52 53 45 4c 49 |ey go in| CURSELI|
|00003800| 42 0a 58 23 0a 58 47 4c | 4f 42 49 4e 43 53 09 3d |B.X#.XGL|OBINCS.=|
|00003810| 20 0a 58 4c 4f 43 49 4e | 43 53 09 09 3d 20 0a 58 | .XLOCIN|CS..= .X|
|00003820| 4c 49 42 53 09 09 3d 20 | 60 2e 20 24 28 53 52 43 |LIBS..= |`. $(SRC|
|00003830| 29 2f 63 6f 6e 66 69 67 | 2e 73 68 3b 20 65 63 68 |)/config|.sh; ech|
|00003840| 6f 20 24 24 6c 69 62 73 | 60 0a 58 0a 58 23 20 4f |o $$libs|`.X.X# O|
|00003850| 72 61 70 65 72 6c 20 44 | 65 66 69 6e 69 74 69 6f |raperl D|efinitio|
|00003860| 6e 73 0a 58 0a 58 23 20 | 53 65 74 20 44 45 42 55 |ns.X.X# |Set DEBU|
|00003870| 47 20 74 6f 20 2d 44 44 | 45 42 55 47 47 49 4e 47 |G to -DD|EBUGGING|
|00003880| 2c 20 2d 44 50 45 52 4c | 5f 44 45 42 55 47 47 49 |, -DPERL|_DEBUGGI|
|00003890| 4e 47 20 6f 72 20 6c 65 | 61 76 65 20 62 6c 61 6e |NG or le|ave blan|
|000038a0| 6b 20 28 73 65 65 20 6f | 72 61 66 6e 73 2e 68 29 |k (see o|rafns.h)|
|000038b0| 0a 58 23 20 49 66 20 69 | 74 20 69 73 20 6e 6f 74 |.X# If i|t is not|
|000038c0| 20 62 6c 61 6e 6b 2c 20 | 75 6e 63 6f 6d 6d 65 6e | blank, |uncommen|
|000038d0| 74 20 74 68 65 20 64 65 | 66 69 6e 69 74 69 6f 6e |t the de|finition|
|000038e0| 20 6f 66 20 44 42 55 47 | 5f 4f 0a 58 23 0a 58 44 | of DBUG|_O.X#.XD|
|000038f0| 45 42 55 47 09 09 3d 20 | 2d 44 50 45 52 4c 5f 44 |EBUG..= |-DPERL_D|
|00003900| 45 42 55 47 47 49 4e 47 | 0a 58 44 42 55 47 5f 4f |EBUGGING|.XDBUG_O|
|00003910| 09 09 3d 20 64 62 75 67 | 2f 64 62 75 67 2e 6f 0a |..= dbug|/dbug.o.|
|00003920| 58 0a 58 23 20 43 75 72 | 73 65 73 20 6c 69 62 72 |X.X# Cur|ses libr|
|00003930| 61 72 69 65 73 2c 20 6f | 6e 6c 79 20 72 65 71 75 |aries, o|nly requ|
|00003940| 69 72 65 64 20 69 66 20 | 79 6f 75 20 77 61 6e 74 |ired if |you want|
|00003950| 20 74 6f 20 62 75 69 6c | 64 20 43 6f 72 61 70 65 | to buil|d Corape|
|00003960| 72 6c 0a 58 23 20 59 6f | 75 20 6d 61 79 20 61 6c |rl.X# Yo|u may al|
|00003970| 73 6f 20 6e 65 65 64 20 | 2d 6c 74 65 72 6d 6c 69 |so need |-ltermli|
|00003980| 62 20 6f 72 20 2d 6c 74 | 65 72 6d 63 61 70 0a 58 |b or -lt|ermcap.X|
|00003990| 23 0a 58 43 55 52 53 45 | 4c 49 42 09 3d 20 2d 6c |#.XCURSE|LIB.= -l|
|000039a0| 63 75 72 73 65 73 0a 58 | 0a 58 23 20 52 6f 77 20 |curses.X|.X# Row |
|000039b0| 63 61 63 68 65 20 73 69 | 7a 65 20 66 6f 72 20 53 |cache si|ze for S|
|000039c0| 45 4c 45 43 54 20 73 74 | 61 74 65 6d 65 6e 74 73 |ELECT st|atements|
|000039d0| 2e 0a 58 23 20 49 66 20 | 79 6f 75 20 77 61 6e 74 |..X# If |you want|
|000039e0| 20 74 6f 20 63 68 61 6e | 67 65 20 74 68 65 20 64 | to chan|ge the d|
|000039f0| 65 66 61 75 6c 74 2c 20 | 75 6e 63 6f 6d 6d 65 6e |efault, |uncommen|
|00003a00| 74 20 74 68 69 73 20 61 | 6e 64 20 73 65 74 20 74 |t this a|nd set t|
|00003a10| 68 65 20 76 61 6c 75 65 | 20 79 6f 75 20 77 61 6e |he value| you wan|
|00003a20| 74 0a 58 23 0a 58 23 43 | 41 43 48 45 09 09 3d 20 |t.X#.X#C|ACHE..= |
|00003a30| 2d 44 43 41 43 48 45 5f | 53 49 5a 45 3d 35 0a 58 |-DCACHE_|SIZE=5.X|
|00003a40| 0a 58 23 20 42 69 6e 64 | 20 76 61 72 69 61 62 6c |.X# Bind| variabl|
|00003a50| 65 20 70 61 64 64 69 6e | 67 2e 0a 58 23 20 49 66 |e paddin|g..X# If|
|00003a60| 20 79 6f 75 20 77 61 6e | 74 20 62 69 6e 64 69 6e | you wan|t bindin|
|00003a70| 67 20 61 6e 20 65 6d 70 | 74 79 20 73 74 72 69 6e |g an emp|ty strin|
|00003a80| 67 20 74 6f 20 70 72 6f | 76 6f 6b 65 20 61 6e 20 |g to pro|voke an |
|00003a90| 65 72 72 6f 72 2c 20 75 | 6e 63 6f 6d 6d 65 6e 74 |error, u|ncomment|
|00003aa0| 20 74 68 69 73 20 6c 69 | 6e 65 2e 0a 58 23 0a 58 | this li|ne..X#.X|
|00003ab0| 23 42 49 4e 44 09 09 3d | 20 2d 44 4e 4f 5f 42 49 |#BIND..=| -DNO_BI|
|00003ac0| 4e 44 5f 50 41 44 44 49 | 4e 47 0a 58 0a 58 23 20 |ND_PADDI|NG.X.X# |
|00003ad0| 53 6f 6d 65 20 73 79 73 | 74 65 6d 2d 73 70 65 63 |Some sys|tem-spec|
|00003ae0| 69 66 69 63 20 74 68 69 | 6e 67 73 0a 58 23 0a 58 |ific thi|ngs.X#.X|
|00003af0| 23 20 49 66 20 79 6f 75 | 72 20 73 79 73 74 65 6d |# If you|r system|
|00003b00| 20 6c 69 62 72 61 72 79 | 20 64 6f 65 73 20 6e 6f | library| does no|
|00003b10| 74 20 69 6e 63 6c 75 64 | 65 20 73 74 72 74 6f 75 |t includ|e strtou|
|00003b20| 6c 2c 20 75 6e 63 6f 6d | 6d 65 6e 74 20 74 68 65 |l, uncom|ment the|
|00003b30| 20 6e 65 78 74 20 6c 69 | 6e 65 0a 58 53 54 52 54 | next li|ne.XSTRT|
|00003b40| 4f 55 4c 09 3d 20 73 74 | 72 74 6f 75 6c 2e 6f 0a |OUL.= st|rtoul.o.|
|00003b50| 58 23 0a 58 23 20 49 66 | 20 79 6f 75 20 61 72 65 |X#.X# If| you are|
|00003b60| 20 75 73 69 6e 67 20 50 | 65 72 6c 20 76 33 20 69 | using P|erl v3 i|
|00003b70| 6e 73 74 65 61 64 20 6f | 66 20 76 34 2c 20 75 6e |nstead o|f v4, un|
|00003b80| 63 6f 6d 6d 65 6e 74 20 | 74 68 65 20 6e 65 78 74 |comment |the next|
|00003b90| 20 6c 69 6e 65 0a 58 23 | 20 53 54 52 5f 32 4d 4f | line.X#| STR_2MO|
|00003ba0| 52 54 41 4c 09 3d 20 2d | 44 73 74 72 5f 32 6d 6f |RTAL.= -|Dstr_2mo|
|00003bb0| 72 74 61 6c 3d 73 74 72 | 5f 32 73 74 61 74 69 63 |rtal=str|_2static|
|00003bc0| 0a 58 0a 58 23 20 44 61 | 74 61 62 61 73 65 2c 20 |.X.X# Da|tabase, |
|00003bd0| 75 73 65 72 6e 61 6d 65 | 20 61 6e 64 20 70 61 73 |username| and pas|
|00003be0| 73 77 6f 72 64 20 74 6f | 20 75 73 65 20 66 6f 72 |sword to| use for|
|00003bf0| 20 74 65 73 74 69 6e 67 | 0a 58 23 0a 58 54 45 53 | testing|.X#.XTES|
|00003c00| 54 44 41 54 41 09 3d 20 | 74 20 73 63 6f 74 74 20 |TDATA.= |t scott |
|00003c10| 74 69 67 65 72 0a 58 0a | 58 0a 58 23 0a 58 23 09 |tiger.X.|X.X#.X#.|
|00003c20| 4c 65 61 76 65 20 74 68 | 65 73 65 20 62 6c 61 6e |Leave th|ese blan|
|00003c30| 6b 20 6c 69 6e 65 73 20 | 73 6f 20 74 68 61 74 20 |k lines |so that |
|00003c40| 70 61 74 63 68 65 73 20 | 74 6f 20 77 68 61 74 20 |patches |to what |
|00003c50| 69 73 20 62 65 6c 6f 77 | 0a 58 23 09 77 6f 6e 27 |is below|.X#.won'|
|00003c60| 74 20 62 65 20 75 70 73 | 65 74 20 62 79 20 79 6f |t be ups|et by yo|
|00003c70| 75 72 20 63 68 61 6e 67 | 65 73 20 74 6f 20 74 68 |ur chang|es to th|
|00003c80| 65 20 73 65 74 75 70 73 | 20 61 62 6f 76 65 2e 0a |e setups| above..|
|00003c90| 58 23 0a 58 0a 58 0a 58 | 23 20 46 72 6f 6d 20 68 |X#.X.X.X|# From h|
|00003ca0| 65 72 65 20 6f 6e 2c 20 | 79 6f 75 20 73 68 6f 75 |ere on, |you shou|
|00003cb0| 6c 64 6e 27 74 20 6e 65 | 65 64 20 74 6f 20 63 68 |ldn't ne|ed to ch|
|00003cc0| 61 6e 67 65 20 61 6e 79 | 74 68 69 6e 67 2e 20 49 |ange any|thing. I|
|00003cd0| 66 20 79 6f 75 20 64 6f | 2c 20 6c 65 74 20 6d 65 |f you do|, let me|
|00003ce0| 20 6b 6e 6f 77 2e 0a 58 | 0a 58 53 52 43 53 09 09 | know..X|.XSRCS..|
|00003cf0| 3d 20 6f 72 61 63 6c 65 | 2e 6d 75 73 20 6f 72 61 |= oracle|.mus ora|
|00003d00| 66 6e 73 2e 63 20 67 65 | 74 63 75 72 73 6f 72 2e |fns.c ge|tcursor.|
|00003d10| 63 20 63 6f 6c 6f 6e 73 | 2e 63 20 75 73 65 72 73 |c colons|.c users|
|00003d20| 75 62 2e 63 20 5c 0a 58 | 09 09 20 20 64 65 62 75 |ub.c \.X|..  debu|
|00003d30| 67 2e 63 20 73 74 72 74 | 6f 75 6c 2e 63 0a 58 4f |g.c strt|oul.c.XO|
|00003d40| 42 4a 53 09 09 3d 20 6f | 72 61 63 6c 65 2e 6f 20 |BJS..= o|racle.o |
|00003d50| 6f 72 61 66 6e 73 2e 6f | 20 67 65 74 63 75 72 73 |orafns.o| getcurs|
|00003d60| 6f 72 2e 6f 20 63 6f 6c | 6f 6e 73 2e 6f 20 64 65 |or.o col|ons.o de|
|00003d70| 62 75 67 2e 6f 20 24 28 | 53 54 52 54 4f 55 4c 29 |bug.o $(|STRTOUL)|
|00003d80| 0a 58 4f 4f 42 4a 53 09 | 09 3d 20 24 28 4f 42 4a |.XOOBJS.|.= $(OBJ|
|00003d90| 53 29 20 75 73 65 72 73 | 75 62 2e 6f 20 24 28 44 |S) users|ub.o $(D|
|00003da0| 42 55 47 5f 4f 29 0a 58 | 43 4f 42 4a 53 09 09 3d |BUG_O).X|COBJS..=|
|00003db0| 20 24 28 4f 42 4a 53 29 | 20 63 75 73 65 72 73 75 | $(OBJS)| cusersu|
|00003dc0| 62 2e 6f 20 24 28 44 42 | 55 47 5f 4f 29 0a 58 48 |b.o $(DB|UG_O).XH|
|00003dd0| 44 52 53 09 09 3d 20 70 | 61 74 63 68 6c 65 76 65 |DRS..= p|atchleve|
|00003de0| 6c 2e 68 20 6f 72 61 66 | 6e 73 2e 68 0a 58 44 45 |l.h oraf|ns.h.XDE|
|00003df0| 46 53 09 09 3d 20 24 28 | 53 54 52 54 4f 4c 29 20 |FS..= $(|STRTOL) |
|00003e00| 24 28 50 55 54 45 4e 56 | 29 20 24 28 53 54 52 5f |$(PUTENV|) $(STR_|
|00003e10| 32 4d 4f 52 54 41 4c 29 | 20 24 28 44 45 42 55 47 |2MORTAL)| $(DEBUG|
|00003e20| 29 20 24 28 43 41 43 48 | 45 29 20 24 28 42 49 4e |) $(CACH|E) $(BIN|
|00003e30| 44 29 0a 58 0a 58 43 46 | 4c 41 47 53 09 09 3d 20 |D).X.XCF|LAGS..= |
|00003e40| 2d 49 64 62 75 67 20 2d | 49 24 28 53 52 43 29 20 |-Idbug -|I$(SRC) |
|00003e50| 24 28 47 4c 4f 42 49 4e | 43 53 29 20 24 28 4c 4f |$(GLOBIN|CS) $(LO|
|00003e60| 43 49 4e 43 53 29 20 24 | 28 44 45 46 53 29 0a 58 |CINCS) $|(DEFS).X|
|00003e70| 0a 58 6f 72 61 70 65 72 | 6c 3a 20 24 28 53 52 43 |.Xoraper|l: $(SRC|
|00003e80| 29 2f 75 70 65 72 6c 2e | 6f 20 24 28 4f 4f 42 4a |)/uperl.|o $(OOBJ|
|00003e90| 53 29 0a 58 09 24 28 43 | 43 29 20 2d 6f 20 6f 72 |S).X.$(C|C) -o or|
|00003ea0| 61 70 65 72 6c 20 24 28 | 53 52 43 29 2f 75 70 65 |aperl $(|SRC)/upe|
|00003eb0| 72 6c 2e 6f 20 24 28 4f | 4f 42 4a 53 29 09 09 09 |rl.o $(O|OBJS)...|
|00003ec0| 5c 0a 58 09 20 20 20 20 | 20 20 2d 6c 6d 20 24 28 |\.X.    |  -lm $(|
|00003ed0| 41 4c 4c 5f 4f 52 41 5f | 4c 49 42 53 29 20 24 28 |ALL_ORA_|LIBS) $(|
|00003ee0| 4c 49 42 53 29 0a 58 0a | 58 63 6f 72 61 70 65 72 |LIBS).X.|Xcoraper|
|00003ef0| 6c 3a 20 24 28 53 52 43 | 29 2f 75 70 65 72 6c 2e |l: $(SRC|)/uperl.|
|00003f00| 6f 20 24 28 43 4f 42 4a | 53 29 20 24 28 53 52 43 |o $(COBJ|S) $(SRC|
|00003f10| 29 2f 75 73 75 62 2f 63 | 75 72 73 65 73 2e 6f 0a |)/usub/c|urses.o.|
|00003f20| 58 09 24 28 43 43 29 20 | 2d 6f 20 63 6f 72 61 70 |X.$(CC) |-o corap|
|00003f30| 65 72 6c 20 24 28 53 52 | 43 29 2f 75 70 65 72 6c |erl $(SR|C)/uperl|
|00003f40| 2e 6f 20 24 28 43 4f 42 | 4a 53 29 20 24 28 53 52 |.o $(COB|JS) $(SR|
|00003f50| 43 29 2f 75 73 75 62 2f | 63 75 72 73 65 73 2e 6f |C)/usub/|curses.o|
|00003f60| 09 5c 0a 58 09 20 20 20 | 20 20 20 2d 6c 6d 20 24 |.\.X.   |   -lm $|
|00003f70| 28 41 4c 4c 5f 4f 52 41 | 5f 4c 49 42 53 29 20 24 |(ALL_ORA|_LIBS) $|
|00003f80| 28 4c 49 42 53 29 20 24 | 28 43 55 52 53 45 4c 49 |(LIBS) $|(CURSELI|
|00003f90| 42 29 0a 58 0a 58 61 6c | 6c 3a 09 6f 72 61 70 65 |B).X.Xal|l:.orape|
|00003fa0| 72 6c 20 63 6f 72 61 70 | 65 72 6c 0a 58 0a 58 74 |rl corap|erl.X.Xt|
|00003fb0| 65 73 74 3a 09 6f 72 61 | 70 65 72 6c 0a 58 09 40 |est:.ora|perl.X.@|
|00003fc0| 6f 72 61 70 65 72 6c 20 | 2d 65 20 27 26 6f 72 61 |oraperl |-e '&ora|
|00003fd0| 5f 76 65 72 73 69 6f 6e | 27 0a 58 09 40 28 63 64 |_version|'.X.@(cd|
|00003fe0| 20 74 65 73 74 64 69 72 | 20 3b 09 09 09 09 09 09 | testdir| ;......|
|00003ff0| 09 20 20 20 20 20 20 5c | 0a 58 09 20 20 72 6d 20 |.      \|.X.  rm |
|00004000| 2d 66 20 4d 79 2d 52 65 | 73 75 6c 74 73 20 3b 09 |-f My-Re|sults ;.|
|00004010| 09 09 09 09 09 20 20 20 | 20 20 20 5c 0a 58 09 20 |.....   |   \.X. |
|00004020| 20 65 63 68 6f 20 22 54 | 65 73 74 69 6e 67 20 6f | echo "T|esting o|
|00004030| 72 61 70 65 72 6c 2c 20 | 70 6c 65 61 73 65 20 77 |raperl, |please w|
|00004040| 61 69 74 20 2e 2e 2e 22 | 20 3b 09 09 09 20 20 20 |ait ..."| ;...   |
|00004050| 20 20 20 5c 0a 58 09 20 | 20 66 6f 72 20 69 20 69 |   \.X. | for i i|
|00004060| 6e 20 2a 2e 70 6c 09 3b | 20 64 6f 20 2e 2e 2f 6f |n *.pl.;| do ../o|
|00004070| 72 61 70 65 72 6c 20 24 | 24 69 20 24 28 54 45 53 |raperl $|$i $(TES|
|00004080| 54 44 41 54 41 29 20 3b | 20 64 6f 6e 65 20 3e 20 |TDATA) ;| done > |
|00004090| 4d 79 2d 52 65 73 75 6c | 74 73 20 3b 20 5c 0a 58 |My-Resul|ts ; \.X|
|000040a0| 09 20 20 69 66 20 63 6d | 70 20 2d 73 20 53 74 61 |.  if cm|p -s Sta|
|000040b0| 6e 64 61 72 64 2d 52 65 | 73 75 6c 74 73 20 4d 79 |ndard-Re|sults My|
|000040c0| 2d 52 65 73 75 6c 74 73 | 20 3b 09 09 09 20 20 20 |-Results| ;...   |
|000040d0| 20 20 20 5c 0a 58 09 20 | 20 74 68 65 6e 20 65 63 |   \.X. | then ec|
|000040e0| 68 6f 20 22 54 65 73 74 | 20 73 75 63 63 65 73 73 |ho "Test| success|
|000040f0| 66 75 6c 22 20 3b 09 09 | 09 09 09 20 20 20 20 20 |ful" ;..|...     |
|00004100| 20 5c 0a 58 09 20 20 65 | 6c 73 65 20 65 63 68 6f | \.X.  e|lse echo|
|00004110| 20 22 54 65 73 74 20 66 | 61 69 6c 65 64 20 2d 20 | "Test f|ailed - |
|00004120| 63 6f 6d 70 61 72 65 20 | 4d 79 2d 52 65 73 75 6c |compare |My-Resul|
|00004130| 74 73 20 77 69 74 68 20 | 53 74 61 6e 64 61 72 64 |ts with |Standard|
|00004140| 2d 52 65 73 75 6c 74 73 | 22 20 3b 5c 0a 58 09 20 |-Results|" ;\.X. |
|00004150| 20 66 69 3b 20 65 63 68 | 6f 29 0a 58 0a 58 23 20 | fi; ech|o).X.X# |
|00004160| 57 65 20 75 73 65 20 6f | 72 61 70 65 72 6c 20 61 |We use o|raperl a|
|00004170| 6c 74 68 6f 75 67 68 20 | 70 65 72 6c 20 77 6f 75 |lthough |perl wou|
|00004180| 6c 64 20 73 75 66 66 69 | 63 65 2c 20 62 65 63 61 |ld suffi|ce, beca|
|00004190| 75 73 65 20 77 65 20 6b | 6e 6f 77 20 77 68 65 72 |use we k|now wher|
|000041a0| 65 20 69 74 20 69 73 21 | 0a 58 0a 58 69 6e 73 74 |e it is!|.X.Xinst|
|000041b0| 61 6c 6c 3a 09 6f 72 61 | 70 65 72 6c 20 69 6e 73 |all:.ora|perl ins|
|000041c0| 74 61 6c 6c 2e 70 6c 0a | 58 09 40 2e 2f 6f 72 61 |tall.pl.|X.@./ora|
|000041d0| 70 65 72 6c 20 2e 2f 69 | 6e 73 74 61 6c 6c 2e 70 |perl ./i|nstall.p|
|000041e0| 6c 20 24 7b 53 52 43 7d | 0a 58 0a 58 63 75 73 65 |l ${SRC}|.X.Xcuse|
|000041f0| 72 73 75 62 2e 63 3a 09 | 75 73 65 72 73 75 62 2e |rsub.c:.|usersub.|
|00004200| 63 0a 58 09 40 72 6d 20 | 2d 66 20 63 75 73 65 72 |c.X.@rm |-f cuser|
|00004210| 73 75 62 2e 63 0a 58 09 | 6c 6e 20 75 73 65 72 73 |sub.c.X.|ln users|
|00004220| 75 62 2e 63 20 63 75 73 | 65 72 73 75 62 2e 63 0a |ub.c cus|ersub.c.|
|00004230| 58 0a 58 63 75 73 65 72 | 73 75 62 2e 6f 3a 09 63 |X.Xcuser|sub.o:.c|
|00004240| 75 73 65 72 73 75 62 2e | 63 0a 58 09 24 28 43 43 |usersub.|c.X.$(CC|
|00004250| 29 20 2d 63 20 24 28 43 | 46 4c 41 47 53 29 20 2d |) -c $(C|FLAGS) -|
|00004260| 44 43 55 52 53 45 53 20 | 63 75 73 65 72 73 75 62 |DCURSES |cusersub|
|00004270| 2e 63 0a 58 0a 58 6f 72 | 61 63 6c 65 2e 63 3a 20 |.c.X.Xor|acle.c: |
|00004280| 24 28 53 52 43 29 2f 75 | 73 75 62 2f 6d 75 73 20 |$(SRC)/u|sub/mus |
|00004290| 6f 72 61 63 6c 65 2e 6d | 75 73 0a 58 09 24 28 53 |oracle.m|us.X.$(S|
|000042a0| 52 43 29 2f 75 73 75 62 | 2f 6d 75 73 20 6f 72 61 |RC)/usub|/mus ora|
|000042b0| 63 6c 65 2e 6d 75 73 20 | 3e 6f 72 61 63 6c 65 2e |cle.mus |>oracle.|
|000042c0| 63 0a 58 0a 58 24 28 4f | 4f 42 4a 53 29 20 24 28 |c.X.X$(O|OBJS) $(|
|000042d0| 43 4f 42 4a 53 29 3a 09 | 24 28 48 44 52 53 29 0a |COBJS):.|$(HDRS).|
|000042e0| 58 0a 58 64 62 75 67 2f | 64 62 75 67 2e 6f 3a 0a |X.Xdbug/|dbug.o:.|
|000042f0| 58 09 28 63 64 20 64 62 | 75 67 20 3b 20 24 28 4d |X.(cd db|ug ; $(M|
|00004300| 41 4b 45 29 20 64 62 75 | 67 2e 6f 29 0a 58 09 40 |AKE) dbu|g.o).X.@|
|00004310| 65 63 68 6f 20 22 09 28 | 62 61 63 6b 20 74 6f 20 |echo ".(|back to |
|00004320| 6d 61 69 6e 20 64 69 72 | 65 63 74 6f 72 79 29 22 |main dir|ectory)"|
|00004330| 0a 58 0a 58 63 6c 65 61 | 6e 3a 0a 58 09 28 63 64 |.X.Xclea|n:.X.(cd|
|00004340| 20 64 62 75 67 20 3b 20 | 24 28 4d 41 4b 45 29 20 | dbug ; |$(MAKE) |
|00004350| 63 6c 65 61 6e 29 0a 58 | 09 40 65 63 68 6f 20 22 |clean).X|.@echo "|
|00004360| 09 28 62 61 63 6b 20 74 | 6f 20 6d 61 69 6e 20 64 |.(back t|o main d|
|00004370| 69 72 65 63 74 6f 72 79 | 29 22 0a 58 09 72 6d 20 |irectory|)".X.rm |
|00004380| 2d 66 20 6e 6f 68 75 70 | 2e 6f 75 74 20 2a 2e 6f |-f nohup|.out *.o|
|00004390| 20 6f 72 61 63 6c 65 2e | 63 20 63 75 73 65 72 73 | oracle.|c cusers|
|000043a0| 75 62 2e 63 0a 58 09 72 | 6d 20 2d 66 20 74 65 73 |ub.c.X.r|m -f tes|
|000043b0| 74 64 69 72 2f 4d 79 2d | 52 65 73 75 6c 74 73 20 |tdir/My-|Results |
|000043c0| 6c 69 73 74 69 6e 67 20 | 74 61 67 73 20 63 6f 72 |listing |tags cor|
|000043d0| 65 0a 58 0a 58 72 65 61 | 6c 63 6c 65 61 6e 20 63 |e.X.Xrea|lclean c|
|000043e0| 6c 6f 62 62 65 72 3a 09 | 63 6c 65 61 6e 0a 58 09 |lobber:.|clean.X.|
|000043f0| 28 63 64 20 64 62 75 67 | 20 3b 20 24 28 4d 41 4b |(cd dbug| ; $(MAK|
|00004400| 45 29 20 63 6c 6f 62 62 | 65 72 29 0a 58 09 28 63 |E) clobb|er).X.(c|
|00004410| 64 20 64 6f 63 20 3b 20 | 24 28 4d 41 4b 45 29 20 |d doc ; |$(MAKE) |
|00004420| 63 6c 6f 62 62 65 72 29 | 0a 58 09 40 65 63 68 6f |clobber)|.X.@echo|
|00004430| 20 22 09 28 62 61 63 6b | 20 74 6f 20 6d 61 69 6e | ".(back| to main|
|00004440| 20 64 69 72 65 63 74 6f | 72 79 29 22 0a 58 09 72 | directo|ry)".X.r|
|00004450| 6d 20 2d 66 20 6f 72 61 | 70 65 72 6c 20 63 6f 72 |m -f ora|perl cor|
|00004460| 61 70 65 72 6c 0a 58 0a | 58 6c 69 73 74 69 6e 67 |aperl.X.|Xlisting|
|00004470| 3a 0a 58 09 70 72 20 2d | 66 6e 20 4d 61 6b 65 66 |:.X.pr -|fn Makef|
|00004480| 69 6c 65 20 24 28 48 44 | 52 53 29 20 24 28 53 52 |ile $(HD|RS) $(SR|
|00004490| 43 53 29 20 3e 6c 69 73 | 74 69 6e 67 0a 58 0a 58 |CS) >lis|ting.X.X|
|000044a0| 64 6f 63 73 3a 0a 58 09 | 28 63 64 20 64 6f 63 20 |docs:.X.|(cd doc |
|000044b0| 3b 20 24 28 4d 41 4b 45 | 29 20 64 6f 63 73 29 0a |; $(MAKE|) docs).|
|000044c0| 58 09 40 65 63 68 6f 20 | 22 09 28 62 61 63 6b 20 |X.@echo |".(back |
|000044d0| 74 6f 20 6d 61 69 6e 20 | 64 69 72 65 63 74 6f 72 |to main |director|
|000044e0| 79 29 22 0a 58 0a 58 73 | 68 61 72 3a 09 63 6c 65 |y)".X.Xs|har:.cle|
|000044f0| 61 6e 0a 58 09 73 68 61 | 72 20 2d 6e 20 6f 72 61 |an.X.sha|r -n ora|
|00004500| 70 65 72 6c 2d 76 32 20 | 2d 61 20 2d 73 20 6b 73 |perl-v2 |-a -s ks|
|00004510| 74 6f 63 6b 40 65 6e 63 | 6f 72 65 2e 63 6f 6d 20 |tock@enc|ore.com |
|00004520| 2d 46 20 2d 6f 20 3a 50 | 61 72 74 20 2d 6c 20 36 |-F -o :P|art -l 6|
|00004530| 34 09 5c 0a 58 09 09 52 | 65 61 64 6d 65 20 5b 43 |4.\.X..R|eadme [C|
|00004540| 2d 51 5d 2a 20 52 6f 77 | 2a 20 5b 53 2d 7a 5d 2a |-Q]* Row|* [S-z]*|
|00004550| 0a 45 4e 44 5f 4f 46 5f | 46 49 4c 45 0a 20 20 69 |.END_OF_|FILE.  i|
|00004560| 66 20 74 65 73 74 20 34 | 30 37 37 20 2d 6e 65 20 |f test 4|077 -ne |
|00004570| 60 77 63 20 2d 63 20 3c | 27 4d 61 6b 65 66 69 6c |`wc -c <|'Makefil|
|00004580| 65 27 60 3b 20 74 68 65 | 6e 0a 20 20 20 20 65 63 |e'`; the|n.    ec|
|00004590| 68 6f 20 73 68 61 72 3a | 20 5c 22 27 4d 61 6b 65 |ho shar:| \"'Make|
|000045a0| 66 69 6c 65 27 5c 22 20 | 75 6e 70 61 63 6b 65 64 |file'\" |unpacked|
|000045b0| 20 77 69 74 68 20 77 72 | 6f 6e 67 20 73 69 7a 65 | with wr|ong size|
|000045c0| 21 0a 20 20 66 69 0a 20 | 20 23 20 65 6e 64 20 6f |!.  fi. | # end o|
|000045d0| 66 20 27 4d 61 6b 65 66 | 69 6c 65 27 0a 66 69 0a |f 'Makef|ile'.fi.|
|000045e0| 69 66 20 74 65 73 74 20 | 2d 66 20 27 52 65 61 64 |if test |-f 'Read|
|000045f0| 6d 65 27 20 2d 61 20 22 | 24 7b 31 7d 22 20 21 3d |me' -a "|${1}" !=|
|00004600| 20 22 2d 63 22 20 3b 20 | 74 68 65 6e 20 0a 20 20 | "-c" ; |then .  |
|00004610| 65 63 68 6f 20 73 68 61 | 72 3a 20 57 69 6c 6c 20 |echo sha|r: Will |
|00004620| 6e 6f 74 20 63 6c 6f 62 | 62 65 72 20 65 78 69 73 |not clob|ber exis|
|00004630| 74 69 6e 67 20 66 69 6c | 65 20 5c 22 27 52 65 61 |ting fil|e \"'Rea|
|00004640| 64 6d 65 27 5c 22 0a 65 | 6c 73 65 0a 20 20 65 63 |dme'\".e|lse.  ec|
|00004650| 68 6f 20 73 68 61 72 3a | 20 45 78 74 72 61 63 74 |ho shar:| Extract|
|00004660| 69 6e 67 20 5c 22 27 52 | 65 61 64 6d 65 27 5c 22 |ing \"'R|eadme'\"|
|00004670| 20 5c 28 35 34 38 35 20 | 63 68 61 72 61 63 74 65 | \(5485 |characte|
|00004680| 72 73 5c 29 0a 20 20 73 | 65 64 20 22 73 2f 5e 58 |rs\).  s|ed "s/^X|
|00004690| 2f 2f 22 20 3e 27 52 65 | 61 64 6d 65 27 20 3c 3c |//" >'Re|adme' <<|
|000046a0| 27 45 4e 44 5f 4f 46 5f | 46 49 4c 45 27 0a 58 54 |'END_OF_|FILE'.XT|
|000046b0| 68 69 73 20 69 73 20 61 | 6e 20 69 6e 73 74 61 6e |his is a|n instan|
|000046c0| 74 2d 6d 69 78 20 70 61 | 63 6b 61 67 65 20 28 6a |t-mix pa|ckage (j|
|000046d0| 75 73 74 20 61 64 64 20 | 50 65 72 6c 29 20 74 6f |ust add |Perl) to|
|000046e0| 20 63 72 65 61 74 65 20 | 4f 72 61 70 65 72 6c 2c | create |Oraperl,|
|000046f0| 0a 58 61 20 76 65 72 73 | 69 6f 6e 20 6f 66 20 50 |.Xa vers|ion of P|
|00004700| 65 72 6c 20 77 68 69 63 | 68 20 69 73 20 63 61 70 |erl whic|h is cap|
|00004710| 61 62 6c 65 20 6f 66 20 | 61 63 63 65 73 73 69 6e |able of |accessin|
|00004720| 67 20 4f 72 61 63 6c 65 | 20 64 61 74 61 62 61 73 |g Oracle| databas|
|00004730| 65 73 2c 0a 58 61 6e 64 | 20 43 6f 72 61 70 65 72 |es,.Xand| Coraper|
|00004740| 6c 2c 20 61 20 76 65 72 | 73 69 6f 6e 20 6f 66 20 |l, a ver|sion of |
|00004750| 4f 72 61 70 65 72 6c 20 | 77 68 69 63 68 20 61 6c |Oraperl |which al|
|00004760| 73 6f 20 69 6e 63 6c 75 | 64 65 73 20 43 75 72 73 |so inclu|des Curs|
|00004770| 65 73 2e 0a 58 54 6f 20 | 75 73 65 20 69 74 2c 20 |es..XTo |use it, |
|00004780| 79 6f 75 20 6d 75 73 74 | 20 68 61 76 65 20 74 68 |you must| have th|
|00004790| 65 20 4f 72 61 63 6c 65 | 20 50 72 6f 2a 43 20 70 |e Oracle| Pro*C p|
|000047a0| 72 6f 64 75 63 74 20 61 | 6e 64 20 61 20 76 65 72 |roduct a|nd a ver|
|000047b0| 73 69 6f 6e 20 6f 66 0a | 58 50 65 72 6c 20 77 68 |sion of.|XPerl wh|
|000047c0| 69 63 68 20 73 75 70 70 | 6f 72 74 73 20 55 73 65 |ich supp|orts Use|
|000047d0| 72 73 75 62 73 20 28 76 | 33 2e 30 2e 32 37 20 6f |rsubs (v|3.0.27 o|
|000047e0| 72 20 6c 61 74 65 72 29 | 2e 0a 58 0a 58 55 6e 73 |r later)|..X.XUns|
|000047f0| 68 61 72 20 69 74 20 73 | 6f 6d 65 77 68 65 72 65 |har it s|omewhere|
|00004800| 20 63 6f 6e 76 65 6e 69 | 65 6e 74 2c 20 61 6e 64 | conveni|ent, and|
|00004810| 20 65 64 69 74 20 4d 61 | 6b 65 66 69 6c 65 2e 20 | edit Ma|kefile. |
|00004820| 59 6f 75 20 6d 61 79 20 | 6e 65 65 64 0a 58 74 6f |You may |need.Xto|
|00004830| 20 63 68 61 6e 67 65 20 | 74 68 65 20 64 65 66 69 | change |the defi|
|00004840| 6e 69 74 69 6f 6e 73 20 | 62 65 6c 6f 77 3a 0a 58 |nitions |below:.X|
|00004850| 0a 58 09 4f 52 41 43 4c | 45 5f 48 4f 4d 45 09 79 |.X.ORACL|E_HOME.y|
|00004860| 6f 75 72 20 4f 72 61 63 | 6c 65 20 69 6e 73 74 61 |our Orac|le insta|
|00004870| 6c 6c 61 74 69 6f 6e 20 | 64 69 72 65 63 74 6f 72 |llation |director|
|00004880| 79 0a 58 09 53 52 43 09 | 09 79 6f 75 72 20 50 65 |y.X.SRC.|.your Pe|
|00004890| 72 6c 20 73 6f 75 72 63 | 65 20 64 69 72 65 63 74 |rl sourc|e direct|
|000048a0| 6f 72 79 20 28 77 69 74 | 68 20 74 68 65 20 75 73 |ory (wit|h the us|
|000048b0| 75 62 20 64 69 72 65 63 | 74 6f 72 79 29 0a 58 09 |ub direc|tory).X.|
|000048c0| 4f 54 48 45 52 4c 49 42 | 53 09 5c 20 0a 58 09 43 |OTHERLIB|S.\ .X.C|
|000048d0| 4c 49 42 53 09 09 20 7c | 0a 58 09 4f 43 49 4c 49 |LIBS.. ||.X.OCILI|
|000048e0| 42 09 09 20 2b 2d 20 63 | 6f 70 79 20 74 68 65 73 |B.. +- c|opy thes|
|000048f0| 65 20 66 72 6f 6d 20 24 | 4f 52 41 43 4c 45 5f 48 |e from $|ORACLE_H|
|00004900| 4f 4d 45 2f 63 2f 64 65 | 6d 6f 2f 70 72 6f 63 2e |OME/c/de|mo/proc.|
|00004910| 6d 6b 0a 58 09 4e 45 54 | 4c 49 42 53 09 09 20 7c |mk.X.NET|LIBS.. ||
|00004920| 20 20 28 6f 72 20 77 68 | 61 74 65 76 65 72 20 79 |  (or wh|atever y|
|00004930| 6f 75 20 75 73 65 20 74 | 6f 20 6c 69 6e 6b 20 4f |ou use t|o link O|
|00004940| 43 49 20 70 72 6f 67 72 | 61 6d 73 29 0a 58 09 4f |CI progr|ams).X.O|
|00004950| 52 41 4c 49 42 53 09 09 | 2f 0a 58 09 41 4c 4c 5f |RALIBS..|/.X.ALL_|
|00004960| 4f 52 41 5f 4c 49 42 53 | 09 73 75 6d 6d 61 72 79 |ORA_LIBS|.summary|
|00004970| 20 6f 66 20 4f 72 61 63 | 6c 65 20 6c 69 62 72 61 | of Orac|le libra|
|00004980| 72 69 65 73 2e 0a 58 09 | 09 09 54 68 69 73 20 69 |ries..X.|..This i|
|00004990| 73 20 74 68 65 20 6f 6e | 65 20 74 68 61 74 20 74 |s the on|e that t|
|000049a0| 68 65 20 4d 61 6b 65 66 | 69 6c 65 20 61 63 74 75 |he Makef|ile actu|
|000049b0| 61 6c 6c 79 20 75 73 65 | 73 0a 58 09 47 4c 4f 42 |ally use|s.X.GLOB|
|000049c0| 49 4e 43 53 09 5c 20 0a | 58 09 4c 4f 43 49 4e 43 |INCS.\ .|X.LOCINC|
|000049d0| 53 09 09 20 2b 2d 20 63 | 6f 70 79 20 74 68 65 73 |S.. +- c|opy thes|
|000049e0| 65 20 66 72 6f 6d 20 24 | 53 52 43 2f 75 73 75 62 |e from $|SRC/usub|
|000049f0| 2f 4d 61 6b 65 66 69 6c | 65 0a 58 09 4c 49 42 53 |/Makefil|e.X.LIBS|
|00004a00| 09 09 2f 0a 58 09 43 55 | 52 53 45 4c 49 42 09 79 |../.X.CU|RSELIB.y|
|00004a10| 6f 75 72 20 63 75 72 73 | 65 73 20 6c 69 62 72 61 |our curs|es libra|
|00004a20| 72 79 2c 20 69 66 20 79 | 6f 75 27 72 65 20 62 75 |ry, if y|ou're bu|
|00004a30| 69 6c 64 69 6e 67 20 43 | 6f 72 61 70 65 72 6c 0a |ilding C|oraperl.|
|00004a40| 58 09 44 45 42 55 47 09 | 09 2d 44 44 45 42 55 47 |X.DEBUG.|.-DDEBUG|
|00004a50| 47 49 4e 47 2c 20 2d 44 | 50 45 52 4c 5f 44 45 42 |GING, -D|PERL_DEB|
|00004a60| 55 47 47 49 4e 47 20 6f | 72 20 6c 65 61 76 65 20 |UGGING o|r leave |
|00004a70| 62 6c 61 6e 6b 3b 0a 58 | 09 09 09 73 65 65 20 74 |blank;.X|...see t|
|00004a80| 68 65 20 66 69 6c 65 20 | 44 65 62 75 67 67 69 6e |he file |Debuggin|
|00004a90| 67 20 66 6f 72 20 61 6e | 20 65 78 70 6c 61 6e 61 |g for an| explana|
|00004aa0| 74 69 6f 6e 0a 58 09 44 | 42 55 47 5f 4f 09 09 74 |tion.X.D|BUG_O..t|
|00004ab0| 68 65 20 64 65 62 75 67 | 67 69 6e 67 20 6c 69 62 |he debug|ging lib|
|00004ac0| 72 61 72 79 2c 20 69 66 | 20 64 65 62 75 67 67 69 |rary, if| debuggi|
|00004ad0| 6e 67 20 69 73 20 72 65 | 71 75 69 72 65 64 0a 58 |ng is re|quired.X|
|00004ae0| 09 43 41 43 48 45 09 09 | 64 65 66 61 75 6c 74 20 |.CACHE..|default |
|00004af0| 66 65 74 63 68 20 63 61 | 63 68 65 20 73 69 7a 65 |fetch ca|che size|
|00004b00| 2c 20 69 66 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |, if you| want to|
|00004b10| 20 63 68 61 6e 67 65 20 | 69 74 0a 58 09 42 49 4e | change |it.X.BIN|
|00004b20| 44 09 09 69 66 20 64 65 | 66 69 6e 65 64 2c 20 64 |D..if de|fined, d|
|00004b30| 6f 20 6e 6f 74 20 70 61 | 64 20 65 6d 70 74 79 20 |o not pa|d empty |
|00004b40| 62 69 6e 64 20 76 61 6c | 75 65 73 0a 58 09 53 54 |bind val|ues.X.ST|
|00004b50| 52 54 4f 55 4c 09 09 5c | 5f 20 73 79 73 74 65 6d |RTOUL..\|_ system|
|00004b60| 20 64 65 70 65 6e 64 65 | 6e 74 20 2d 20 73 65 65 | depende|nt - see|
|00004b70| 20 4d 61 6b 65 66 69 6c | 65 20 66 6f 72 20 64 65 | Makefil|e for de|
|00004b80| 74 61 69 6c 73 0a 58 09 | 53 54 52 5f 32 4d 4f 52 |tails.X.|STR_2MOR|
|00004b90| 54 41 4c 09 2f 0a 58 09 | 54 45 53 54 44 41 54 41 |TAL./.X.|TESTDATA|
|00004ba0| 09 64 61 74 61 62 61 73 | 65 2c 20 75 73 65 72 6e |.databas|e, usern|
|00004bb0| 61 6d 65 20 61 6e 64 20 | 70 61 73 73 77 6f 72 64 |ame and |password|
|00004bc0| 20 66 6f 72 20 74 65 73 | 74 69 6e 67 20 4f 72 61 | for tes|ting Ora|
|00004bd0| 70 65 72 6c 0a 58 0a 58 | 41 73 20 77 65 6c 6c 20 |perl.X.X|As well |
|00004be0| 61 73 20 6f 72 61 70 65 | 72 6c 2c 20 79 6f 75 20 |as orape|rl, you |
|00004bf0| 63 61 6e 20 61 6c 73 6f | 20 74 79 70 65 20 22 6d |can also| type "m|
|00004c00| 61 6b 65 20 63 6f 72 61 | 70 65 72 6c 22 20 74 6f |ake cora|perl" to|
|00004c10| 20 63 72 65 61 74 65 20 | 61 20 76 65 72 73 69 6f | create |a versio|
|00004c20| 6e 0a 58 6f 66 20 4f 72 | 61 70 65 72 6c 20 77 68 |n.Xof Or|aperl wh|
|00004c30| 69 63 68 20 69 6e 63 6f | 72 70 6f 72 61 74 65 73 |ich inco|rporates|
|00004c40| 20 63 75 72 73 65 73 2e | 20 59 6f 75 20 6d 75 73 | curses.| You mus|
|00004c50| 74 20 66 69 72 73 74 20 | 63 6f 6d 70 69 6c 65 20 |t first |compile |
|00004c60| 63 75 72 73 65 70 65 72 | 6c 20 28 69 6e 0a 58 24 |curseper|l (in.X$|
|00004c70| 28 53 52 43 29 2f 75 73 | 75 62 29 2c 20 61 6e 64 |(SRC)/us|ub), and|
|00004c80| 20 6c 65 61 76 65 20 74 | 68 65 20 63 75 72 73 65 | leave t|he curse|
|00004c90| 73 2e 6f 20 66 69 6c 65 | 20 74 68 65 72 65 2e 20 |s.o file| there. |
|00004ca0| 59 6f 75 20 6d 61 79 20 | 6e 65 65 64 20 50 65 72 |You may |need Per|
|00004cb0| 6c 20 76 34 2e 30 2e 31 | 39 0a 58 6f 72 20 6c 61 |l v4.0.1|9.Xor la|
|00004cc0| 74 65 72 20 66 6f 72 20 | 74 68 69 73 20 74 6f 20 |ter for |this to |
|00004cd0| 77 6f 72 6b 2c 20 61 73 | 20 74 68 61 74 20 77 61 |work, as| that wa|
|00004ce0| 73 20 74 68 65 20 66 69 | 72 73 74 20 76 65 72 73 |s the fi|rst vers|
|00004cf0| 69 6f 6e 20 74 6f 20 73 | 75 70 70 6f 72 74 20 53 |ion to s|upport S|
|00004d00| 79 73 74 65 6d 20 56 0a | 58 63 75 72 73 65 73 2e |ystem V.|Xcurses.|
|00004d10| 20 54 79 70 69 6e 67 20 | 22 6d 61 6b 65 20 61 6c | Typing |"make al|
|00004d20| 6c 22 20 77 69 6c 6c 20 | 6d 61 6b 65 20 62 6f 74 |l" will |make bot|
|00004d30| 68 20 6f 72 61 70 65 72 | 6c 20 61 6e 64 20 63 6f |h oraper|l and co|
|00004d40| 72 61 70 65 72 6c 2e 0a | 58 0a 58 41 66 74 65 72 |raperl..|X.XAfter|
|00004d50| 20 62 75 69 6c 64 69 6e | 67 20 6f 72 61 70 65 72 | buildin|g oraper|
|00004d60| 6c 2c 20 74 79 70 65 20 | 22 6d 61 6b 65 20 74 65 |l, type |"make te|
|00004d70| 73 74 22 20 74 6f 20 72 | 75 6e 20 73 6f 6d 65 20 |st" to r|un some |
|00004d80| 72 75 64 69 6d 65 6e 74 | 61 72 79 20 74 65 73 74 |rudiment|ary test|
|00004d90| 73 2e 0a 58 54 68 65 73 | 65 20 61 72 65 20 61 6e |s..XThes|e are an|
|00004da0| 79 74 68 69 6e 67 20 62 | 75 74 20 65 78 68 61 75 |ything b|ut exhau|
|00004db0| 73 74 69 76 65 2c 20 62 | 75 74 20 69 66 20 61 6e |stive, b|ut if an|
|00004dc0| 79 74 68 69 6e 67 20 67 | 6f 65 73 20 77 72 6f 6e |ything g|oes wron|
|00004dd0| 67 2c 20 79 6f 75 20 6e | 65 65 64 0a 58 74 6f 20 |g, you n|eed.Xto |
|00004de0| 63 68 65 63 6b 20 69 74 | 2e 20 41 74 20 70 72 65 |check it|. At pre|
|00004df0| 73 65 6e 74 2c 20 74 68 | 65 20 74 65 73 74 73 20 |sent, th|e tests |
|00004e00| 61 72 65 20 6a 75 73 74 | 20 68 61 63 6b 65 64 20 |are just| hacked |
|00004e10| 66 72 6f 6d 20 61 20 63 | 6f 75 70 6c 65 20 6f 66 |from a c|ouple of|
|00004e20| 20 74 68 65 0a 58 65 78 | 61 6d 70 6c 65 20 73 63 | the.Xex|ample sc|
|00004e30| 72 69 70 74 73 3b 20 69 | 66 20 79 6f 75 20 68 61 |ripts; i|f you ha|
|00004e40| 76 65 20 73 6f 6d 65 20 | 62 65 74 74 65 72 20 74 |ve some |better t|
|00004e50| 65 73 74 73 2c 20 70 6c | 65 61 73 65 20 73 65 6e |ests, pl|ease sen|
|00004e60| 64 20 74 68 65 6d 20 74 | 6f 20 6d 65 2e 0a 58 0a |d them t|o me..X.|
|00004e70| 58 41 66 74 65 72 20 74 | 65 73 74 69 6e 67 20 6f |XAfter t|esting o|
|00004e80| 72 61 70 65 72 6c 20 28 | 61 6e 64 20 6f 70 74 69 |raperl (|and opti|
|00004e90| 6f 6e 61 6c 6c 79 20 62 | 75 69 6c 64 69 6e 67 20 |onally b|uilding |
|00004ea0| 63 6f 72 61 70 65 72 6c | 29 20 74 79 70 65 20 22 |coraperl|) type "|
|00004eb0| 6d 61 6b 65 20 69 6e 73 | 74 61 6c 6c 22 0a 58 74 |make ins|tall".Xt|
|00004ec0| 6f 20 69 6e 73 74 61 6c | 6c 20 74 68 65 20 62 69 |o instal|l the bi|
|00004ed0| 6e 61 72 69 65 73 20 61 | 6e 64 20 74 68 65 20 6d |naries a|nd the m|
|00004ee0| 61 6e 75 61 6c 20 70 61 | 67 65 73 2e 20 54 68 65 |anual pa|ges. The|
|00004ef0| 79 20 77 69 6c 6c 20 62 | 65 20 70 75 74 20 69 6e |y will b|e put in|
|00004f00| 20 74 68 65 20 73 61 6d | 65 0a 58 64 69 72 65 63 | the sam|e.Xdirec|
|00004f10| 74 6f 72 69 65 73 20 61 | 73 20 79 6f 75 20 73 70 |tories a|s you sp|
|00004f20| 65 63 69 66 69 65 64 20 | 66 6f 72 20 50 65 72 6c |ecified |for Perl|
|00004f30| 2c 20 73 6f 20 74 68 65 | 20 63 6f 6e 66 69 67 2e |, so the| config.|
|00004f40| 73 68 20 73 63 72 69 70 | 74 20 6d 75 73 74 20 73 |sh scrip|t must s|
|00004f50| 74 69 6c 6c 0a 58 65 78 | 69 73 74 20 69 6e 20 79 |till.Xex|ist in y|
|00004f60| 6f 75 72 20 50 65 72 6c | 20 73 6f 75 72 63 65 20 |our Perl| source |
|00004f70| 64 69 72 65 63 74 6f 72 | 79 2e 20 54 68 65 20 73 |director|y. The s|
|00004f80| 61 6d 70 6c 65 20 73 63 | 72 69 70 74 20 65 78 61 |ample sc|ript exa|
|00004f90| 6d 70 6c 65 2f 73 71 6c | 20 77 69 6c 6c 0a 58 61 |mple/sql| will.Xa|
|00004fa0| 6c 73 6f 20 62 65 20 69 | 6e 73 74 61 6c 6c 65 64 |lso be i|nstalled|
|00004fb0| 2c 20 61 73 20 69 74 20 | 69 73 20 61 20 75 73 65 |, as it |is a use|
|00004fc0| 66 75 6c 20 70 72 6f 67 | 72 61 6d 20 69 6e 20 69 |ful prog|ram in i|
|00004fd0| 74 73 20 6f 77 6e 20 72 | 69 67 68 74 2e 0a 58 0a |ts own r|ight..X.|
|00004fe0| 58 49 27 76 65 20 6f 6e | 6c 79 20 74 65 73 74 65 |XI've on|ly teste|
|00004ff0| 64 20 74 68 69 73 20 6f | 6e 20 61 6e 20 45 6e 63 |d this o|n an Enc|
|00005000| 6f 72 65 20 4d 75 6c 74 | 69 6d 61 78 20 35 32 30 |ore Mult|imax 520|
|00005010| 20 72 75 6e 6e 69 6e 67 | 20 55 4d 41 58 20 56 20 | running| UMAX V |
|00005020| 28 53 79 73 20 56 72 33 | 2e 32 29 2c 0a 58 75 73 |(Sys Vr3|.2),.Xus|
|00005030| 69 6e 67 20 77 68 69 63 | 68 65 76 65 72 20 76 65 |ing whic|hever ve|
|00005040| 72 73 69 6f 6e 20 6f 66 | 20 50 65 72 6c 20 77 61 |rsion of| Perl wa|
|00005050| 73 20 63 75 72 72 65 6e | 74 20 61 74 20 74 68 65 |s curren|t at the|
|00005060| 20 74 69 6d 65 20 74 68 | 61 74 20 49 20 63 6f 6d | time th|at I com|
|00005070| 70 6c 65 74 65 64 0a 58 | 65 61 63 68 20 72 65 6c |pleted.X|each rel|
|00005080| 65 61 73 65 20 28 63 6f | 76 65 72 73 20 74 68 65 |ease (co|vers the|
|00005090| 20 72 61 6e 67 65 20 33 | 2e 30 2e 33 34 20 74 6f | range 3|.0.34 to|
|000050a0| 20 34 2e 30 2e 33 35 2c | 20 65 78 63 6c 75 64 69 | 4.0.35,| excludi|
|000050b0| 6e 67 20 34 2e 30 2e 33 | 33 29 20 77 69 74 68 0a |ng 4.0.3|3) with.|
|000050c0| 58 4f 72 61 63 6c 65 20 | 76 65 72 73 69 6f 6e 20 |XOracle |version |
|000050d0| 36 2c 20 61 73 20 49 20 | 64 6f 6e 27 74 20 68 61 |6, as I |don't ha|
|000050e0| 76 65 20 61 63 63 65 73 | 73 20 74 6f 20 61 6e 79 |ve acces|s to any|
|000050f0| 20 6f 74 68 65 72 20 73 | 79 73 74 65 6d 20 77 69 | other s|ystem wi|
|00005100| 74 68 20 50 72 6f 2a 43 | 2e 0a 58 48 6f 77 65 76 |th Pro*C|..XHowev|
|00005110| 65 72 2c 20 6f 74 68 65 | 72 20 70 65 6f 70 6c 65 |er, othe|r people|
|00005120| 20 68 61 76 65 20 63 6f | 6d 70 69 6c 65 64 20 61 | have co|mpiled a|
|00005130| 6e 64 20 75 73 65 64 20 | 69 74 20 6f 6e 20 61 20 |nd used |it on a |
|00005140| 72 61 6e 67 65 20 6f 66 | 20 64 69 66 66 65 72 65 |range of| differe|
|00005150| 6e 74 0a 58 73 79 73 74 | 65 6d 73 20 69 6e 63 6c |nt.Xsyst|ems incl|
|00005160| 75 64 69 6e 67 20 43 6f | 6e 76 65 78 2c 20 43 72 |uding Co|nvex, Cr|
|00005170| 61 79 2c 20 4e 65 58 54 | 2c 20 50 79 72 61 6d 69 |ay, NeXT|, Pyrami|
|00005180| 64 2c 20 53 75 6e 20 61 | 6e 64 20 55 6c 74 72 69 |d, Sun a|nd Ultri|
|00005190| 78 2c 20 75 73 69 6e 67 | 20 4f 72 61 63 6c 65 0a |x, using| Oracle.|
|000051a0| 58 76 65 72 73 69 6f 6e | 73 20 35 20 61 6e 64 20 |Xversion|s 5 and |
|000051b0| 36 2e 20 49 27 64 20 61 | 70 70 72 65 63 69 61 74 |6. I'd a|ppreciat|
|000051c0| 65 20 61 6e 79 20 63 6f | 6d 6d 65 6e 74 73 2c 20 |e any co|mments, |
|000051d0| 62 75 67 2d 72 65 70 6f | 72 74 73 2c 20 69 6d 70 |bug-repo|rts, imp|
|000051e0| 72 6f 76 65 6d 65 6e 74 | 73 2c 20 65 74 63 2e 0a |rovement|s, etc..|
|000051f0| 58 0a 58 49 6e 20 61 64 | 64 69 74 69 6f 6e 20 74 |X.XIn ad|dition t|
|00005200| 6f 20 74 68 69 73 20 52 | 45 41 44 4d 45 2c 20 74 |o this R|EADME, t|
|00005210| 68 65 20 70 61 63 6b 61 | 67 65 20 63 6f 6e 74 61 |he packa|ge conta|
|00005220| 69 6e 73 20 74 68 65 20 | 66 6f 6c 6c 6f 77 69 6e |ins the |followin|
|00005230| 67 20 66 69 6c 65 73 3a | 0a 58 0a 58 53 6f 75 72 |g files:|.X.XSour|
|00005240| 63 65 20 43 6f 64 65 3a | 0a 58 09 4d 61 6b 65 66 |ce Code:|.X.Makef|
|00005250| 69 6c 65 09 62 75 69 6c | 64 69 6e 67 20 69 6e 73 |ile.buil|ding ins|
|00005260| 74 72 75 63 74 69 6f 6e | 73 0a 58 09 63 6f 6c 6f |truction|s.X.colo|
|00005270| 6e 73 2e 63 09 63 6f 75 | 6e 74 73 20 73 75 62 73 |ns.c.cou|nts subs|
|00005280| 74 69 74 75 74 69 6f 6e | 20 76 61 72 69 61 62 6c |titution| variabl|
|00005290| 65 73 20 69 6e 20 61 20 | 73 74 61 74 65 6d 65 6e |es in a |statemen|
|000052a0| 74 0a 58 09 64 65 62 75 | 67 2e 63 09 09 74 72 61 |t.X.debu|g.c..tra|
|000052b0| 6e 73 6c 61 74 65 73 20 | 6e 75 6d 65 72 69 63 20 |nslates |numeric |
|000052c0| 64 65 62 75 67 67 69 6e | 67 20 63 6f 64 65 73 20 |debuggin|g codes |
|000052d0| 74 6f 20 73 74 72 69 6e | 67 0a 58 09 67 65 74 63 |to strin|g.X.getc|
|000052e0| 75 72 73 6f 72 2e 63 09 | 66 75 6e 63 74 69 6f 6e |ursor.c.|function|
|000052f0| 73 20 74 6f 20 64 65 61 | 6c 20 77 69 74 68 20 74 |s to dea|l with t|
|00005300| 68 65 20 63 75 72 73 6f | 72 20 70 6f 6f 6c 0a 58 |he curso|r pool.X|
|00005310| 09 6f 72 61 63 6c 65 2e | 6d 75 73 09 66 75 6e 63 |.oracle.|mus.func|
|00005320| 74 69 6f 6e 20 69 6e 74 | 65 72 66 61 63 65 20 64 |tion int|erface d|
|00005330| 65 73 63 72 69 70 74 69 | 6f 6e 0a 58 09 6f 72 61 |escripti|on.X.ora|
|00005340| 66 6e 73 2e 63 09 6f 72 | 61 63 6c 65 20 69 6e 74 |fns.c.or|acle int|
|00005350| 65 72 66 61 63 65 20 66 | 75 6e 63 74 69 6f 6e 73 |erface f|unctions|
|00005360| 0a 58 09 6f 72 61 66 6e | 73 2e 68 09 63 6f 6d 6d |.X.orafn|s.h.comm|
|00005370| 6f 6e 20 64 65 63 6c 61 | 72 61 74 69 6f 6e 73 0a |on decla|rations.|
|00005380| 58 09 70 61 74 63 68 6c | 65 76 65 6c 2e 68 09 4f |X.patchl|evel.h.O|
|00005390| 72 61 70 65 72 6c 20 76 | 65 72 73 69 6f 6e 20 6e |raperl v|ersion n|
|000053a0| 75 6d 62 65 72 20 61 6e | 64 20 70 61 74 63 68 20 |umber an|d patch |
|000053b0| 6c 65 76 65 6c 0a 58 09 | 73 74 72 74 6f 75 6c 2e |level.X.|strtoul.|
|000053c0| 63 09 66 6f 72 20 73 79 | 73 74 65 6d 73 20 77 68 |c.for sy|stems wh|
|000053d0| 69 63 68 20 64 6f 6e 27 | 74 20 68 61 76 65 20 73 |ich don'|t have s|
|000053e0| 74 72 74 6f 75 6c 28 33 | 29 0a 58 09 75 73 65 72 |trtoul(3|).X.user|
|000053f0| 73 75 62 2e 63 09 69 6e | 69 74 69 61 6c 69 73 61 |sub.c.in|itialisa|
|00005400| 74 69 6f 6e 20 72 6f 75 | 74 69 6e 65 0a 58 0a 58 |tion rou|tine.X.X|
|00005410| 46 72 65 64 20 46 69 73 | 68 27 20 44 65 62 75 67 |Fred Fis|h' Debug|
|00005420| 67 69 6e 67 20 6c 69 62 | 72 61 72 79 20 28 69 6e |ging lib|rary (in|
|00005430| 20 74 68 65 20 64 62 75 | 67 2f 20 64 69 72 65 63 | the dbu|g/ direc|
|00005440| 74 6f 72 79 29 3a 0a 58 | 09 4d 61 6b 65 66 69 6c |tory):.X|.Makefil|
|00005450| 65 09 6d 61 6b 65 66 69 | 6c 65 20 66 6f 72 20 74 |e.makefi|le for t|
|00005460| 68 65 20 64 65 62 75 67 | 67 69 6e 67 20 6c 69 62 |he debug|ging lib|
|00005470| 72 61 72 79 0a 58 09 52 | 65 61 64 6d 65 09 09 72 |rary.X.R|eadme..r|
|00005480| 65 61 64 6d 65 20 66 6f | 72 20 74 68 65 20 64 65 |eadme fo|r the de|
|00005490| 62 75 67 67 69 6e 67 20 | 6c 69 62 72 61 72 79 0a |bugging |library.|
|000054a0| 58 09 64 62 75 67 2e 63 | 09 09 6c 69 62 72 61 72 |X.dbug.c|..librar|
|000054b0| 79 20 63 6f 64 65 0a 58 | 09 64 62 75 67 2e 68 09 |y code.X|.dbug.h.|
|000054c0| 09 64 65 62 75 67 67 69 | 6e 67 20 68 65 61 64 65 |.debuggi|ng heade|
|000054d0| 72 0a 58 09 64 62 75 67 | 2e 70 09 09 64 6f 63 75 |r.X.dbug|.p..docu|
|000054e0| 6d 65 6e 74 61 74 69 6f | 6e 20 66 6f 72 20 74 68 |mentatio|n for th|
|000054f0| 65 20 64 65 62 75 67 67 | 69 6e 67 20 6c 69 62 72 |e debugg|ing libr|
|00005500| 61 72 79 0a 58 09 64 62 | 75 67 2e 71 72 09 09 71 |ary.X.db|ug.qr..q|
|00005510| 75 69 63 6b 20 72 65 66 | 65 72 65 6e 63 65 20 6c |uick ref|erence l|
|00005520| 69 73 74 0a 58 09 66 61 | 63 74 2e 63 09 09 73 61 |ist.X.fa|ct.c..sa|
|00005530| 6d 70 6c 65 20 70 72 6f | 67 72 61 6d 20 28 74 61 |mple pro|gram (ta|
|00005540| 6b 65 6e 20 66 72 6f 6d | 20 74 68 65 20 6d 61 6e |ken from| the man|
|00005550| 75 61 6c 29 0a 58 0a 58 | 45 78 61 6d 70 6c 65 73 |ual).X.X|Examples|
|00005560| 20 28 69 6e 20 74 68 65 | 20 65 78 61 6d 70 6c 65 | (in the| example|
|00005570| 73 2f 20 64 69 72 65 63 | 74 6f 72 79 29 3a 0a 58 |s/ direc|tory):.X|
|00005580| 09 52 65 61 64 6d 65 09 | 09 69 6e 74 72 6f 64 75 |.Readme.|.introdu|
|00005590| 63 74 69 6f 6e 20 74 6f | 20 74 68 65 20 65 78 61 |ction to| the exa|
|000055a0| 6d 70 6c 65 73 0a 58 09 | 62 69 6e 64 2e 70 6c 09 |mples.X.|bind.pl.|
|000055b0| 09 75 73 65 20 6f 66 20 | 6f 72 61 5f 62 69 6e 64 |.use of |ora_bind|
|000055c0| 20 61 6e 64 20 6f 72 61 | 5f 66 65 74 63 68 20 66 | and ora|_fetch f|
|000055d0| 6f 72 20 74 61 62 6c 65 | 20 6c 6f 6f 6b 75 70 0a |or table| lookup.|
|000055e0| 58 09 63 6b 64 65 62 75 | 67 2e 70 6c 09 74 65 73 |X.ckdebu|g.pl.tes|
|000055f0| 74 73 20 74 6f 20 73 65 | 65 20 69 66 20 64 65 62 |ts to se|e if deb|
|00005600| 75 67 67 69 6e 67 20 69 | 73 20 61 76 61 69 6c 61 |ugging i|s availa|
|00005610| 62 6c 65 0a 58 09 63 6f | 6d 6d 69 74 2e 70 6c 09 |ble.X.co|mmit.pl.|
|00005620| 75 73 69 6e 67 20 63 6f | 6d 6d 69 74 20 61 6e 64 |using co|mmit and|
|00005630| 20 72 6f 6c 6c 62 61 63 | 6b 0a 58 09 65 78 2e 70 | rollbac|k.X.ex.p|
|00005640| 6c 09 09 73 69 6d 70 6c | 65 20 65 78 61 6d 70 6c |l..simpl|e exampl|
|00005650| 65 20 6f 66 20 4f 72 61 | 70 65 72 6c 20 66 75 6e |e of Ora|perl fun|
|00005660| 63 74 69 6f 6e 73 0a 58 | 09 6d 6b 64 62 2e 70 6c |ctions.X|.mkdb.pl|
|00005670| 09 09 6d 6f 72 65 20 65 | 78 74 65 6e 73 69 76 65 |..more e|xtensive|
|00005680| 20 65 78 61 6d 70 6c 65 | 2c 20 75 73 69 6e 67 20 | example|, using |
|00005690| 63 75 72 73 65 73 20 69 | 66 20 61 76 61 69 6c 61 |curses i|f availa|
|000056a0| 62 6c 65 0a 58 09 09 09 | 79 6f 75 20 63 61 6e 20 |ble.X...|you can |
|000056b0| 72 75 6e 20 74 68 69 73 | 20 77 69 74 68 20 65 69 |run this| with ei|
|000056c0| 74 68 65 72 20 4f 72 61 | 70 65 72 6c 20 6f 72 20 |ther Ora|perl or |
|000056d0| 43 6f 72 61 70 65 72 6c | 0a 58 09 6f 72 61 64 75 |Coraperl|.X.oradu|
|000056e0| 6d 70 2e 70 6c 09 64 75 | 6d 70 20 61 6e 20 4f 72 |mp.pl.du|mp an Or|
|000056f0| 61 63 6c 65 20 74 61 62 | 6c 65 20 69 6e 74 6f 20 |acle tab|le into |
|00005700| 61 20 73 65 74 20 6f 66 | 20 69 6e 73 65 72 74 20 |a set of| insert |
|00005710| 73 74 61 74 65 6d 65 6e | 74 73 0a 58 09 73 71 6c |statemen|ts.X.sql|
|00005720| 09 09 65 78 65 63 75 74 | 65 20 61 6e 20 53 51 4c |..execut|e an SQL|
|00005730| 20 73 74 61 74 65 6d 65 | 6e 74 20 66 72 6f 6d 20 | stateme|nt from |
|00005740| 74 68 65 20 63 6f 6d 6d | 61 6e 64 20 6c 69 6e 65 |the comm|and line|
|00005750| 0a 58 09 09 09 28 74 68 | 69 73 20 6f 6e 65 20 69 |.X...(th|is one i|
|00005760| 73 20 77 6f 72 74 68 20 | 69 6e 73 74 61 6c 6c 69 |s worth |installi|
|00005770| 6e 67 29 0a 58 09 74 61 | 62 69 6e 66 6f 2e 70 6c |ng).X.ta|binfo.pl|
|00005780| 09 64 69 73 70 6c 61 79 | 20 74 68 65 20 73 74 72 |.display| the str|
|00005790| 75 63 74 75 72 65 20 6f | 66 20 61 20 64 61 74 61 |ucture o|f a data|
|000057a0| 62 61 73 65 20 74 61 62 | 6c 65 0a 58 0a 58 44 6f |base tab|le.X.XDo|
|000057b0| 63 75 6d 65 6e 74 61 74 | 69 6f 6e 20 28 69 6e 20 |cumentat|ion (in |
|000057c0| 74 68 65 20 64 6f 63 2f | 20 64 69 72 65 63 74 6f |the doc/| directo|
|000057d0| 72 79 29 3a 0a 58 09 6f | 72 61 70 65 72 6c 2e 72 |ry):.X.o|raperl.r|
|000057e0| 65 66 09 71 75 69 63 6b | 20 72 65 66 65 72 65 6e |ef.quick| referen|
|000057f0| 63 65 20 2d 20 67 6c 75 | 65 20 69 74 20 69 6e 74 |ce - glu|e it int|
|00005800| 6f 20 74 68 65 20 70 65 | 72 6c 20 72 65 66 65 72 |o the pe|rl refer|
|00005810| 65 6e 63 65 20 67 75 69 | 64 65 0a 58 09 6f 72 61 |ence gui|de.X.ora|
|00005820| 70 65 72 6c 2e 31 09 6d | 61 6e 75 61 6c 20 70 61 |perl.1.m|anual pa|
|00005830| 67 65 0a 58 0a 58 54 65 | 73 74 69 6e 67 20 69 6e |ge.X.XTe|sting in|
|00005840| 66 6f 72 6d 61 74 69 6f | 6e 20 28 69 6e 20 74 68 |formatio|n (in th|
|00005850| 65 20 74 65 73 74 64 69 | 72 2f 20 64 69 72 65 63 |e testdi|r/ direc|
|00005860| 74 6f 72 79 29 0a 58 09 | 52 65 61 64 6d 65 09 09 |tory).X.|Readme..|
|00005870| 20 74 65 73 74 20 69 6e | 66 6f 72 6d 61 74 69 6f | test in|formatio|
|00005880| 6e 0a 58 09 53 74 61 6e | 64 61 72 64 2d 52 65 73 |n.X.Stan|dard-Res|
|00005890| 75 6c 74 73 20 63 6f 72 | 72 65 63 74 20 72 65 73 |ults cor|rect res|
|000058a0| 75 6c 74 73 20 66 6f 72 | 20 61 20 74 65 73 74 20 |ults for| a test |
|000058b0| 72 75 6e 0a 58 09 63 6f | 6d 6d 69 74 2e 70 6c 09 |run.X.co|mmit.pl.|
|000058c0| 20 74 65 73 74 20 73 63 | 72 69 70 74 0a 58 09 6d | test sc|ript.X.m|
|000058d0| 6b 64 62 2e 70 6c 09 09 | 20 74 65 73 74 20 73 63 |kdb.pl..| test sc|
|000058e0| 72 69 70 74 0a 58 0a 58 | 4d 69 73 63 65 6c 6c 61 |ript.X.X|Miscella|
|000058f0| 6e 65 6f 75 73 3a 0a 58 | 09 43 68 61 6e 67 65 73 |neous:.X|.Changes|
|00005900| 09 09 53 75 6d 6d 61 72 | 79 20 6f 66 20 63 68 61 |..Summar|y of cha|
|00005910| 6e 67 65 73 20 74 6f 20 | 4f 72 61 70 65 72 6c 0a |nges to |Oraperl.|
|00005920| 58 09 44 65 62 75 67 67 | 69 6e 67 09 44 65 74 61 |X.Debugg|ing.Deta|
|00005930| 69 6c 73 20 6f 66 20 74 | 68 65 20 62 75 69 6c 74 |ils of t|he built|
|00005940| 2d 69 6e 20 64 65 62 75 | 67 67 69 6e 67 20 72 6f |-in debu|gging ro|
|00005950| 75 74 69 6e 65 73 0a 58 | 09 48 69 6e 74 73 09 09 |utines.X|.Hints..|
|00005960| 6e 6f 74 65 73 20 63 6f | 6e 63 65 72 6e 69 6e 67 |notes co|ncerning|
|00005970| 20 70 72 6f 62 6c 65 6d | 73 20 77 68 69 63 68 20 | problem|s which |
|00005980| 68 61 76 65 20 61 72 69 | 73 65 6e 20 69 6e 20 74 |have ari|sen in t|
|00005990| 68 65 20 70 61 73 74 0a | 58 09 4c 6f 6e 67 09 09 |he past.|X.Long..|
|000059a0| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 20 61 62 6f 75 |informat|ion abou|
|000059b0| 74 20 4c 4f 4e 47 20 61 | 6e 64 20 4c 4f 4e 47 52 |t LONG a|nd LONGR|
|000059c0| 41 57 20 73 75 70 70 6f | 72 74 0a 58 09 4d 61 6b |AW suppo|rt.X.Mak|
|000059d0| 65 66 69 6c 65 09 62 75 | 69 6c 64 73 20 28 63 29 |efile.bu|ilds (c)|
|000059e0| 6f 72 61 70 65 72 6c 20 | 61 6e 64 20 64 6f 63 75 |oraperl |and docu|
|000059f0| 6d 65 6e 74 61 74 69 6f | 6e 2c 20 63 6c 65 61 6e |mentatio|n, clean|
|00005a00| 73 20 75 70 0a 58 09 52 | 6f 77 5f 63 61 63 68 65 |s up.X.R|ow_cache|
|00005a10| 09 64 65 73 63 72 69 62 | 65 73 20 74 68 65 20 73 |.describ|es the s|
|00005a20| 70 65 65 64 20 69 6d 70 | 72 6f 76 65 6d 65 6e 74 |peed imp|rovement|
|00005a30| 73 20 64 75 65 20 74 6f | 20 63 61 63 68 69 6e 67 |s due to| caching|
|00005a40| 0a 58 09 69 6e 73 74 61 | 6c 6c 2e 70 6c 09 50 65 |.X.insta|ll.pl.Pe|
|00005a50| 72 6c 20 73 63 72 69 70 | 74 20 74 6f 20 69 6e 73 |rl scrip|t to ins|
|00005a60| 74 61 6c 6c 20 4f 72 61 | 70 65 72 6c 0a 58 09 6f |tall Ora|perl.X.o|
|00005a70| 72 61 70 65 72 6c 2e 70 | 68 09 64 65 66 69 6e 69 |raperl.p|h.defini|
|00005a80| 74 69 6f 6e 73 20 6f 66 | 20 4f 72 61 70 65 72 6c |tions of| Oraperl|
|00005a90| 20 65 72 72 6f 72 20 61 | 6e 64 20 64 65 62 75 67 | error a|nd debug|
|00005aa0| 67 69 6e 67 20 63 6f 64 | 65 73 0a 58 0a 58 4d 61 |ging cod|es.X.XMa|
|00005ab0| 6e 79 20 74 68 61 6e 6b | 73 20 74 6f 20 4c 61 72 |ny thank|s to Lar|
|00005ac0| 72 79 20 66 6f 72 20 50 | 65 72 6c 2e 0a 58 0a 58 |ry for P|erl..X.X|
|00005ad0| 09 4b 65 76 69 6e 20 53 | 74 6f 63 6b 0a 58 09 6b |.Kevin S|tock.X.k|
|00005ae0| 73 74 6f 63 6b 40 65 6e | 63 6f 72 65 2e 63 6f 6d |stock@en|core.com|
|00005af0| 0a 58 0a 58 0a 58 09 09 | 20 49 4d 50 4f 52 54 41 |.X.X.X..| IMPORTA|
|00005b00| 4e 54 20 4e 4f 54 49 43 | 45 20 2d 20 57 61 72 72 |NT NOTIC|E - Warr|
|00005b10| 61 6e 74 79 20 61 6e 64 | 20 43 6f 70 79 72 69 67 |anty and| Copyrig|
|00005b20| 68 74 0a 58 0a 58 4f 72 | 61 70 65 72 6c 20 69 73 |ht.X.XOr|aperl is|
|00005b30| 20 6e 6f 74 20 61 20 70 | 72 6f 64 75 63 74 20 6f | not a p|roduct o|
|00005b40| 66 20 65 69 74 68 65 72 | 20 45 6e 63 6f 72 65 20 |f either| Encore |
|00005b50| 43 6f 6d 70 75 74 65 72 | 20 43 6f 72 70 6f 72 61 |Computer| Corpora|
|00005b60| 74 69 6f 6e 20 6f 72 20 | 4f 72 61 63 6c 65 0a 58 |tion or |Oracle.X|
|00005b70| 43 6f 72 70 6f 72 61 74 | 69 6f 6e 20 6f 72 20 61 |Corporat|ion or a|
|00005b80| 6e 79 20 6f 66 20 74 68 | 65 69 72 20 73 75 62 73 |ny of th|eir subs|
|00005b90| 69 64 69 61 72 69 65 73 | 2e 20 54 68 65 72 65 20 |idiaries|. There |
|00005ba0| 69 73 20 6e 6f 20 77 61 | 72 72 61 6e 74 79 2c 20 |is no wa|rranty, |
|00005bb0| 61 6e 64 20 6e 6f 0a 58 | 6f 66 66 69 63 69 61 6c |and no.X|official|
|00005bc0| 20 73 75 70 70 6f 72 74 | 20 69 73 20 61 76 61 69 | support| is avai|
|00005bd0| 6c 61 62 6c 65 2e 0a 58 | 0a 58 49 74 20 69 73 20 |lable..X|.XIt is |
|00005be0| 43 6f 70 79 72 69 67 68 | 74 20 31 39 39 31 2c 20 |Copyrigh|t 1991, |
|00005bf0| 31 39 39 32 20 4b 65 76 | 69 6e 20 53 74 6f 63 6b |1992 Kev|in Stock|
|00005c00| 2c 20 62 75 74 20 6d 61 | 79 20 62 65 20 66 72 65 |, but ma|y be fre|
|00005c10| 65 6c 79 20 64 69 73 74 | 72 69 62 75 74 65 64 0a |ely dist|ributed.|
|00005c20| 58 75 6e 64 65 72 20 74 | 68 65 20 73 61 6d 65 20 |Xunder t|he same |
|00005c30| 74 65 72 6d 73 20 61 73 | 20 50 65 72 6c 20 69 74 |terms as| Perl it|
|00005c40| 73 65 6c 66 2c 20 74 68 | 61 74 20 69 73 2c 20 75 |self, th|at is, u|
|00005c50| 6e 64 65 72 20 74 68 65 | 20 74 65 72 6d 73 20 6f |nder the| terms o|
|00005c60| 66 20 65 69 74 68 65 72 | 0a 58 74 68 65 20 47 4e |f either|.Xthe GN|
|00005c70| 55 20 50 75 62 6c 69 63 | 20 4c 69 63 65 6e 73 65 |U Public| License|
|00005c80| 20 6f 72 20 74 68 65 20 | 41 72 74 69 73 74 69 63 | or the |Artistic|
|00005c90| 20 4c 69 63 65 6e 73 65 | 2e 0a 45 4e 44 5f 4f 46 | License|..END_OF|
|00005ca0| 5f 46 49 4c 45 0a 20 20 | 69 66 20 74 65 73 74 20 |_FILE.  |if test |
|00005cb0| 35 34 38 35 20 2d 6e 65 | 20 60 77 63 20 2d 63 20 |5485 -ne| `wc -c |
|00005cc0| 3c 27 52 65 61 64 6d 65 | 27 60 3b 20 74 68 65 6e |<'Readme|'`; then|
|00005cd0| 0a 20 20 20 20 65 63 68 | 6f 20 73 68 61 72 3a 20 |.    ech|o shar: |
|00005ce0| 5c 22 27 52 65 61 64 6d | 65 27 5c 22 20 75 6e 70 |\"'Readm|e'\" unp|
|00005cf0| 61 63 6b 65 64 20 77 69 | 74 68 20 77 72 6f 6e 67 |acked wi|th wrong|
|00005d00| 20 73 69 7a 65 21 0a 20 | 20 66 69 0a 20 20 23 20 | size!. | fi.  # |
|00005d10| 65 6e 64 20 6f 66 20 27 | 52 65 61 64 6d 65 27 0a |end of '|Readme'.|
|00005d20| 66 69 0a 69 66 20 74 65 | 73 74 20 2d 66 20 27 52 |fi.if te|st -f 'R|
|00005d30| 6f 77 5f 63 61 63 68 65 | 27 20 2d 61 20 22 24 7b |ow_cache|' -a "${|
|00005d40| 31 7d 22 20 21 3d 20 22 | 2d 63 22 20 3b 20 74 68 |1}" != "|-c" ; th|
|00005d50| 65 6e 20 0a 20 20 65 63 | 68 6f 20 73 68 61 72 3a |en .  ec|ho shar:|
|00005d60| 20 57 69 6c 6c 20 6e 6f | 74 20 63 6c 6f 62 62 65 | Will no|t clobbe|
|00005d70| 72 20 65 78 69 73 74 69 | 6e 67 20 66 69 6c 65 20 |r existi|ng file |
|00005d80| 5c 22 27 52 6f 77 5f 63 | 61 63 68 65 27 5c 22 0a |\"'Row_c|ache'\".|
|00005d90| 65 6c 73 65 0a 20 20 65 | 63 68 6f 20 73 68 61 72 |else.  e|cho shar|
|00005da0| 3a 20 45 78 74 72 61 63 | 74 69 6e 67 20 5c 22 27 |: Extrac|ting \"'|
|00005db0| 52 6f 77 5f 63 61 63 68 | 65 27 5c 22 20 5c 28 32 |Row_cach|e'\" \(2|
|00005dc0| 31 31 34 20 63 68 61 72 | 61 63 74 65 72 73 5c 29 |114 char|acters\)|
|00005dd0| 0a 20 20 73 65 64 20 22 | 73 2f 5e 58 2f 2f 22 20 |.  sed "|s/^X//" |
|00005de0| 3e 27 52 6f 77 5f 63 61 | 63 68 65 27 20 3c 3c 27 |>'Row_ca|che' <<'|
|00005df0| 45 4e 44 5f 4f 46 5f 46 | 49 4c 45 27 0a 58 0a 58 |END_OF_F|ILE'.X.X|
|00005e00| 4f 72 61 70 65 72 6c 20 | 76 65 72 73 69 6f 6e 20 |Oraperl |version |
|00005e10| 32 20 73 75 70 70 6f 72 | 74 73 20 61 20 6d 75 6c |2 suppor|ts a mul|
|00005e20| 74 69 2d 72 6f 77 20 63 | 61 63 68 65 20 66 6f 72 |ti-row c|ache for|
|00005e30| 20 53 45 4c 45 43 54 20 | 73 74 61 74 65 6d 65 6e | SELECT |statemen|
|00005e40| 74 73 2e 0a 58 54 68 65 | 20 75 73 65 72 20 69 6e |ts..XThe| user in|
|00005e50| 74 65 72 66 61 63 65 20 | 69 73 20 6e 6f 74 20 63 |terface |is not c|
|00005e60| 68 61 6e 67 65 64 2c 20 | 65 78 63 65 70 74 20 74 |hanged, |except t|
|00005e70| 68 61 74 20 74 68 65 20 | 75 73 65 72 20 6d 61 79 |hat the |user may|
|00005e80| 20 28 62 75 74 20 69 73 | 0a 58 6e 6f 74 20 72 65 | (but is|.Xnot re|
|00005e90| 71 75 69 72 65 64 20 74 | 6f 29 20 73 70 65 63 69 |quired t|o) speci|
|00005ea0| 66 79 20 74 68 65 20 73 | 69 7a 65 20 6f 66 20 74 |fy the s|ize of t|
|00005eb0| 68 65 20 63 61 63 68 65 | 20 69 6e 20 74 68 65 20 |he cache| in the |
|00005ec0| 26 6f 72 61 5f 6f 70 65 | 6e 28 29 0a 58 63 61 6c |&ora_ope|n().Xcal|
|00005ed0| 6c 2e 20 49 74 20 69 73 | 20 6e 6f 74 20 70 6f 73 |l. It is| not pos|
|00005ee0| 73 69 62 6c 65 20 74 6f | 20 67 6f 20 62 61 63 6b |sible to| go back|
|00005ef0| 20 74 6f 20 61 6e 20 65 | 6e 74 72 79 20 77 68 69 | to an e|ntry whi|
|00005f00| 63 68 20 68 61 73 20 61 | 6c 72 65 61 64 79 20 62 |ch has a|lready b|
|00005f10| 65 65 6e 0a 58 72 65 74 | 75 72 6e 65 64 2c 20 65 |een.Xret|urned, e|
|00005f20| 76 65 6e 20 69 66 20 69 | 74 20 69 73 20 73 74 69 |ven if i|t is sti|
|00005f30| 6c 6c 20 69 6e 20 74 68 | 65 20 63 61 63 68 65 2e |ll in th|e cache.|
|00005f40| 0a 58 0a 58 49 20 74 69 | 6d 65 64 20 74 68 65 20 |.X.XI ti|med the |
|00005f50| 63 61 63 68 69 6e 67 20 | 63 6f 64 65 20 75 73 69 |caching |code usi|
|00005f60| 6e 67 20 74 68 65 20 66 | 6f 6c 6c 6f 77 69 6e 67 |ng the f|ollowing|
|00005f70| 20 4f 72 61 70 65 72 6c | 20 73 63 72 69 70 74 3a | Oraperl| script:|
|00005f80| 0a 58 0a 58 09 24 6c 64 | 61 20 3d 20 26 6f 72 61 |.X.X.$ld|a = &ora|
|00005f90| 5f 6c 6f 67 69 6e 28 27 | 69 70 6c 27 2c 20 27 6e |_login('|ipl', 'n|
|00005fa0| 61 6d 65 27 2c 20 27 70 | 61 73 73 27 29 20 7c 7c |ame', 'p|ass') |||
|00005fb0| 20 64 69 65 20 24 6f 72 | 61 5f 65 72 72 73 74 72 | die $or|a_errstr|
|00005fc0| 3b 0a 58 09 24 71 75 65 | 72 79 20 3d 20 22 73 65 |;.X.$que|ry = "se|
|00005fd0| 6c 65 63 74 20 2a 20 66 | 72 6f 6d 20 69 70 6c 20 |lect * f|rom ipl |
|00005fe0| 77 68 65 72 65 20 6d 6f | 64 65 6c 6e 75 6d 20 6c |where mo|delnum l|
|00005ff0| 69 6b 65 20 27 46 25 30 | 30 31 27 22 3b 0a 58 0a |ike 'F%0|01'";.X.|
|00006000| 58 09 69 66 20 28 24 6f | 72 61 5f 76 65 72 6e 6f |X.if ($o|ra_verno|
|00006010| 20 3e 3d 20 32 29 0a 58 | 09 7b 0a 58 09 20 20 20 | >= 2).X|.{.X.   |
|00006020| 20 24 6f 72 61 5f 63 61 | 63 68 65 20 3d 20 28 73 | $ora_ca|che = (s|
|00006030| 68 69 66 74 20 7c 7c 20 | 30 29 3b 0a 58 09 7d 0a |hift || |0);.X.}.|
|00006040| 58 0a 58 09 24 63 73 72 | 20 3d 20 26 6f 72 61 5f |X.X.$csr| = &ora_|
|00006050| 6f 70 65 6e 28 24 6c 64 | 61 2c 20 24 71 75 65 72 |open($ld|a, $quer|
|00006060| 79 29 20 7c 7c 20 64 69 | 65 20 6f 72 61 5f 65 72 |y) || di|e ora_er|
|00006070| 72 73 74 72 3b 0a 58 0a | 58 09 77 68 69 6c 65 20 |rstr;.X.|X.while |
|00006080| 28 40 64 61 74 61 20 3d | 20 26 6f 72 61 5f 66 65 |(@data =| &ora_fe|
|00006090| 74 63 68 28 24 63 73 72 | 29 29 0a 58 09 7b 0a 58 |tch($csr|)).X.{.X|
|000060a0| 09 20 20 20 20 2b 2b 24 | 63 6f 75 6e 74 3b 0a 58 |.    ++$|count;.X|
|000060b0| 09 7d 0a 58 09 77 61 72 | 6e 20 22 28 24 6f 72 61 |.}.X.war|n "($ora|
|000060c0| 5f 65 72 72 6e 6f 29 20 | 24 6f 72 61 5f 65 72 72 |_errno) |$ora_err|
|000060d0| 73 74 72 22 20 69 66 20 | 24 6f 72 61 5f 65 72 72 |str" if |$ora_err|
|000060e0| 6e 6f 3b 0a 58 0a 58 09 | 70 72 69 6e 74 20 22 53 |no;.X.X.|print "S|
|000060f0| 65 6c 65 63 74 65 64 20 | 24 63 6f 75 6e 74 20 6c |elected |$count l|
|00006100| 69 6e 65 73 5c 6e 22 3b | 0a 58 0a 58 09 26 6f 72 |ines\n";|.X.X.&or|
|00006110| 61 5f 63 6c 6f 73 65 28 | 24 63 73 72 29 3b 0a 58 |a_close(|$csr);.X|
|00006120| 09 26 6f 72 61 5f 6c 6f | 67 6f 66 66 28 24 6c 64 |.&ora_lo|goff($ld|
|00006130| 61 29 3b 0a 58 0a 58 28 | 49 20 64 6f 20 6e 6f 74 |a);.X.X(|I do not|
|00006140| 20 63 6c 61 69 6d 20 74 | 68 61 74 20 74 68 69 73 | claim t|hat this|
|00006150| 20 69 73 20 61 20 67 6f | 6f 64 20 74 65 73 74 3b | is a go|od test;|
|00006160| 20 69 74 20 77 61 73 20 | 73 69 6d 70 6c 79 20 61 | it was |simply a|
|00006170| 20 63 6f 6e 76 65 6e 69 | 65 6e 74 20 6f 6e 65 21 | conveni|ent one!|
|00006180| 29 0a 58 0a 58 54 68 65 | 20 73 65 6c 65 63 74 20 |).X.XThe| select |
|00006190| 73 74 61 74 65 6d 65 6e | 74 20 6d 61 74 63 68 65 |statemen|t matche|
|000061a0| 64 20 33 36 30 20 72 6f | 77 73 20 6f 66 20 32 32 |d 360 ro|ws of 22|
|000061b0| 20 66 69 65 6c 64 73 20 | 6f 75 74 20 61 20 64 61 | fields |out a da|
|000061c0| 74 61 62 61 73 65 20 6f | 66 20 34 33 30 30 30 0a |tabase o|f 43000.|
|000061d0| 58 72 65 63 6f 72 64 73 | 2e 20 54 68 65 20 73 63 |Xrecords|. The sc|
|000061e0| 72 69 70 74 20 77 61 73 | 20 72 75 6e 20 74 65 6e |ript was| run ten|
|000061f0| 20 74 69 6d 65 73 20 77 | 69 74 68 20 4f 72 61 70 | times w|ith Orap|
|00006200| 65 72 6c 20 76 65 72 73 | 69 6f 6e 20 31 2c 20 61 |erl vers|ion 1, a|
|00006210| 6e 64 20 74 65 6e 20 74 | 69 6d 65 73 0a 58 65 61 |nd ten t|imes.Xea|
|00006220| 63 68 20 75 73 69 6e 67 | 20 63 61 63 68 65 20 73 |ch using| cache s|
|00006230| 69 7a 65 73 20 6f 66 20 | 31 2c 20 32 2c 20 33 2c |izes of |1, 2, 3,|
|00006240| 20 34 2c 20 35 2c 20 31 | 30 2c 20 32 30 2c 20 31 | 4, 5, 1|0, 20, 1|
|00006250| 30 30 2c 20 32 30 30 2c | 20 33 30 30 20 61 6e 64 |00, 200,| 300 and|
|00006260| 20 34 30 30 2e 20 4e 6f | 74 65 0a 58 74 68 61 74 | 400. No|te.Xthat|
|00006270| 20 74 68 65 20 73 69 7a | 65 20 6f 66 20 34 30 30 | the siz|e of 400|
|00006280| 20 69 73 20 67 72 65 61 | 74 65 72 20 74 68 61 6e | is grea|ter than|
|00006290| 20 74 68 65 20 6e 75 6d | 62 65 72 20 6f 66 20 72 | the num|ber of r|
|000062a0| 6f 77 73 20 73 65 6c 65 | 63 74 65 64 2c 20 73 6f |ows sele|cted, so|
|000062b0| 20 74 68 65 79 0a 58 77 | 65 72 65 20 61 6c 6c 20 | they.Xw|ere all |
|000062c0| 63 6f 6c 6c 65 63 74 65 | 64 20 69 6e 20 61 20 73 |collecte|d in a s|
|000062d0| 69 6e 67 6c 65 20 66 65 | 74 63 68 2e 20 54 6f 74 |ingle fe|tch. Tot|
|000062e0| 61 6c 69 6e 67 20 74 68 | 65 20 66 69 67 75 72 65 |aling th|e figure|
|000062f0| 73 20 66 6f 72 20 65 61 | 63 68 20 67 72 6f 75 70 |s for ea|ch group|
|00006300| 2c 0a 58 49 20 67 6f 74 | 20 74 68 65 20 66 6f 6c |,.XI got| the fol|
|00006310| 6c 6f 77 69 6e 67 20 72 | 65 73 75 6c 74 73 3a 0a |lowing r|esults:.|
|00006320| 58 0a 58 09 09 09 20 70 | 65 72 63 65 6e 74 61 67 |X.X... p|ercentag|
|00006330| 65 20 73 70 65 65 64 75 | 70 0a 58 09 63 61 63 68 |e speedu|p.X.cach|
|00006340| 65 09 09 20 20 20 63 6f | 6d 70 61 72 65 64 20 74 |e..   co|mpared t|
|00006350| 6f 20 76 31 0a 58 09 20 | 73 69 7a 65 09 09 72 65 |o v1.X. |size..re|
|00006360| 61 6c 09 75 73 65 72 09 | 73 79 73 0a 58 0a 58 09 |al.user.|sys.X.X.|
|00006370| 20 20 20 31 09 09 20 20 | 30 09 20 2d 32 09 20 20 |   1..  |0. -2.  |
|00006380| 31 0a 58 09 20 20 20 32 | 09 09 20 20 38 09 20 20 |1.X.   2|..  8.  |
|00006390| 36 09 20 32 34 0a 58 09 | 20 20 20 33 09 09 20 31 |6. 24.X.|   3.. 1|
|000063a0| 30 09 20 20 38 09 20 32 | 34 0a 58 09 20 20 20 34 |0.  8. 2|4.X.   4|
|000063b0| 09 09 20 31 32 09 20 31 | 32 09 20 32 37 0a 58 09 |.. 12. 1|2. 27.X.|
|000063c0| 20 20 20 35 09 09 20 31 | 35 09 20 31 32 09 20 33 |   5.. 1|5. 12. 3|
|000063d0| 36 0a 58 09 20 20 31 30 | 09 09 20 31 36 09 20 31 |6.X.  10|.. 16. 1|
|000063e0| 33 09 20 33 37 0a 58 09 | 20 20 32 30 09 09 20 31 |3. 37.X.|  20.. 1|
|000063f0| 38 09 20 31 33 09 20 33 | 39 0a 58 09 20 31 30 30 |8. 13. 3|9.X. 100|
+--------+-------------------------+-------------------------+--------+--------+