Print Page | Close Window

Oracle Stored Procedure BLOB Not Supported

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22236
Printed Date: 24 Apr 2024 at 2:34am


Topic: Oracle Stored Procedure BLOB Not Supported
Posted By: karthikkjm
Subject: Oracle Stored Procedure BLOB Not Supported
Date Posted: 13 Feb 2017 at 6:46pm
Hi,

i designed a report in crystal reports for visual studio 2008 with Oracle 11g Database. In my stored procedure i have 2 columns of BLOB Data type (for logo) and i connected it using Microsoft OLE DB Provider for Oracle.

when i removed the BLOB columns, then the stored procedure gets added to the report.

when i not removed the BLOB columns, then exception occurs at the time of passing the values to the input parameter of the report.

exception screenshot: https://goo.gl/Hxey1b - https://goo.gl/Hxey1b

-------------
karthik



Print Page | Close Window