2 Replies Latest reply: Mar 7, 2011 5:31 PM by 845498 RSS

    HOW CAN VB (MTS) USE BLOBS AND CLOBS

    320872
      HOW CAN VB (MTS) USE BLOBS AND CLOBS

      We use vb 6.0, mts and oracle 8i. What are the steps to allow the mts components to use blobs?
      What needs to be installed or set up in the development environment and client environments?

      Thanks
        • 1. re:HOW CAN VB (MTS) USE BLOBS AND CLOBS
          360262
          Hi Frank,

          Unfortunately, BLOBs and CLOBs can be used in VB only if you are using the OraOLEDB provided by oracle in conjuction with ADO. There is a sample at the following link which will demonstrate the use of LOB's returning by the stored procedures and input to the stored procedures.

          http://otn.oracle.com/sample_code/tech/windows/ole_db/oledb8/content.html [Refer to Passing LOB parameters from and to a stored procedure]

          Good Luck!
          Kodali
          • 2. Re: HOW CAN VB (MTS) USE BLOBS
            845498
            Hello, I hope you are well, could you give me the link of your previous example again please?, because it does not work or no longer exists. thanks.