Re: Crystal Report - Oracle Stored Procedure

We've tried to use stored functions (NOT stored procedures) from Crystal in the SELECT clause without success. Crystal doesn't understand to call the function on a row-by-row basis. It tries to run the function first, then obtain the dataset, which of course makes no sense. We use Crystal Reports 4.5.

-- 
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.

Tim Adamec <tadamec_at_blitherakt.com> wrote in article
<13MH1.228$Np1.683220_at_newsread.com>...


> My guess would be one of two things:


> 

> -The user you're using to access the SP doesn't have enough authority

> to run the stored proecdure. This could also be caused if the user

 account


> doesn't have permissions on one or more of the tables, views, SP's, etc.


> that you call within your function.

> 

> -You're not fully qualifying the SP. Try putting the actual package name

 in


> front of the function call. For example, if the function is called


> "Strange" and is located in the "DoSomething" package, try calling it

 like


> this:


> 

>   SELECT DoSomething.Strange() FROM sys.dual

> 

> Hope that helps!

> 

> Timothy M. Adamec

> 

> mateev_at_geocities.com wrote

> >I work with Crystal Report 5 and Oracle 7.3.

> >

> >Can link I Crystal Report with Oracle Stored Procedure (Function)?

> >I can't receive data from Oracle Stored Procedure and Function.

> >

> >Can anyone help me?

> >

> >Georgy Mateev

> >mateev_at_geocities.com

> >

> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----

> >http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum

> 

> 

> 

> 

>