Re: Crystal Report - Oracle Stored Procedure

From: Tim Adamec <tadamec_at_blitherakt.com>
Date: 1998/09/03
Message-ID: <13MH1.228$Np1.683220@newsread.com>#1/1

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
Received on Thu Sep 03 1998 - 00:00:00 CDT