Re: Oracle with Crystal Reports 11.5.3

Try using a ref cursor defined with a sys_refcursor definition..

"Jer" <jer006@xxxxxxxxx> wrote in message
news:e74287b9-684c-4c43-b1f4-f8c8924685c9@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thank you Dan, looks like a lot of great information there.

For the strong typed ref cursors do they also have to be of a table or
view rowtype (I noticed that defining a record type does not work with
crystal)?

After working with SQL Server and crystal it seems a bit overkill to
have to create a separate empty table (or view) which looks like the
return result of the stored procedure if my procedure is selecting
multiple fields from multiple tables...

I also noticed that Crystal reports has issues finding stored
procedures which are part of a package - it will find them initially
but when you verify the database it removes the call - I was able to
get around this by creating a stored procedure which was not part of
any package!

Thanks


.

Relevant Pages

  • .NET & Oracle Ref Cursor
    ... I'm creating a .NET service using an Oracle backend. ... stored procedure. ... ref cursor must be declared as part of a package. ...
    (microsoft.public.dotnet.faqs)
  • Re: Oracle with Crystal Reports 11.5.3
    ... For the strong typed ref cursors do they also have to be of a table or ... return result of the stored procedure if my procedure is selecting ... multiple fields from multiple tables... ... procedures which are part of a package - it will find them initially ...
    (comp.databases.oracle.server)
  • Oracle Reference Cursors using Enterprise Library
    ... I have the trouble with the stored procedure returning ref cursor. ... CREATE OR REPLACE PACKAGE employee_main ... executes without problems. ...
    (microsoft.public.dotnet.framework)
  • Re: Use bind variables in a view
    ... >Is to basically wrap the view creation with a stored procedure, ... - define the variables in the package spec ... Alternatively (courtesy of Tom Kyte) you could set up a context, ...
    (comp.databases.oracle.server)
  • Re: How to force a SSIS package step to fail?
    ... I've now tried to add an Expression to the Precedence Constraints, bit I have some troubles defining the Varible it's going to look at..:-(. ... My Stored Procedure returns a character value, but when I set the step to return the value to the type String, then I get an "String: the Size property has an invalid size of 0" error everytime I execute the task. ... Why would you want the package to fail? ... could "fail" steps in order to control package flow, ...
    (microsoft.public.sqlserver.dts)