We help IT Professionals succeed at work.

Huge BLOB data type in Oracle how to retrieve in vb.net and crystal reports

669 Views
Last Modified: 2017-03-27
I have a BLOB data type and have a oracle connection, data adapter, and dataset.  I want to read the content of the BLOB but cannot.  How do I go about doing that?  The field is GDTXFT I am trying to read.  

        OracleDataAdapter2.Fill(ds, "TEST")

        MsgBox(ds.Tables("TEST").Rows.Count)

        MsgBox(ds.Tables("TEST").Rows(0).Item("GDTXFT"))

Open in new window

Comment
Watch Question

Ultimately if I can read the data I want to put it on a crystal report.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Have you tried putting the blob on a report?

mlmcc
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.