Re: designer webserver library (wsgl?) problems
Date: Mon, 9 Oct 2000 16:55:26 -0700
Message-ID: <8rtloq$e5g$1_at_redftp.redftp.attws.com>
[Quoted] I've checked - all the tables being accessed are already owned by bob. Therefore, I cannot grant bob access to his own stuff.
Also... what do you mean "invokers' stuff?" Invoker meaning schema/user who [Quoted] executed the procedure? (In my case, this would be bob)
Just to make sure I explained correctly - the bob schema has all the tables. The wsgl_public schema just has the wsgl packages such as wsgl, wsglm, and [Quoted] wsgjsl. Where it seems to be failing is in this code:
function QueryHits(
P_GLOS_CATEGORY1 in varchar2, P_GLOS_CATEGORY2 in varchar2, P_GLOS_CATEGORY3 in varchar2, P_GLOS_OWNER in varchar2) return number is begin if not BuildSQL(P_GLOS_CATEGORY1, P_GLOS_CATEGORY2, P_GLOS_CATEGORY3, P_GLOS_OWNER) then return -1; [Quoted] end if; return WSGL.CountHits(ZONE_SQL); exception when others then WSGL.DisplayMessage(WSGL.MESS_EXCEPTION, SQLERRM, ''||' : '||'', [Quoted] BODY_ATTRIBUTES, 'GLOSMAIN2$GLOSTRM.QueryHits'); return -1;
end;
We get that "-1" instead of an actual hit count.
Skimming through the code - all the tables are owned by bob, so it can't be a no SELECT priv issue, can it?
[Quoted] Sorry for throwing all that code at you. I'm just not good enough of a debugger to narrow it down further. Received on Tue Oct 10 2000 - 01:55:26 CEST