Thanks to all for your reactions, but I already did all those things.
I keep having problems :
1) I created a public synonym in Oracle and granted execute on it to the
user. When calling that stored procedure from PB using RPCFUNC, I get an
Oracle error saying that the package does not exist. When I use DECLARE
instead of RPCFUNC everything works fine, so the user has the proper rights.
2) When I declare the local external function using the owner (like
SMITH.PCK_GET_PREVIOUS_UP.GET_PREV_SALES_UNITPRICE), I also get an Oracle
error when calling that function from PB. The error says that I use to many
identifiers.
Jan
-----Original Message-----
From: Ren� Ullrich
To: Caals Jan
Sent: 23/09/99 8:04
Subject: Re: PFCSIG sorry, non PFC
Every oracle user operates in his own naming room. If you want to access
a ressource of another user you have to write owner.ressource e.g.
SMITH.PCK_GET_PREVIOUS_UP.GET_PREV_SALES_UNITPRICE (if the
owner is smith). If you don't want to change this for all applications
you can create a public synonym in oracle:
CREATE PUBLIC SYSNONYM PCK_GET_PREVIOUS_UP FOR
SMITH.PCK_GET_PREVIOUS_UP;
and your application will work (if the user has all nessecary rights).
Hope this helps.
Rene
Caals Jan wrote:
> Hello,
>
> I'm using PB6.5 with Oracle 8.0.4. I use Oracle stored procedures
which I
> call from my PB application. I'm declaring these stored procedures as
local
> external functions with RPCFUNC
>
> example:
> FUNCTION real of_getprevioussalesup(long custid, long prodid,string
> sfrc_type, date valdate,date daydate, string curr) RPCFUNC alias for
> "PCK_GET_PREVIOUS_UP.GET_PREV_SALES_UNITPRICE"
>
> This works fine as long as the PB application logs on to Oracle as the
OWNER
> of these Oracle stored procedures . When the PB application logs on
to
> Oracle as another user than the owner of the Oracle stored procedures
, I
> get an Oracle error that the stored procedure doesn't exist. This
user has
> all rights needed to execute the stored procedures .
> When I use DECLARE PROCEDURE FOR to access the Oracle stored
procedures ,
> everything works fine. But I want to use RPCFUNC.
>
> Any suggestions ?
>
> Jan
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE
COMMANDS, ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
