Re: Crystal Report - Oracle Stored Procedure
Date: 1998/09/03
Message-ID: <13MH1.228$Np1.683220_at_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
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 CEST