Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default BLOBs in Oracle

    I need to store and retrieve BLOBs in Oracle 10 through CFMX. Can someone
    provide sample code for how I can do that? (i.e., CFQUERY and related code for
    inserting the BLOB in the db and similar code for retrieving it) Thanks!

    pdrich Guest

  2. Similar Questions and Discussions

    1. BLOBs to CLOBS???
      I was curious to see if anyone has had experienced convering a BLOB into CLOB in Oracle 8i using PL/SQL???
    2. Can't display images stored as Oracle BLOBs
      I have been fighting with storing/retrieving images in an Oracle database using ASP for over a month now. I have been able to store images < 64K w/...
    3. OLE DB and BLOBs
      I have a Windows OLE DB COM application written in Microsoft C++ that processes MSSQL tables containing BLOB columns. I need to port this code for...
    4. perl dbi oracle and blobs
      dominant wrote: I would suggest you read: perldoc DBI and perldoc DBD::Oracle -- $a=24;split//,240513;s/\B/ => /for@@=qw(ac ab bc ba cb ca...
    5. Smart BLOBs
      I have a feeling I already know (and hate) the answer to this question: In an sbspace, is it ever possible to have more than one BLOB on the same...
  3. #2

    Default Re: BLOBs in Oracle

    I'm still pursuing options for inserting and selecting BLOBs in Oracle through
    CF. We are using Oracle Thin client. I must insert and select BLOBs (can't
    use CLOBs in this case) in Oracle. Has anyone used the jBLOB CFXs? I'm trying
    to get them to work, but I'm having some problems. Not sure that's the way to
    go. Any help much appreciated.

    pdrich Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139