5 Replies Latest reply on May 15, 2014 7:32 AM by Karthick2003

    Help  required to pass more than 32767 characters to Clob parameter of procedure

    prakash

      [code]

      version Detail

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      PL/SQL Release 11.2.0.3.0 - Production

      "CORE    11.2.0.3.0    Production"

      TNS for Linux: Version 11.2.0.3.0 - Production

      NLSRTL Version 11.2.0.3.0 - Production

      Hi All,

      Can any one help me on passing more than 4000 characters to clob in plsql,

      I can think of using varchar2 in plsql since it can accept max 32767 characters.

      In my requirement  string is crossing more than 4000 characters.

      Any help in this regard is highly apprecialted..

       

      declare

      v_clob clob :='select 1 as domain_sid from dual union all

      select 2 as domain_sid from dual union all

      select 3 as domain_sid from dual union all

      select 4 as domain_sid from dual union all

      select 5 as domain_sid from dual union all

      select 6 as domain_sid from dual union all

      select 7 as domain_sid from dual union all

      select 8 as domain_sid from dual union all

      select 9 as domain_sid from dual union all

      select 10 as domain_sid from dual union all

      select 11 as domain_sid from dual union all

      select 12 as domain_sid from dual union all

      select 13 as domain_sid from dual union all

      select 14 as domain_sid from dual union all

      select 15 as domain_sid from dual union all

      select 16 as domain_sid from dual union all

      select 17 as domain_sid from dual union all

      select 18 as domain_sid from dual union all

      select 19 as domain_sid from dual union all

      select 20 as domain_sid from dual union all

      select 21 as domain_sid from dual union all

      select 22 as domain_sid from dual union all

      select 23 as domain_sid from dual union all

      select 24 as domain_sid from dual union all

      select 25 as domain_sid from dual union all

      select 26 as domain_sid from dual union all

      select 27 as domain_sid from dual union all

      select 28 as domain_sid from dual union all

      select 29 as domain_sid from dual union all

      select 30 as domain_sid from dual union all

      select 31 as domain_sid from dual union all

      select 32 as domain_sid from dual union all

      select 33 as domain_sid from dual union all

      select 34 as domain_sid from dual union all

      select 35 as domain_sid from dual union all

      select 36 as domain_sid from dual union all

      select 37 as domain_sid from dual union all

      select 38 as domain_sid from dual union all

      select 39 as domain_sid from dual union all

      select 40 as domain_sid from dual union all

      select 41 as domain_sid from dual union all

      select 42 as domain_sid from dual union all

      select 43 as domain_sid from dual union all

      select 44 as domain_sid from dual union all

      select 45 as domain_sid from dual union all

      select 46 as domain_sid from dual union all

      select 47 as domain_sid from dual union all

      select 48 as domain_sid from dual union all

      select 49 as domain_sid from dual union all

      select 50 as domain_sid from dual union all

      select 51 as domain_sid from dual union all

      select 52 as domain_sid from dual union all

      select 53 as domain_sid from dual union all

      select 54 as domain_sid from dual union all

      select 55 as domain_sid from dual union all

      select 56 as domain_sid from dual union all

      select 57 as domain_sid from dual union all

      select 58 as domain_sid from dual union all

      select 59 as domain_sid from dual union all

      select 60 as domain_sid from dual union all

      select 61 as domain_sid from dual union all

      select 62 as domain_sid from dual union all

      select 63 as domain_sid from dual union all

      select 64 as domain_sid from dual union all

      select 65 as domain_sid from dual union all

      select 66 as domain_sid from dual union all

      select 67 as domain_sid from dual union all

      select 68 as domain_sid from dual union all

      select 69 as domain_sid from dual union all

      select 70 as domain_sid from dual union all

      select 71 as domain_sid from dual union all

      select 72 as domain_sid from dual union all

      select 73 as domain_sid from dual union all

      select 74 as domain_sid from dual union all

      select 75 as domain_sid from dual union all

      select 76 as domain_sid from dual union all

      select 77 as domain_sid from dual union all

      select 78 as domain_sid from dual union all

      select 79 as domain_sid from dual union all

      select 80 as domain_sid from dual union all

      select 81 as domain_sid from dual union all

      select 82 as domain_sid from dual union all

      select 83 as domain_sid from dual union all

      select 84 as domain_sid from dual union all

      select 85 as domain_sid from dual union all

      select 86 as domain_sid from dual union all

      select 87 as domain_sid from dual union all

      select 88 as domain_sid from dual union all

      select 89 as domain_sid from dual union all

      select 90 as domain_sid from dual union all

      select 91 as domain_sid from dual union all

      select 92 as domain_sid from dual union all

      select 93 as domain_sid from dual union all

      select 94 as domain_sid from dual union all

      select 95 as domain_sid from dual union all

      select 96 as domain_sid from dual union all

      select 97 as domain_sid from dual union all

      select 98 as domain_sid from dual union all

      select 99 as domain_sid from dual union all

      select 100 as domain_sid from dual union all

      select 101 as domain_sid from dual union all

      select 102 as domain_sid from dual union all

      select 103 as domain_sid from dual union all

      select 104 as domain_sid from dual union all

      select 105 as domain_sid from dual union all

      select 106 as domain_sid from dual union all

      select 107 as domain_sid from dual union all

      select 108 as domain_sid from dual union all

      select 109 as domain_sid from dual union all

      select 110 as domain_sid from dual union all

      select 111 as domain_sid from dual union all

      select 112 as domain_sid from dual union all

      select 113 as domain_sid from dual union all

      select 114 as domain_sid from dual union all

      select 115 as domain_sid from dual union all

      select 116 as domain_sid from dual union all

      select 117 as domain_sid from dual union all

      select 118 as domain_sid from dual union all

      select 119 as domain_sid from dual union all

      select 120 as domain_sid from dual union all

      select 121 as domain_sid from dual union all

      select 122 as domain_sid from dual union all

      select 123 as domain_sid from dual union all

      select 124 as domain_sid from dual union all

      select 125 as domain_sid from dual union all

      select 126 as domain_sid from dual union all

      select 127 as domain_sid from dual union all

      select 128 as domain_sid from dual union all

      select 129 as domain_sid from dual union all

      select 130 as domain_sid from dual union all

      select 131 as domain_sid from dual union all

      select 132 as domain_sid from dual union all

      select 133 as domain_sid from dual union all

      select 134 as domain_sid from dual union all

      select 135 as domain_sid from dual union all

      select 136 as domain_sid from dual union all

      select 137 as domain_sid from dual union all

      select 138 as domain_sid from dual union all

      select 139 as domain_sid from dual union all

      select 140 as domain_sid from dual union all

      select 141 as domain_sid from dual union all

      select 142 as domain_sid from dual union all

      select 143 as domain_sid from dual union all

      select 144 as domain_sid from dual union all

      select 145 as domain_sid from dual union all

      select 146 as domain_sid from dual union all

      select 147 as domain_sid from dual union all

      select 148 as domain_sid from dual union all

      select 149 as domain_sid from dual union all

      select 150 as domain_sid from dual union all

      select 151 as domain_sid from dual union all

      select 152 as domain_sid from dual union all

      select 153 as domain_sid from dual union all

      select 154 as domain_sid from dual union all

      select 155 as domain_sid from dual union all

      select 156 as domain_sid from dual union all

      select 157 as domain_sid from dual union all

      select 158 as domain_sid from dual union all

      select 159 as domain_sid from dual union all

      select 160 as domain_sid from dual union all

      select 161 as domain_sid from dual union all

      select 162 as domain_sid from dual union all

      select 163 as domain_sid from dual union all

      select 164 as domain_sid from dual union all

      select 165 as domain_sid from dual union all

      select 166 as domain_sid from dual union all

      select 167 as domain_sid from dual union all

      select 168 as domain_sid from dual union all

      select 169 as domain_sid from dual union all

      select 170 as domain_sid from dual union all

      select 171 as domain_sid from dual union all

      select 172 as domain_sid from dual union all

      select 173 as domain_sid from dual union all

      select 174 as domain_sid from dual union all

      select 175 as domain_sid from dual union all

      select 176 as domain_sid from dual union all

      select 177 as domain_sid from dual union all

      select 178 as domain_sid from dual union all

      select 179 as domain_sid from dual union all

      select 180 as domain_sid from dual union all

      select 181 as domain_sid from dual union all

      select 182 as domain_sid from dual union all

      select 183 as domain_sid from dual union all

      select 184 as domain_sid from dual union all

      select 185 as domain_sid from dual union all

      select 186 as domain_sid from dual union all

      select 187 as domain_sid from dual union all

      select 188 as domain_sid from dual union all

      select 189 as domain_sid from dual union all

      select 190 as domain_sid from dual union all

      select 191 as domain_sid from dual union all

      select 192 as domain_sid from dual union all

      select 193 as domain_sid from dual union all

      select 194 as domain_sid from dual union all

      select 195 as domain_sid from dual union all

      select 196 as domain_sid from dual union all

      select 197 as domain_sid from dual union all

      select 198 as domain_sid from dual union all

      select 199 as domain_sid from dual union all

      select 200 as domain_sid from dual union all

      select 201 as domain_sid from dual union all

      select 202 as domain_sid from dual union all

      select 203 as domain_sid from dual union all

      select 204 as domain_sid from dual union all

      select 205 as domain_sid from dual union all

      select 206 as domain_sid from dual union all

      select 207 as domain_sid from dual union all

      select 208 as domain_sid from dual union all

      select 209 as domain_sid from dual union all

      select 210 as domain_sid from dual union all

      select 211 as domain_sid from dual union all

      select 212 as domain_sid from dual union all

      select 213 as domain_sid from dual union all

      select 214 as domain_sid from dual union all

      select 215 as domain_sid from dual union all

      select 216 as domain_sid from dual union all

      select 217 as domain_sid from dual union all

      select 218 as domain_sid from dual union all

      select 219 as domain_sid from dual union all

      select 220 as domain_sid from dual union all

      select 221 as domain_sid from dual union all

      select 222 as domain_sid from dual union all

      select 223 as domain_sid from dual union all

      select 224 as domain_sid from dual union all

      select 225 as domain_sid from dual union all

      select 226 as domain_sid from dual union all

      select 227 as domain_sid from dual union all

      select 228 as domain_sid from dual union all

      select 229 as domain_sid from dual union all

      select 230 as domain_sid from dual union all

      select 231 as domain_sid from dual union all

      select 232 as domain_sid from dual union all

      select 233 as domain_sid from dual union all

      select 234 as domain_sid from dual union all

      select 235 as domain_sid from dual union all

      select 236 as domain_sid from dual union all

      select 237 as domain_sid from dual union all

      select 238 as domain_sid from dual union all

      select 239 as domain_sid from dual union all

      select 240 as domain_sid from dual union all

      select 241 as domain_sid from dual union all

      select 242 as domain_sid from dual union all

      select 243 as domain_sid from dual union all

      select 244 as domain_sid from dual union all

      select 245 as domain_sid from dual union all

      select 246 as domain_sid from dual union all

      select 247 as domain_sid from dual union all

      select 248 as domain_sid from dual union all

      select 249 as domain_sid from dual union all

      select 250 as domain_sid from dual union all

      select 251 as domain_sid from dual union all

      select 252 as domain_sid from dual union all

      select 253 as domain_sid from dual union all

      select 254 as domain_sid from dual union all

      select 255 as domain_sid from dual union all

      select 256 as domain_sid from dual union all

      select 257 as domain_sid from dual union all

      select 258 as domain_sid from dual union all

      select 259 as domain_sid from dual union all

      select 260 as domain_sid from dual union all

      select 261 as domain_sid from dual union all

      select 262 as domain_sid from dual union all

      select 263 as domain_sid from dual union all

      select 264 as domain_sid from dual union all

      select 265 as domain_sid from dual union all

      select 266 as domain_sid from dual union all

      select 267 as domain_sid from dual union all

      select 268 as domain_sid from dual union all

      select 269 as domain_sid from dual union all

      select 270 as domain_sid from dual union all

      select 271 as domain_sid from dual union all

      select 272 as domain_sid from dual union all

      select 273 as domain_sid from dual union all

      select 274 as domain_sid from dual union all

      select 275 as domain_sid from dual union all

      select 276 as domain_sid from dual union all

      select 277 as domain_sid from dual union all

      select 278 as domain_sid from dual union all

      select 279 as domain_sid from dual union all

      select 280 as domain_sid from dual union all

      select 281 as domain_sid from dual union all

      select 282 as domain_sid from dual union all

      select 283 as domain_sid from dual union all

      select 284 as domain_sid from dual union all

      select 285 as domain_sid from dual union all

      select 286 as domain_sid from dual union all

      select 287 as domain_sid from dual union all

      select 288 as domain_sid from dual union all

      select 289 as domain_sid from dual union all

      select 290 as domain_sid from dual union all

      select 291 as domain_sid from dual union all

      select 292 as domain_sid from dual union all

      select 293 as domain_sid from dual union all

      select 294 as domain_sid from dual union all

      select 295 as domain_sid from dual union all

      select 296 as domain_sid from dual union all

      select 297 as domain_sid from dual union all

      select 298 as domain_sid from dual union all

      select 299 as domain_sid from dual union all

      select 300 as domain_sid from dual union all

      select 301 as domain_sid from dual union all

      select 302 as domain_sid from dual union all

      select 303 as domain_sid from dual union all

      select 304 as domain_sid from dual union all

      select 305 as domain_sid from dual union all

      select 306 as domain_sid from dual union all

      select 307 as domain_sid from dual union all

      select 308 as domain_sid from dual union all

      select 309 as domain_sid from dual union all

      select 310 as domain_sid from dual union all

      select 311 as domain_sid from dual union all

      select 312 as domain_sid from dual union all

      select 313 as domain_sid from dual union all

      select 314 as domain_sid from dual union all

      select 315 as domain_sid from dual union all

      select 316 as domain_sid from dual union all

      select 317 as domain_sid from dual union all

      select 318 as domain_sid from dual union all

      select 319 as domain_sid from dual union all

      select 320 as domain_sid from dual union all

      select 321 as domain_sid from dual union all

      select 322 as domain_sid from dual union all

      select 323 as domain_sid from dual union all

      select 324 as domain_sid from dual union all

      select 325 as domain_sid from dual union all

      select 326 as domain_sid from dual union all

      select 327 as domain_sid from dual union all

      select 328 as domain_sid from dual union all

      select 329 as domain_sid from dual union all

      select 330 as domain_sid from dual union all

      select 331 as domain_sid from dual union all

      select 332 as domain_sid from dual union all

      select 333 as domain_sid from dual union all

      select 334 as domain_sid from dual union all

      select 335 as domain_sid from dual union all

      select 336 as domain_sid from dual union all

      select 337 as domain_sid from dual union all

      select 338 as domain_sid from dual union all

      select 339 as domain_sid from dual union all

      select 340 as domain_sid from dual union all

      select 341 as domain_sid from dual union all

      select 342 as domain_sid from dual union all

      select 343 as domain_sid from dual union all

      select 344 as domain_sid from dual union all

      select 345 as domain_sid from dual union all

      select 346 as domain_sid from dual union all

      select 347 as domain_sid from dual union all

      select 348 as domain_sid from dual union all

      select 349 as domain_sid from dual union all

      select 350 as domain_sid from dual union all

      select 351 as domain_sid from dual union all

      select 352 as domain_sid from dual union all

      select 353 as domain_sid from dual union all

      select 354 as domain_sid from dual union all

      select 355 as domain_sid from dual union all

      select 356 as domain_sid from dual union all

      select 357 as domain_sid from dual union all

      select 358 as domain_sid from dual union all

      select 359 as domain_sid from dual union all

      select 360 as domain_sid from dual union all

      select 361 as domain_sid from dual union all

      select 362 as domain_sid from dual union all

      select 363 as domain_sid from dual union all

      select 364 as domain_sid from dual union all

      select 365 as domain_sid from dual union all

      select 366 as domain_sid from dual union all

      select 367 as domain_sid from dual union all

      select 368 as domain_sid from dual union all

      select 369 as domain_sid from dual union all

      select 370 as domain_sid from dual union all

      select 371 as domain_sid from dual union all

      select 372 as domain_sid from dual union all

      select 373 as domain_sid from dual union all

      select 374 as domain_sid from dual union all

      select 375 as domain_sid from dual union all

      select 376 as domain_sid from dual union all

      select 377 as domain_sid from dual union all

      select 378 as domain_sid from dual union all

      select 379 as domain_sid from dual union all

      select 380 as domain_sid from dual union all

      select 381 as domain_sid from dual union all

      select 382 as domain_sid from dual union all

      select 383 as domain_sid from dual union all

      select 384 as domain_sid from dual union all

      select 385 as domain_sid from dual union all

      select 386 as domain_sid from dual union all

      select 387 as domain_sid from dual union all

      select 388 as domain_sid from dual union all

      select 389 as domain_sid from dual union all

      select 390 as domain_sid from dual union all

      select 391 as domain_sid from dual union all

      select 392 as domain_sid from dual union all

      select 393 as domain_sid from dual union all

      select 394 as domain_sid from dual union all

      select 395 as domain_sid from dual union all

      select 396 as domain_sid from dual union all

      select 397 as domain_sid from dual union all

      select 398 as domain_sid from dual union all

      select 399 as domain_sid from dual union all

      select 400 as domain_sid from dual union all

      select 401 as domain_sid from dual union all

      select 402 as domain_sid from dual union all

      select 403 as domain_sid from dual union all

      select 404 as domain_sid from dual union all

      select 405 as domain_sid from dual union all

      select 406 as domain_sid from dual union all

      select 407 as domain_sid from dual union all

      select 408 as domain_sid from dual union all

      select 409 as domain_sid from dual union all

      select 410 as domain_sid from dual union all

      select 411 as domain_sid from dual union all

      select 412 as domain_sid from dual union all

      select 413 as domain_sid from dual union all

      select 414 as domain_sid from dual union all

      select 415 as domain_sid from dual union all

      select 416 as domain_sid from dual union all

      select 417 as domain_sid from dual union all

      select 418 as domain_sid from dual union all

      select 419 as domain_sid from dual union all

      select 420 as domain_sid from dual union all

      select 421 as domain_sid from dual union all

      select 422 as domain_sid from dual union all

      select 423 as domain_sid from dual union all

      select 424 as domain_sid from dual union all

      select 425 as domain_sid from dual union all

      select 426 as domain_sid from dual union all

      select 427 as domain_sid from dual union all

      select 428 as domain_sid from dual union all

      select 429 as domain_sid from dual union all

      select 430 as domain_sid from dual union all

      select 431 as domain_sid from dual union all

      select 432 as domain_sid from dual union all

      select 433 as domain_sid from dual union all

      select 434 as domain_sid from dual union all

      select 435 as domain_sid from dual union all

      select 436 as domain_sid from dual union all

      select 437 as domain_sid from dual union all

      select 438 as domain_sid from dual union all

      select 439 as domain_sid from dual union all

      select 440 as domain_sid from dual union all

      select 441 as domain_sid from dual union all

      select 442 as domain_sid from dual union all

      select 443 as domain_sid from dual union all

      select 444 as domain_sid from dual union all

      select 445 as domain_sid from dual union all

      select 446 as domain_sid from dual union all

      select 447 as domain_sid from dual union all

      select 448 as domain_sid from dual union all

      select 449 as domain_sid from dual union all

      select 450 as domain_sid from dual union all

      select 451 as domain_sid from dual union all

      select 452 as domain_sid from dual union all

      select 453 as domain_sid from dual union all

      select 454 as domain_sid from dual union all

      select 455 as domain_sid from dual union all

      select 456 as domain_sid from dual union all

      select 457 as domain_sid from dual union all

      select 458 as domain_sid from dual union all

      select 459 as domain_sid from dual union all

      select 460 as domain_sid from dual union all

      select 461 as domain_sid from dual union all

      select 462 as domain_sid from dual union all

      select 463 as domain_sid from dual union all

      select 464 as domain_sid from dual union all

      select 465 as domain_sid from dual union all

      select 466 as domain_sid from dual union all

      select 467 as domain_sid from dual union all

      select 468 as domain_sid from dual union all

      select 469 as domain_sid from dual union all

      select 470 as domain_sid from dual union all

      select 471 as domain_sid from dual union all

      select 472 as domain_sid from dual union all

      select 473 as domain_sid from dual union all

      select 474 as domain_sid from dual union all

      select 475 as domain_sid from dual union all

      select 476 as domain_sid from dual union all

      select 477 as domain_sid from dual union all

      select 478 as domain_sid from dual union all

      select 479 as domain_sid from dual union all

      select 480 as domain_sid from dual union all

      select 481 as domain_sid from dual union all

      select 482 as domain_sid from dual union all

      select 483 as domain_sid from dual union all

      select 484 as domain_sid from dual union all

      select 485 as domain_sid from dual union all

      select 486 as domain_sid from dual union all

      select 487 as domain_sid from dual union all

      select 488 as domain_sid from dual union all

      select 489 as domain_sid from dual union all

      select 490 as domain_sid from dual union all

      select 491 as domain_sid from dual union all

      select 492 as domain_sid from dual union all

      select 493 as domain_sid from dual union all

      select 494 as domain_sid from dual union all

      select 495 as domain_sid from dual union all

      select 496 as domain_sid from dual union all

      select 497 as domain_sid from dual union all

      select 498 as domain_sid from dual union all

      select 499 as domain_sid from dual union all

      select 500 as domain_sid from dual union all

      select 501 as domain_sid from dual union all

      select 502 as domain_sid from dual union all

      select 503 as domain_sid from dual union all

      select 504 as domain_sid from dual union all

      select 505 as domain_sid from dual union all

      select 506 as domain_sid from dual union all

      select 507 as domain_sid from dual union all

      select 508 as domain_sid from dual union all

      select 509 as domain_sid from dual union all

      select 510 as domain_sid from dual union all

      select 511 as domain_sid from dual union all

      select 512 as domain_sid from dual union all

      select 513 as domain_sid from dual union all

      select 514 as domain_sid from dual union all

      select 515 as domain_sid from dual union all

      select 516 as domain_sid from dual union all

      select 517 as domain_sid from dual union all

      select 518 as domain_sid from dual union all

      select 519 as domain_sid from dual union all

      select 520 as domain_sid from dual union all

      select 521 as domain_sid from dual union all

      select 522 as domain_sid from dual union all

      select 523 as domain_sid from dual union all

      select 524 as domain_sid from dual union all

      select 525 as domain_sid from dual union all

      select 526 as domain_sid from dual union all

      select 527 as domain_sid from dual union all

      select 528 as domain_sid from dual union all

      select 529 as domain_sid from dual union all

      select 530 as domain_sid from dual union all

      select 531 as domain_sid from dual union all

      select 532 as domain_sid from dual union all

      select 533 as domain_sid from dual union all

      select 534 as domain_sid from dual union all

      select 535 as domain_sid from dual union all

      select 536 as domain_sid from dual union all

      select 537 as domain_sid from dual union all

      select 538 as domain_sid from dual union all

      select 539 as domain_sid from dual union all

      select 540 as domain_sid from dual union all

      select 541 as domain_sid from dual union all

      select 542 as domain_sid from dual union all

      select 543 as domain_sid from dual union all

      select 544 as domain_sid from dual union all

      select 545 as domain_sid from dual union all

      select 546 as domain_sid from dual union all

      select 547 as domain_sid from dual union all

      select 548 as domain_sid from dual union all

      select 549 as domain_sid from dual union all

      select 550 as domain_sid from dual union all

      select 551 as domain_sid from dual union all

      select 552 as domain_sid from dual union all

      select 553 as domain_sid from dual union all

      select 554 as domain_sid from dual union all

      select 555 as domain_sid from dual union all

      select 556 as domain_sid from dual union all

      select 557 as domain_sid from dual union all

      select 558 as domain_sid from dual union all

      select 559 as domain_sid from dual union all

      select 560 as domain_sid from dual union all

      select 561 as domain_sid from dual union all

      select 562 as domain_sid from dual union all

      select 563 as domain_sid from dual union all

      select 564 as domain_sid from dual union all

      select 565 as domain_sid from dual union all

      select 566 as domain_sid from dual union all

      select 567 as domain_sid from dual union all

      select 568 as domain_sid from dual union all

      select 569 as domain_sid from dual union all

      select 570 as domain_sid from dual union all

      select 571 as domain_sid from dual union all

      select 572 as domain_sid from dual union all

      select 573 as domain_sid from dual union all

      select 574 as domain_sid from dual union all

      select 575 as domain_sid from dual union all

      select 576 as domain_sid from dual union all

      select 577 as domain_sid from dual union all

      select 578 as domain_sid from dual union all

      select 579 as domain_sid from dual union all

      select 580 as domain_sid from dual union all

      select 581 as domain_sid from dual union all

      select 582 as domain_sid from dual union all

      select 583 as domain_sid from dual union all

      select 584 as domain_sid from dual union all

      select 585 as domain_sid from dual union all

      select 586 as domain_sid from dual union all

      select 587 as domain_sid from dual union all

      select 588 as domain_sid from dual union all

      select 589 as domain_sid from dual union all

      select 590 as domain_sid from dual union all

      select 591 as domain_sid from dual union all

      select 592 as domain_sid from dual union all

      select 593 as domain_sid from dual union all

      select 594 as domain_sid from dual union all

      select 595 as domain_sid from dual union all

      select 596 as domain_sid from dual union all

      select 597 as domain_sid from dual union all

      select 598 as domain_sid from dual union all

      select 599 as domain_sid from dual union all

      select 600 as domain_sid from dual union all

      select 601 as domain_sid from dual union all

      select 602 as domain_sid from dual union all

      select 603 as domain_sid from dual union all

      select 604 as domain_sid from dual union all

      select 605 as domain_sid from dual union all

      select 606 as domain_sid from dual union all

      select 607 as domain_sid from dual union all

      select 608 as domain_sid from dual union all

      select 609 as domain_sid from dual union all

      select 610 as domain_sid from dual union all

      select 611 as domain_sid from dual union all

      select 612 as domain_sid from dual union all

      select 613 as domain_sid from dual union all

      select 614 as domain_sid from dual union all

      select 615 as domain_sid from dual union all

      select 616 as domain_sid from dual union all

      select 617 as domain_sid from dual union all

      select 618 as domain_sid from dual union all

      select 619 as domain_sid from dual union all

      select 620 as domain_sid from dual union all

      select 621 as domain_sid from dual union all

      select 622 as domain_sid from dual union all

      select 623 as domain_sid from dual union all

      select 624 as domain_sid from dual union all

      select 625 as domain_sid from dual union all

      select 626 as domain_sid from dual union all

      select 627 as domain_sid from dual union all

      select 628 as domain_sid from dual union all

      select 629 as domain_sid from dual union all

      select 630 as domain_sid from dual union all

      select 631 as domain_sid from dual union all

      select 632 as domain_sid from dual union all

      select 633 as domain_sid from dual union all

      select 634 as domain_sid from dual union all

      select 635 as domain_sid from dual union all

      select 636 as domain_sid from dual union all

      select 637 as domain_sid from dual union all

      select 638 as domain_sid from dual union all

      select 639 as domain_sid from dual union all

      select 640 as domain_sid from dual union all

      select 641 as domain_sid from dual union all

      select 642 as domain_sid from dual union all

      select 643 as domain_sid from dual union all

      select 644 as domain_sid from dual union all

      select 645 as domain_sid from dual union all

      select 646 as domain_sid from dual union all

      select 647 as domain_sid from dual union all

      select 648 as domain_sid from dual union all

      select 649 as domain_sid from dual union all

      select 650 as domain_sid from dual union all

      select 651 as domain_sid from dual union all

      select 652 as domain_sid from dual union all

      select 653 as domain_sid from dual union all

      select 654 as domain_sid from dual union all

      select 655 as domain_sid from dual union all

      select 656 as domain_sid from dual union all

      select 657 as domain_sid from dual union all

      select 658 as domain_sid from dual union all

      select 659 as domain_sid from dual union all

      select 660 as domain_sid from dual union all

      select 661 as domain_sid from dual union all

      select 662 as domain_sid from dual union all

      select 663 as domain_sid from dual union all

      select 664 as domain_sid from dual union all

      select 665 as domain_sid from dual union all

      select 666 as domain_sid from dual union all

      select 667 as domain_sid from dual union all

      select 668 as domain_sid from dual union all

      select 669 as domain_sid from dual union all

      select 670 as domain_sid from dual union all

      select 671 as domain_sid from dual union all

      select 672 as domain_sid from dual union all

      select 673 as domain_sid from dual union all

      select 674 as domain_sid from dual union all

      select 675 as domain_sid from dual union all

      select 676 as domain_sid from dual union all

      select 677 as domain_sid from dual union all

      select 678 as domain_sid from dual union all

      select 679 as domain_sid from dual union all

      select 680 as domain_sid from dual union all

      select 681 as domain_sid from dual union all

      select 682 as domain_sid from dual union all

      select 683 as domain_sid from dual union all

      select 684 as domain_sid from dual union all

      select 685 as domain_sid from dual union all

      select 686 as domain_sid from dual union all

      select 687 as domain_sid from dual union all

      select 688 as domain_sid from dual union all

      select 689 as domain_sid from dual union all

      select 690 as domain_sid from dual union all

      select 691 as domain_sid from dual union all

      select 692 as domain_sid from dual union all

      select 693 as domain_sid from dual union all

      select 694 as domain_sid from dual union all

      select 695 as domain_sid from dual union all

      select 696 as domain_sid from dual union all

      select 697 as domain_sid from dual union all

      select 698 as domain_sid from dual union all

      select 699 as domain_sid from dual union all

      select 700 as domain_sid from dual union all

      select 701 as domain_sid from dual union all

      select 702 as domain_sid from dual union all

      select 703 as domain_sid from dual union all

      select 704 as domain_sid from dual union all

      select 705 as domain_sid from dual union all

      select 706 as domain_sid from dual union all

      select 707 as domain_sid from dual union all

      select 708 as domain_sid from dual union all

      select 709 as domain_sid from dual union all

      select 710 as domain_sid from dual union all

      select 711 as domain_sid from dual union all

      select 712 as domain_sid from dual union all

      select 713 as domain_sid from dual union all

      select 714 as domain_sid from dual union all

      select 715 as domain_sid from dual union all

      select 716 as domain_sid from dual union all

      select 717 as domain_sid from dual union all

      select 718 as domain_sid from dual union all

      select 719 as domain_sid from dual union all

      select 720 as domain_sid from dual union all

      select 721 as domain_sid from dual union all

      select 722 as domain_sid from dual union all

      select 723 as domain_sid from dual union all

      select 724 as domain_sid from dual union all

      select 725 as domain_sid from dual union all

      select 726 as domain_sid from dual union all

      select 727 as domain_sid from dual union all

      select 728 as domain_sid from dual union all

      select 729 as domain_sid from dual union all

      select 730 as domain_sid from dual union all

      select 731 as domain_sid from dual union all

      select 732 as domain_sid from dual union all

      select 733 as domain_sid from dual union all

      select 734 as domain_sid from dual union all

      select 735 as domain_sid from dual union all

      select 736 as domain_sid from dual union all

      select 737 as domain_sid from dual union all

      select 738 as domain_sid from dual union all

      select 739 as domain_sid from dual union all

      select 740 as domain_sid from dual union all

      select 741 as domain_sid from dual union all

      select 742 as domain_sid from dual union all

      select 743 as domain_sid from dual union all

      select 744 as domain_sid from dual union all

      select 745 as domain_sid from dual union all

      select 746 as domain_sid from dual union all

      select 747 as domain_sid from dual union all

      select 748 as domain_sid from dual union all

      select 749 as domain_sid from dual union all

      select 750 as domain_sid from dual union all

      select 751 as domain_sid from dual union all

      select 752 as domain_sid from dual union all

      select 753 as domain_sid from dual union all

      select 754 as domain_sid from dual union all

      select 755 as domain_sid from dual union all

      select 756 as domain_sid from dual union all

      select 757 as domain_sid from dual union all

      select 758 as domain_sid from dual union all

      select 759 as domain_sid from dual union all

      select 760 as domain_sid from dual union all

      select 761 as domain_sid from dual union all

      select 762 as domain_sid from dual union all

      select 763 as domain_sid from dual union all

      select 764 as domain_sid from dual union all

      select 765 as domain_sid from dual union all

      select 766 as domain_sid from dual union all

      select 767 as domain_sid from dual union all

      select 768 as domain_sid from dual union all

      select 769 as domain_sid from dual union all

      select 770 as domain_sid from dual union all

      select 771 as domain_sid from dual union all

      select 772 as domain_sid from dual union all

      select 773 as domain_sid from dual union all

      select 774 as domain_sid from dual union all

      select 775 as domain_sid from dual union all

      select 776 as domain_sid from dual union all

      select 777 as domain_sid from dual union all

      select 778 as domain_sid from dual union all

      select 779 as domain_sid from dual union all

      select 780 as domain_sid from dual union all

      select 781 as domain_sid from dual union all

      select 782 as domain_sid from dual union all

      select 783 as domain_sid from dual union all

      select 784 as domain_sid from dual union all

      select 785 as domain_sid from dual union all

      select 786 as domain_sid from dual union all

      select 787 as domain_sid from dual union all

      select 788 as domain_sid from dual union all

      select 789 as domain_sid from dual union all

      select 790 as domain_sid from dual union all

      select 791 as domain_sid from dual union all

      select 792 as domain_sid from dual union all

      select 793 as domain_sid from dual union all

      select 794 as domain_sid from dual union all

      select 795 as domain_sid from dual union all

      select 796 as domain_sid from dual union all

      select 797 as domain_sid from dual union all

      select 798 as domain_sid from dual union all

      select 799 as domain_sid from dual union all

      select 800 as domain_sid from dual union all

      select 801 as domain_sid from dual union all

      select 802 as domain_sid from dual union all

      select 803 as domain_sid from dual union all

      select 804 as domain_sid from dual union all

      select 805 as domain_sid from dual union all

      select 806 as domain_sid from dual union all

      select 807 as domain_sid from dual union all

      select 808 as domain_sid from dual union all

      select 809 as domain_sid from dual union all

      select 810 as domain_sid from dual union all

      select 811 as domain_sid from dual union all

      select 812 as domain_sid from dual union all

      select 813 as domain_sid from dual union all

      select 814 as domain_sid from dual union all

      select 815 as domain_sid from dual union all

      select 816 as domain_sid from dual union all

      select 817 as domain_sid from dual union all

      select 818 as domain_sid from dual union all

      select 819 as domain_sid from dual union all

      select 820 as domain_sid from dual union all

      select 821 as domain_sid from dual union all

      select 822 as domain_sid from dual union all

      select 823 as domain_sid from dual union all

      select 824 as domain_sid from dual union all

      select 825 as domain_sid from dual union all

      select 826 as domain_sid from dual union all

      select 827 as domain_sid from dual union all

      select 828 as domain_sid from dual union all

      select 829 as domain_sid from dual union all

      select 830 as domain_sid from dual union all

      select 831 as domain_sid from dual union all

      select 832 as domain_sid from dual union all

      select 833 as domain_sid from dual union all

      select 834 as domain_sid from dual union all

      select 835 as domain_sid from dual union all

      select 836 as domain_sid from dual union all

      select 837 as domain_sid from dual union all

      select 838 as domain_sid from dual union all

      select 839 as domain_sid from dual union all

      select 840 as domain_sid from dual union all

      select 841 as domain_sid from dual union all

      select 842 as domain_sid from dual union all

      select 843 as domain_sid from dual union all

      select 844 as domain_sid from dual union all

      select 845 as domain_sid from dual union all

      select 846 as domain_sid from dual union all

      select 847 as domain_sid from dual union all

      select 848 as domain_sid from dual union all

      select 849 as domain_sid from dual union all

      select 850 as domain_sid from dual union all

      select 851 as domain_sid from dual union all

      select 852 as domain_sid from dual union all

      select 853 as domain_sid from dual union all

      select 854 as domain_sid from dual union all

      select 855 as domain_sid from dual union all

      select 856 as domain_sid from dual union all

      select 857 as domain_sid from dual union all

      select 858 as domain_sid from dual union all

      select 859 as domain_sid from dual union all

      select 860 as domain_sid from dual union all

      select 861 as domain_sid from dual union all

      select 862 as domain_sid from dual union all

      select 863 as domain_sid from dual union all

      select 864 as domain_sid from dual union all

      select 865 as domain_sid from dual union all

      select 866 as domain_sid from dual union all

      select 867 as domain_sid from dual union all

      select 868 as domain_sid from dual union all

      select 869 as domain_sid from dual union all

      select 870 as domain_sid from dual union all

      select 871 as domain_sid from dual union all

      select 872 as domain_sid from dual union all

      select 873 as domain_sid from dual union all

      select 874 as domain_sid from dual union all

      select 875 as domain_sid from dual union all

      select 876 as domain_sid from dual union all

      select 877 as domain_sid from dual union all

      select 878 as domain_sid from dual union all

      select 879 as domain_sid from dual union all

      select 880 as domain_sid from dual union all

      select 881 as domain_sid from dual union all

      select 882 as domain_sid from dual union all

      select 883 as domain_sid from dual union all

      select 884 as domain_sid from dual union all

      select 885 as domain_sid from dual union all

      select 886 as domain_sid from dual union all

      select 887 as domain_sid from dual union all

      select 888 as domain_sid from dual union all

      select 889 as domain_sid from dual union all

      select 890 as domain_sid from dual union all

      select 891 as domain_sid from dual union all

      select 892 as domain_sid from dual union all

      select 893 as domain_sid from dual union all

      select 894 as domain_sid from dual union all

      select 895 as domain_sid from dual union all

      select 896 as domain_sid from dual union all

      select 897 as domain_sid from dual union all

      select 898 as domain_sid from dual union all

      select 899 as domain_sid from dual union all

      select 900 as domain_sid from dual union all

      select 901 as domain_sid from dual union all

      select 902 as domain_sid from dual union all

      select 903 as domain_sid from dual union all

      select 904 as domain_sid from dual union all

      select 905 as domain_sid from dual union all

      select 906 as domain_sid from dual union all

      select 907 as domain_sid from dual union all

      select 908 as domain_sid from dual union all

      select 909 as domain_sid from dual union all

      select 910 as domain_sid from dual union all

      select 911 as domain_sid from dual union all

      select 912 as domain_sid from dual union all

      select 913 as domain_sid from dual union all

      select 914 as domain_sid from dual union all

      select 915 as domain_sid from dual union all

      select 916 as domain_sid from dual union all

      select 917 as domain_sid from dual union all

      select 918 as domain_sid from dual union all

      select 919 as domain_sid from dual union all

      select 920 as domain_sid from dual union all

      select 921 as domain_sid from dual union all

      select 922 as domain_sid from dual union all

      select 923 as domain_sid from dual union all

      select 924 as domain_sid from dual union all

      select 925 as domain_sid from dual union all

      select 926 as domain_sid from dual union all

      select 927 as domain_sid from dual union all

      select 928 as domain_sid from dual union all

      select 929 as domain_sid from dual union all

      select 930 as domain_sid from dual union all

      select 931 as domain_sid from dual union all

      select 932 as domain_sid from dual union all

      select 933 as domain_sid from dual union all

      select 934 as domain_sid from dual union all

      select 935 as domain_sid from dual union all

      select 936 as domain_sid from dual union all

      select 937 as domain_sid from dual union all

      select 938 as domain_sid from dual union all

      select 939 as domain_sid from dual union all

      select 940 as domain_sid from dual union all

      select 941 as domain_sid from dual union all

      select 942 as domain_sid from dual union all

      select 943 as domain_sid from dual union all

      select 944 as domain_sid from dual union all

      select 945 as domain_sid from dual union all

      select 946 as domain_sid from dual union all

      select 947 as domain_sid from dual union all

      select 948 as domain_sid from dual union all

      select 949 as domain_sid from dual union all

      select 950 as domain_sid from dual union all

      select 951 as domain_sid from dual union all

      select 952 as domain_sid from dual union all

      select 953 as domain_sid from dual union all

      select 954 as domain_sid from dual union all

      select 955 as domain_sid from dual union all

      select 956 as domain_sid from dual union all

      select 957 as domain_sid from dual union all

      select 958 as domain_sid from dual union all

      select 959 as domain_sid from dual union all

      select 960 as domain_sid from dual union all

      select 961 as domain_sid from dual union all

      select 962 as domain_sid from dual union all

      select 963 as domain_sid from dual union all

      select 964 as domain_sid from dual union all

      select 965 as domain_sid from dual union all

      select 966 as domain_sid from dual union all

      select 967 as domain_sid from dual union all

      select 968 as domain_sid from dual union all

      select 969 as domain_sid from dual union all

      select 970 as domain_sid from dual union all

      select 971 as domain_sid from dual union all

      select 972 as domain_sid from dual union all

      select 973 as domain_sid from dual union all

      select 974 as domain_sid from dual union all

      select 975 as domain_sid from dual union all

      select 976 as domain_sid from dual union all

      select 977 as domain_sid from dual union all

      select 978 as domain_sid from dual union all

      select 979 as domain_sid from dual union all

      select 980 as domain_sid from dual union all

      select 981 as domain_sid from dual union all

      select 982 as domain_sid from dual union all

      select 983 as domain_sid from dual union all

      select 984 as domain_sid from dual union all

      select 985 as domain_sid from dual union all

      select 986 as domain_sid from dual union all

      select 987 as domain_sid from dual union all

      select 988 as domain_sid from dual union all

      select 989 as domain_sid from dual union all

      select 990 as domain_sid from dual union all

      select 991 as domain_sid from dual union all

      select 992 as domain_sid from dual union all

      select 993 as domain_sid from dual union all

      select 994 as domain_sid from dual union all

      select 995 as domain_sid from dual union all

      select 996 as domain_sid from dual union all

      select 997 as domain_sid from dual union all

      select 998 as domain_sid from dual union all

      select 999 as domain_sid from dual union all

      select 1000 as domain_sid from dual union all

      select 1001 as domain_sid from dual union all

      select 1002 as domain_sid from dual union all

      select 1003 as domain_sid from dual union all

      select 1004 as domain_sid from dual union all

      select 1005 as domain_sid from dual union all

      select 1006 as domain_sid from dual union all

      select 1007 as domain_sid from dual union all

      select 1008 as domain_sid from dual union all

      select 1009 as domain_sid from dual union all

      select 1010 as domain_sid from dual union all

      select 1011 as domain_sid from dual union all

      select 1012 as domain_sid from dual union all

      select 1013 as domain_sid from dual union all

      select 1014 as domain_sid from dual union all

      select 1015 as domain_sid from dual union all

      select 1016 as domain_sid from dual union all

      select 1017 as domain_sid from dual union all

      select 1018 as domain_sid from dual union all

      select 1019 as domain_sid from dual union all

      select 1020 as domain_sid from dual union all

      select 1021 as domain_sid from dual union all

      select 1022 as domain_sid from dual union all

      select 1023 as domain_sid from dual union all

      select 1024 as domain_sid from dual union all

      select 1025 as domain_sid from dual union all

      select 1026 as domain_sid from dual union all

      select 1027 as domain_sid from dual union all

      select 1028 as domain_sid from dual union all

      select 1029 as domain_sid from dual union all

      select 1030 as domain_sid from dual union all

      select 1031 as domain_sid from dual union all

      select 1032 as domain_sid from dual union all

      select 1033 as domain_sid from dual union all

      select 1034 as domain_sid from dual union all

      select 1035 as domain_sid from dual union all

      select 1036 as domain_sid from dual union all

      select 1037 as domain_sid from dual union all

      select 1038 as domain_sid from dual union all

      select 1039 as domain_sid from dual union all

      select 1040 as domain_sid from dual union all

      select 1041 as domain_sid from dual union all

      select 1042 as domain_sid from dual union all

      select 1043 as domain_sid from dual union all

      select 1044 as domain_sid from dual union all

      select 1045 as domain_sid from dual union all

      select 1046 as domain_sid from dual union all

      select 1047 as domain_sid from dual union all

      select 1048 as domain_sid from dual union all

      select 1049 as domain_sid from dual union all

      select 1050 as domain_sid from dual union all

      select 1051 as domain_sid from dual union all

      select 1052 as domain_sid from dual union all

      select 1053 as domain_sid from dual union all

      select 1054 as domain_sid from dual union all

      select 1055 as domain_sid from dual union all

      select 1056 as domain_sid from dual union all

      select 1057 as domain_sid from dual union all

      select 1058 as domain_sid from dual union all

      select 1059 as domain_sid from dual union all

      select 1060 as domain_sid from dual union all

      select 1061 as domain_sid from dual union all

      select 1062 as domain_sid from dual union all

      select 1063 as domain_sid from dual union all

      select 1064 as domain_sid from dual union all

      select 1065 as domain_sid from dual union all

      select 1066 as domain_sid from dual union all

      select 1067 as domain_sid from dual union all

      select 1068 as domain_sid from dual union all

      select 1069 as domain_sid from dual union all

      select 1070 as domain_sid from dual union all

      select 1071 as domain_sid from dual union all

      select 1072 as domain_sid from dual union all

      select 1073 as domain_sid from dual union all

      select 1074 as domain_sid from dual union all

      select 1075 as domain_sid from dual union all

      select 1076 as domain_sid from dual union all

      select 1077 as domain_sid from dual union all

      select 1078 as domain_sid from dual union all

      select 1079 as domain_sid from dual union all

      select 1080 as domain_sid from dual union all

      select 1081 as domain_sid from dual union all

      select 1082 as domain_sid from dual union all

      select 1083 as domain_sid from dual union all

      select 1084 as domain_sid from dual union all

      select 1085 as domain_sid from dual union all

      select 1086 as domain_sid from dual union all

      select 1087 as domain_sid from dual union all

      select 1088 as domain_sid from dual union all

      select 1089 as domain_sid from dual union all

      select 1090 as domain_sid from dual union all

      select 1091 as domain_sid from dual union all

      select 1092 as domain_sid from dual union all

      select 1093 as domain_sid from dual union all

      select 1094 as domain_sid from dual union all

      select 1095 as domain_sid from dual union all

      select 1096 as domain_sid from dual union all

      select 1097 as domain_sid from dual union all

      select 1098 as domain_sid from dual union all

      select 1099 as domain_sid from dual union all

      select 1100 as domain_sid from dual union all

      select 1101 as domain_sid from dual union all

      select 1102 as domain_sid from dual union all

      select 1103 as domain_sid from dual union all

      select 1104 as domain_sid from dual union all

      select 1105 as domain_sid from dual union all

      select 1106 as domain_sid from dual union all

      select 1107 as domain_sid from dual union all

      select 1108 as domain_sid from dual union all

      select 1109 as domain_sid from dual union all

      select 1110 as domain_sid from dual union all

      select 1111 as domain_sid from dual union all

      select 1112 as domain_sid from dual union all

      select 1113 as domain_sid from dual union all

      select 1114 as domain_sid from dual union all

      select 1115 as domain_sid from dual union all

      select 1116 as domain_sid from dual union all

      select 1117 as domain_sid from dual union all

      select 1118 as domain_sid from dual union all

      select 1119 as domain_sid from dual union all

      select 1120 as domain_sid from dual union all

      select 1121 as domain_sid from dual union all

      select 1122 as domain_sid from dual union all

      select 1123 as domain_sid from dual union all

      select 1124 as domain_sid from dual union all

      select 1125 as domain_sid from dual union all

      select 1126 as domain_sid from dual union all

      select 1127 as domain_sid from dual union all

      select 1128 as domain_sid from dual union all

      select 1129 as domain_sid from dual union all

      select 1130 as domain_sid from dual union all

      select 1131 as domain_sid from dual union all

      select 1132 as domain_sid from dual union all

      select 1133 as domain_sid from dual union all

      select 1134 as domain_sid from dual union all

      select 1135 as domain_sid from dual union all

      select 1136 as domain_sid from dual union all

      select 1137 as domain_sid from dual union all

      select 1138 as domain_sid from dual union all

      select 1139 as domain_sid from dual union all

      select 1140 as domain_sid from dual union all

      select 1141 as domain_sid from dual union all

      select 1142 as domain_sid from dual union all

      select 1143 as domain_sid from dual union all

      select 1144 as domain_sid from dual union all

      select 1145 as domain_sid from dual union all

      select 1146 as domain_sid from dual union all

      select 1147 as domain_sid from dual union all

      select 1148 as domain_sid from dual union all

      select 1149 as domain_sid from dual union all

      select 1150 as domain_sid from dual union all

      select 1151 as domain_sid from dual union all

      select 1152 as domain_sid from dual union all

      select 1153 as domain_sid from dual union all

      select 1154 as domain_sid from dual union all

      select 1155 as domain_sid from dual union all

      select 1156 as domain_sid from dual union all

      select 1157 as domain_sid from dual union all

      select 1158 as domain_sid from dual union all

      select 1159 as domain_sid from dual union all

      select 1160 as domain_sid from dual union all

      select 1161 as domain_sid from dual union all

      select 1162 as domain_sid from dual union all

      select 1163 as domain_sid from dual union all

      select 1164 as domain_sid from dual union all

      select 1165 as domain_sid from dual union all

      select 1166 as domain_sid from dual union all

      select 1167 as domain_sid from dual union all

      select 1168 as domain_sid from dual union all

      select 1169 as domain_sid from dual union all

      select 1170 as domain_sid from dual union all

      select 1171 as domain_sid from dual union all

      select 1172 as domain_sid from dual union all

      select 1173 as domain_sid from dual union all

      select 1174 as domain_sid from dual union all

      select 1175 as domain_sid from dual union all

      select 1176 as domain_sid from dual union all

      select 1177 as domain_sid from dual union all

      select 1178 as domain_sid from dual union all

      select 1179 as domain_sid from dual union all

      select 1180 as domain_sid from dual union all

      select 1181 as domain_sid from dual union all

      select 1182 as domain_sid from dual union all

      select 1183 as domain_sid from dual union all

      select 1184 as domain_sid from dual union all

      select 1185 as domain_sid from dual union all

      select 1186 as domain_sid from dual union all

      select 1187 as domain_sid from dual union all

      select 1188 as domain_sid from dual union all

      select 1189 as domain_sid from dual union all

      select 1190 as domain_sid from dual union all

      select 1191 as domain_sid from dual union all

      select 1192 as domain_sid from dual union all

      select 1193 as domain_sid from dual union all

      select 1194 as domain_sid from dual union all

      select 1195 as domain_sid from dual union all

      select 1196 as domain_sid from dual union all

      select 1197 as domain_sid from dual union all

      select 1198 as domain_sid from dual union all

      select 1199 as domain_sid from dual union all

      select 1200 as domain_sid from dual union all

      select 1201 as domain_sid from dual union all

      select 1202 as domain_sid from dual union all

      select 1203 as domain_sid from dual union all

      select 1204 as domain_sid from dual union all

      select 1205 as domain_sid from dual union all

      select 1206 as domain_sid from dual union all

      select 1207 as domain_sid from dual union all

      select 1208 as domain_sid from dual union all

      select 1209 as domain_sid from dual union all

      select 1210 as domain_sid from dual union all

      select 1211 as domain_sid from dual union all

      select 1212 as domain_sid from dual union all

      select 1213 as domain_sid from dual union all

      select 1214 as domain_sid from dual union all

      select 1215 as domain_sid from dual union all

      select 1216 as domain_sid from dual union all

      select 1217 as domain_sid from dual union all

      select 1218 as domain_sid from dual union all

      select 1219 as domain_sid from dual union all

      select 1220 as domain_sid from dual union all

      select 1221 as domain_sid from dual union all

      select 1222 as domain_sid from dual union all

      select 1223 as domain_sid from dual ';

      procedure p1(p_clob  in clob)

      is

      type ref_bpw is ref cursor;

       

         c_cursor                ref_bpw;

      v_dsid varchar2(100);

      begin

       

      open c_cursor  for p_clob;

      loop

      fetch c_cursor into v_dsid ;

      exit when c_cursor%notfound;

      dbms_output.put_line('v_dsid -- >'||v_dsid);

       

      end loop;

       

      end ;

       

      begin

      p1(v_clob);

       

      end ;

      Error details :

      rror report:

      ORA-06550: line 2, column 15:

      PLS-00172: string literal too long

      06550. 00000 -  "line %s, column %s:\n%s"

      *Cause:    Usually a PL/SQL compilation error.

      *Action:

       

      [/code]

       

      Thanks,

      P Prakash