ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/reference.log
(Generate patch)

Comparing ibx/trunk/fbintf/testsuite/reference.log (file contents):
Revision 110 by tony, Thu Oct 26 12:59:51 2017 UTC vs.
Revision 111 by tony, Thu Jan 18 14:37:53 2018 UTC

# Line 285 | Line 285 | JOB_COUNTRY = USA
285   SALARY = 64,635.00
286   FULL_NAME = Johnson, Leslie
287  
288 < Current memory =  1.959857600000000000E+0007
289 < Delta memory =  2.952000000000000000E+0003
290 < Max memory =  1.966170400000000000E+0007
291 < Elapsed time= 0.007 sec
288 > Current memory =  1.959863200000000000E+0007
289 > Delta memory =  2.616000000000000000E+0003
290 > Max memory =  1.966220800000000000E+0007
291 > Elapsed time= 0.000 sec
292   Cpu = 0.000 sec
293   Buffers =  2.048000000000000000E+0003
294   Reads =  0.000000000000000000E+0000
# Line 978 | Line 978 | The fair Ophelia.-Nymph, in thy orisons
978   Be all my sins remembered
979  
980  
981 + Testing Blob as stored proc parameter
982 + Metadata
983 + SQLType =SQL_BLOB
984 + sub type = 1
985 + Table = TESTPROC
986 + Owner = SYSDBA
987 + Column Name = BLOBDATA
988 + Alias Name = BLOBDATA
989 + Field Name = BLOBDATA
990 + Scale = 0
991 + Charset id = 4
992 + Nullable
993 + Size = 8
994 +
995 + Blob Meta Data
996 + SQL SubType =1
997 + Table = TESTPROC
998 + Column = BLOBDATA
999 + CharSetID = 4
1000 + Segment Size = 80
1001 +
1002 +
1003 + BLOBDATA (Charset Id = 4 Codepage = 65001)
1004 +
1005 + To be or not to be-that is the question:
1006 + Whether 'tis nobler in the mind to suffer
1007 + The slings and arrows of outrageous fortune,
1008 + Or to take arms against a sea of troubles,
1009 + And, by opposing, end them. To die, to sleep-
1010 + No more-and by a sleep to say we end
1011 + The heartache and the thousand natural shocks
1012 + That flesh is heir to-'tis a consummation
1013 + Devoutly to be wished. To die, to sleep-
1014 + To sleep, perchance to dream. Aye, there's the rub,
1015 + For in that sleep of death what dreams may come,
1016 + When we have shuffled off this mortal coil,
1017 + Must give us pause. There's the respect
1018 + That makes calamity of so long life.
1019 + For who would bear the whips and scorns of time,
1020 + Th' oppressor's wrong, the proud man's contumely,
1021 + The pangs of despised love, the law’s delay,
1022 + The insolence of office, and the spurns
1023 + That patient merit of the unworthy takes,
1024 + When he himself might his quietus make
1025 + With a bare bodkin? Who would fardels bear,
1026 + To grunt and sweat under a weary life,
1027 + But that the dread of something after death,
1028 + The undiscovered country from whose bourn
1029 + No traveler returns, puzzles the will
1030 + And makes us rather bear those ills we have
1031 + Than fly to others that we know not of?
1032 + Thus conscience does make cowards of us all,
1033 + And thus the native hue of resolution
1034 + Is sicklied o'er with the pale cast of thought,
1035 + And enterprises of great pitch and moment,
1036 + With this regard their currents turn awry,
1037 + And lose the name of action.-Soft you now,
1038 + The fair Ophelia.-Nymph, in thy orisons
1039 + Be all my sins remembered
1040 +
1041 + Metadata
1042 + SQLType =SQL_TEXT
1043 + sub type = 0
1044 + Table = RDB$CHARACTER_SETS
1045 + Owner = SYSDBA
1046 + Column Name = RDB$CHARACTER_SET_NAME
1047 + Alias Name = RDB$CHARACTER_SET_NAME
1048 + Field Name = RDB$CHARACTER_SET_NAME
1049 + Scale = 0
1050 + Charset id = 53
1051 + Nullable
1052 + Size = 31
1053 +
1054 + SQLType =SQL_SHORT
1055 + sub type = 0
1056 + Table = RDB$CHARACTER_SETS
1057 + Owner = SYSDBA
1058 + Column Name = RDB$CHARACTER_SET_ID
1059 + Alias Name = RDB$CHARACTER_SET_ID
1060 + Field Name = RDB$CHARACTER_SET_ID
1061 + Scale = 0
1062 + Charset id = 0
1063 + Nullable
1064 + Size = 2
1065 +
1066 + RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1067 + RDB$CHARACTER_SET_ID = 0
1068 + RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1069 + RDB$CHARACTER_SET_ID = 1
1070 + RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1071 + RDB$CHARACTER_SET_ID = 2
1072 + RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1073 + RDB$CHARACTER_SET_ID = 3
1074 + RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1075 + RDB$CHARACTER_SET_ID = 4
1076 + RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1077 + RDB$CHARACTER_SET_ID = 5
1078 + RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1079 + RDB$CHARACTER_SET_ID = 6
1080 + RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1081 + RDB$CHARACTER_SET_ID = 9
1082 + RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1083 + RDB$CHARACTER_SET_ID = 10
1084 + RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1085 + RDB$CHARACTER_SET_ID = 11
1086 + RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1087 + RDB$CHARACTER_SET_ID = 12
1088 + RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1089 + RDB$CHARACTER_SET_ID = 13
1090 + RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1091 + RDB$CHARACTER_SET_ID = 14
1092 + RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1093 + RDB$CHARACTER_SET_ID = 15
1094 + RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1095 + RDB$CHARACTER_SET_ID = 16
1096 + RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1097 + RDB$CHARACTER_SET_ID = 17
1098 + RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1099 + RDB$CHARACTER_SET_ID = 18
1100 + RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1101 + RDB$CHARACTER_SET_ID = 19
1102 + RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1103 + RDB$CHARACTER_SET_ID = 21
1104 + RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1105 + RDB$CHARACTER_SET_ID = 22
1106 + RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1107 + RDB$CHARACTER_SET_ID = 23
1108 + RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1109 + RDB$CHARACTER_SET_ID = 34
1110 + RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1111 + RDB$CHARACTER_SET_ID = 35
1112 + RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1113 + RDB$CHARACTER_SET_ID = 36
1114 + RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1115 + RDB$CHARACTER_SET_ID = 37
1116 + RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1117 + RDB$CHARACTER_SET_ID = 38
1118 + RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1119 + RDB$CHARACTER_SET_ID = 39
1120 + RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1121 + RDB$CHARACTER_SET_ID = 40
1122 + RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1123 + RDB$CHARACTER_SET_ID = 44
1124 + RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1125 + RDB$CHARACTER_SET_ID = 45
1126 + RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1127 + RDB$CHARACTER_SET_ID = 46
1128 + RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1129 + RDB$CHARACTER_SET_ID = 47
1130 + RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1131 + RDB$CHARACTER_SET_ID = 48
1132 + RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1133 + RDB$CHARACTER_SET_ID = 49
1134 + RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1135 + RDB$CHARACTER_SET_ID = 50
1136 + RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1137 + RDB$CHARACTER_SET_ID = 51
1138 + RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1139 + RDB$CHARACTER_SET_ID = 52
1140 + RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1141 + RDB$CHARACTER_SET_ID = 53
1142 + RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1143 + RDB$CHARACTER_SET_ID = 54
1144 + RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1145 + RDB$CHARACTER_SET_ID = 55
1146 + RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1147 + RDB$CHARACTER_SET_ID = 56
1148 + RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1149 + RDB$CHARACTER_SET_ID = 57
1150 + RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1151 + RDB$CHARACTER_SET_ID = 58
1152 + RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1153 + RDB$CHARACTER_SET_ID = 59
1154 + RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1155 + RDB$CHARACTER_SET_ID = 60
1156 + RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1157 + RDB$CHARACTER_SET_ID = 63
1158 + RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1159 + RDB$CHARACTER_SET_ID = 64
1160 + RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1161 + RDB$CHARACTER_SET_ID = 65
1162 + RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1163 + RDB$CHARACTER_SET_ID = 66
1164 + RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1165 + RDB$CHARACTER_SET_ID = 67
1166 + RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1167 + RDB$CHARACTER_SET_ID = 68
1168 + RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1169 + RDB$CHARACTER_SET_ID = 69
1170 +
1171 + Metadata
1172 + SQLType =SQL_LONG
1173 + sub type = 0
1174 + Table = TESTDATA
1175 + Owner = SYSDBA
1176 + Column Name = ROWID
1177 + Alias Name = ROWID
1178 + Field Name = ROWID
1179 + Scale = 0
1180 + Charset id = 0
1181 + Not Null
1182 + Size = 4
1183 +
1184 + SQLType =SQL_LONG
1185 + sub type = 0
1186 + Table = TESTDATA
1187 + Owner = SYSDBA
1188 + Column Name = FIXEDPOINT
1189 + Alias Name = FIXEDPOINT
1190 + Field Name = FIXEDPOINT
1191 + Scale = -2
1192 + Charset id = 0
1193 + Nullable
1194 + Size = 4
1195 +
1196 + SQLType =SQL_DOUBLE
1197 + sub type = 0
1198 + Table = TESTDATA
1199 + Owner = SYSDBA
1200 + Column Name = FLOATINGPOINT
1201 + Alias Name = FLOATINGPOINT
1202 + Field Name = FLOATINGPOINT
1203 + Scale = 0
1204 + Charset id = 0
1205 + Nullable
1206 + Size = 8
1207 +
1208 + SQLType =SQL_VARYING
1209 + sub type = 0
1210 + Table = TESTDATA
1211 + Owner = SYSDBA
1212 + Column Name = TITLE
1213 + Alias Name = TITLE
1214 + Field Name = TITLE
1215 + Scale = 0
1216 + Charset id = 53
1217 + Nullable
1218 + Size = 32
1219 +
1220 + SQLType =SQL_BLOB
1221 + sub type = 1
1222 + Table = TESTDATA
1223 + Owner = SYSDBA
1224 + Column Name = BLOBDATA
1225 + Alias Name = BLOBDATA
1226 + Field Name = BLOBDATA
1227 + Scale = 0
1228 + Charset id = 53
1229 + Nullable
1230 + Size = 8
1231 +
1232 + Blob Meta Data
1233 + SQL SubType =1
1234 + Table = TESTDATA
1235 + Column = BLOBDATA
1236 + CharSetID = 53
1237 + Segment Size = 80
1238 +
1239 +
1240 + SQL Params
1241 + SQLType =SQL_LONG
1242 + sub type = 0
1243 + Field Name = ROWID
1244 + Scale = 0
1245 + Charset id = 0
1246 + Not Null
1247 + Size = 4
1248 +
1249 + SQLType =SQL_VARYING
1250 + sub type = 0
1251 + Field Name = TITLE
1252 + Scale = 0
1253 + Charset id = 53
1254 + Nullable
1255 + Size = 32
1256 +
1257 + SQLType =SQL_LONG
1258 + sub type = 0
1259 + Field Name = FP
1260 + Scale = -2
1261 + Charset id = 0
1262 + Nullable
1263 + Size = 4
1264 +
1265 + SQLType =SQL_DOUBLE
1266 + sub type = 0
1267 + Field Name = DP
1268 + Scale = 0
1269 + Charset id = 0
1270 + Nullable
1271 + Size = 8
1272 +
1273 + ROWID = 1
1274 + FIXEDPOINT = 20.28
1275 + FLOATINGPOINT = 3.14
1276 + TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1277 + BLOBDATA = NULL
1278 +
1279 + SQL Params
1280 + SQLType =SQL_BLOB
1281 + sub type = 1
1282 + Field Name =
1283 + Scale = 0
1284 + Charset id = 53
1285 + Nullable
1286 + Size = 8
1287 +
1288 + SQLType =SQL_LONG
1289 + sub type = 0
1290 + Field Name =
1291 + Scale = 0
1292 + Charset id = 0
1293 + Not Null
1294 + Size = 4
1295 +
1296 + ROWID = 1
1297 + FIXEDPOINT = 20.28
1298 + FLOATINGPOINT = 3.14
1299 + TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1300 + BLOBDATA (Charset Id = 53 Codepage = 1252)
1301 +
1302 + To be or not to be-that is the question:
1303 + Whether 'tis nobler in the mind to suffer
1304 + The slings and arrows of outrageous fortune,
1305 + Or to take arms against a sea of troubles,
1306 + And, by opposing, end them. To die, to sleep-
1307 + No more-and by a sleep to say we end
1308 + The heartache and the thousand natural shocks
1309 + That flesh is heir to-'tis a consummation
1310 + Devoutly to be wished. To die, to sleep-
1311 + To sleep, perchance to dream. Aye, there's the rub,
1312 + For in that sleep of death what dreams may come,
1313 + When we have shuffled off this mortal coil,
1314 + Must give us pause. There's the respect
1315 + That makes calamity of so long life.
1316 + For who would bear the whips and scorns of time,
1317 + Th' oppressor's wrong, the proud man's contumely,
1318 + The pangs of despised love, the law’s delay,
1319 + The insolence of office, and the spurns
1320 + That patient merit of the unworthy takes,
1321 + When he himself might his quietus make
1322 + With a bare bodkin? Who would fardels bear,
1323 + To grunt and sweat under a weary life,
1324 + But that the dread of something after death,
1325 + The undiscovered country from whose bourn
1326 + No traveler returns, puzzles the will
1327 + And makes us rather bear those ills we have
1328 + Than fly to others that we know not of?
1329 + Thus conscience does make cowards of us all,
1330 + And thus the native hue of resolution
1331 + Is sicklied o'er with the pale cast of thought,
1332 + And enterprises of great pitch and moment,
1333 + With this regard their currents turn awry,
1334 + And lose the name of action.-Soft you now,
1335 + The fair Ophelia.-Nymph, in thy orisons
1336 + Be all my sins remembered
1337 +
1338 +
1339 + SQL Params
1340 + SQLType =SQL_LONG
1341 + sub type = 0
1342 + Field Name = ROWID
1343 + Scale = 0
1344 + Charset id = 0
1345 + Not Null
1346 + Size = 4
1347 +
1348 + SQLType =SQL_VARYING
1349 + sub type = 0
1350 + Field Name = TITLE
1351 + Scale = 0
1352 + Charset id = 53
1353 + Nullable
1354 + Size = 32
1355 +
1356 + SQLType =SQL_LONG
1357 + sub type = 0
1358 + Field Name = FP
1359 + Scale = -2
1360 + Charset id = 0
1361 + Nullable
1362 + Size = 4
1363 +
1364 + SQLType =SQL_DOUBLE
1365 + sub type = 0
1366 + Field Name = DP
1367 + Scale = 0
1368 + Charset id = 0
1369 + Nullable
1370 + Size = 8
1371 +
1372 + ROWID = 1
1373 + FIXEDPOINT = 20.28
1374 + FLOATINGPOINT = 3.14
1375 + TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1376 + BLOBDATA (Charset Id = 53 Codepage = 1252)
1377 +
1378 + To be or not to be-that is the question:
1379 + Whether 'tis nobler in the mind to suffer
1380 + The slings and arrows of outrageous fortune,
1381 + Or to take arms against a sea of troubles,
1382 + And, by opposing, end them. To die, to sleep-
1383 + No more-and by a sleep to say we end
1384 + The heartache and the thousand natural shocks
1385 + That flesh is heir to-'tis a consummation
1386 + Devoutly to be wished. To die, to sleep-
1387 + To sleep, perchance to dream. Aye, there's the rub,
1388 + For in that sleep of death what dreams may come,
1389 + When we have shuffled off this mortal coil,
1390 + Must give us pause. There's the respect
1391 + That makes calamity of so long life.
1392 + For who would bear the whips and scorns of time,
1393 + Th' oppressor's wrong, the proud man's contumely,
1394 + The pangs of despised love, the law’s delay,
1395 + The insolence of office, and the spurns
1396 + That patient merit of the unworthy takes,
1397 + When he himself might his quietus make
1398 + With a bare bodkin? Who would fardels bear,
1399 + To grunt and sweat under a weary life,
1400 + But that the dread of something after death,
1401 + The undiscovered country from whose bourn
1402 + No traveler returns, puzzles the will
1403 + And makes us rather bear those ills we have
1404 + Than fly to others that we know not of?
1405 + Thus conscience does make cowards of us all,
1406 + And thus the native hue of resolution
1407 + Is sicklied o'er with the pale cast of thought,
1408 + And enterprises of great pitch and moment,
1409 + With this regard their currents turn awry,
1410 + And lose the name of action.-Soft you now,
1411 + The fair Ophelia.-Nymph, in thy orisons
1412 + Be all my sins remembered
1413 +
1414 + ROWID = 2
1415 + FIXEDPOINT = NULL
1416 + FLOATINGPOINT = NULL
1417 + TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1418 + BLOBDATA (Charset Id = 53 Codepage = 1252)
1419 +
1420 + To be or not to be-that is the question:
1421 + Whether 'tis nobler in the mind to suffer
1422 + The slings and arrows of outrageous fortune,
1423 + Or to take arms against a sea of troubles,
1424 + And, by opposing, end them. To die, to sleep-
1425 + No more-and by a sleep to say we end
1426 + The heartache and the thousand natural shocks
1427 + That flesh is heir to-'tis a consummation
1428 + Devoutly to be wished. To die, to sleep-
1429 + To sleep, perchance to dream. Aye, there's the rub,
1430 + For in that sleep of death what dreams may come,
1431 + When we have shuffled off this mortal coil,
1432 + Must give us pause. There's the respect
1433 + That makes calamity of so long life.
1434 + For who would bear the whips and scorns of time,
1435 + Th' oppressor's wrong, the proud man's contumely,
1436 + The pangs of despised love, the law’s delay,
1437 + The insolence of office, and the spurns
1438 + That patient merit of the unworthy takes,
1439 + When he himself might his quietus make
1440 + With a bare bodkin? Who would fardels bear,
1441 + To grunt and sweat under a weary life,
1442 + But that the dread of something after death,
1443 + The undiscovered country from whose bourn
1444 + No traveler returns, puzzles the will
1445 + And makes us rather bear those ills we have
1446 + Than fly to others that we know not of?
1447 + Thus conscience does make cowards of us all,
1448 + And thus the native hue of resolution
1449 + Is sicklied o'er with the pale cast of thought,
1450 + And enterprises of great pitch and moment,
1451 + With this regard their currents turn awry,
1452 + And lose the name of action.-Soft you now,
1453 + The fair Ophelia.-Nymph, in thy orisons
1454 + Be all my sins remembered
1455 +
1456 +
1457 + Testing Blob as stored proc parameter
1458 + Metadata
1459 + SQLType =SQL_BLOB
1460 + sub type = 1
1461 + Table = TESTPROC
1462 + Owner = SYSDBA
1463 + Column Name = BLOBDATA
1464 + Alias Name = BLOBDATA
1465 + Field Name = BLOBDATA
1466 + Scale = 0
1467 + Charset id = 53
1468 + Nullable
1469 + Size = 8
1470 +
1471 + Blob Meta Data
1472 + SQL SubType =1
1473 + Table = TESTPROC
1474 + Column = BLOBDATA
1475 + CharSetID = 53
1476 + Segment Size = 80
1477 +
1478 +
1479 + BLOBDATA (Charset Id = 53 Codepage = 1252)
1480 +
1481 + To be or not to be-that is the question:
1482 + Whether 'tis nobler in the mind to suffer
1483 + The slings and arrows of outrageous fortune,
1484 + Or to take arms against a sea of troubles,
1485 + And, by opposing, end them. To die, to sleep-
1486 + No more-and by a sleep to say we end
1487 + The heartache and the thousand natural shocks
1488 + That flesh is heir to-'tis a consummation
1489 + Devoutly to be wished. To die, to sleep-
1490 + To sleep, perchance to dream. Aye, there's the rub,
1491 + For in that sleep of death what dreams may come,
1492 + When we have shuffled off this mortal coil,
1493 + Must give us pause. There's the respect
1494 + That makes calamity of so long life.
1495 + For who would bear the whips and scorns of time,
1496 + Th' oppressor's wrong, the proud man's contumely,
1497 + The pangs of despised love, the law’s delay,
1498 + The insolence of office, and the spurns
1499 + That patient merit of the unworthy takes,
1500 + When he himself might his quietus make
1501 + With a bare bodkin? Who would fardels bear,
1502 + To grunt and sweat under a weary life,
1503 + But that the dread of something after death,
1504 + The undiscovered country from whose bourn
1505 + No traveler returns, puzzles the will
1506 + And makes us rather bear those ills we have
1507 + Than fly to others that we know not of?
1508 + Thus conscience does make cowards of us all,
1509 + And thus the native hue of resolution
1510 + Is sicklied o'er with the pale cast of thought,
1511 + And enterprises of great pitch and moment,
1512 + With this regard their currents turn awry,
1513 + And lose the name of action.-Soft you now,
1514 + The fair Ophelia.-Nymph, in thy orisons
1515 + Be all my sins remembered
1516 +
1517   Metadata
1518   SQLType =SQL_TEXT
1519   sub type = 0
# Line 1394 | Line 1930 | The fair Ophelia.-Nymph, in thy orisons
1930   Be all my sins remembered
1931  
1932  
1933 + Testing Blob as stored proc parameter
1934 + Metadata
1935 + SQLType =SQL_BLOB
1936 + sub type = 1
1937 + Table = TESTPROC
1938 + Owner = SYSDBA
1939 + Column Name = BLOBDATA
1940 + Alias Name = BLOBDATA
1941 + Field Name = BLOBDATA
1942 + Scale = 0
1943 + Charset id = 4
1944 + Nullable
1945 + Size = 8
1946 +
1947 + Blob Meta Data
1948 + SQL SubType =1
1949 + Table = TESTPROC
1950 + Column = BLOBDATA
1951 + CharSetID = 4
1952 + Segment Size = 80
1953 +
1954 +
1955 + BLOBDATA (Charset Id = 4 Codepage = 65001)
1956 +
1957 + To be or not to be-that is the question:
1958 + Whether 'tis nobler in the mind to suffer
1959 + The slings and arrows of outrageous fortune,
1960 + Or to take arms against a sea of troubles,
1961 + And, by opposing, end them. To die, to sleep-
1962 + No more-and by a sleep to say we end
1963 + The heartache and the thousand natural shocks
1964 + That flesh is heir to-'tis a consummation
1965 + Devoutly to be wished. To die, to sleep-
1966 + To sleep, perchance to dream. Aye, there's the rub,
1967 + For in that sleep of death what dreams may come,
1968 + When we have shuffled off this mortal coil,
1969 + Must give us pause. There's the respect
1970 + That makes calamity of so long life.
1971 + For who would bear the whips and scorns of time,
1972 + Th' oppressor's wrong, the proud man's contumely,
1973 + The pangs of despised love, the law’s delay,
1974 + The insolence of office, and the spurns
1975 + That patient merit of the unworthy takes,
1976 + When he himself might his quietus make
1977 + With a bare bodkin? Who would fardels bear,
1978 + To grunt and sweat under a weary life,
1979 + But that the dread of something after death,
1980 + The undiscovered country from whose bourn
1981 + No traveler returns, puzzles the will
1982 + And makes us rather bear those ills we have
1983 + Than fly to others that we know not of?
1984 + Thus conscience does make cowards of us all,
1985 + And thus the native hue of resolution
1986 + Is sicklied o'er with the pale cast of thought,
1987 + And enterprises of great pitch and moment,
1988 + With this regard their currents turn awry,
1989 + And lose the name of action.-Soft you now,
1990 + The fair Ophelia.-Nymph, in thy orisons
1991 + Be all my sins remembered
1992 +
1993  
1994  
1995   Running Test 7: Create and read back an Array

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines