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 |
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 |
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 |