This discussion is archived
0 Replies Latest reply: Nov 3, 2011 2:47 PM by 897991 RSS

Crystal Reports can't add stored procedure using Oracle Provider for OLE DB

897991 Newbie
Currently Being Moderated
Hello,

I am trying to bind an oracle stored procedure to a crystal report through Visual Studio 2008.
This oracle stored procedure returns a ref cursor.

I am using an oracle 11g database (11.2.0.2.0) .

When I use the Oracle Provider For OLE DB driver to bind the store procedure with the report, I get the following error message:

Description : ORA -06550 Line 1 Column 7
PLS 00306 wrong number of types or arguments to the "Strored Procedure Name"

But When I use the Microsoft OLE DB provider for oracle driver, I can bind the stored procedure to the report successfully .
I cannot use the Microsoft OLE DB provider for oracle driver because it does not support the CLOB data type which I plan on having the stored procedure return once I can get everything working.

I have tried setting PLSQLRSET = 1 IN "HKEY_LOCAL_MACHINE\SOFTWARE\KEY_OraDb11g_home1\OLEDB", but that does not seem to work either

Any assistance would be greatly Appreciated

My Stored procedure is very simple as the moment (I just need to get it working then I'll add more stuff). Here's what it looks like:

CREATE OR REPLACE PACKAGE PROMO.PKG_REPORT as
TYPE OUT_Type IS REF CURSOR;
procedure Report_ThisReport (
p_ThisIdField IN number,
IO_CURSOR IN OUT OUT_Type
);
end PKG_REPORT;
/

CREATE OR REPLACE PACKAGE BODY PROMO.PKG_REPORT as
procedure REPORT_ThisReport (
p_ThisIdField IN number,
IO_CURSOR IN OUT OUT_Type
)
IS
BEGIN
OPEN IO_CURSOR FOR
SELECT ThisField
FROM ThisTable
WHERE ThisIdField = p_ThisIdField ;
END REPORT_ThisReport;

end PKG_REPORT;

/

Edited by: 894988 on Nov 3, 2011 2:45 PM

Edited by: 894988 on Nov 3, 2011 2:46 PM

Edited by: 894988 on Nov 3, 2011 2:47 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points