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]
