I have a procedure in a package that access another package procedure in
a different schema. I do not want to have to put the schema name in
front of the
called package procedure to get it to compile. What grants will allow me
to do this...see below


Schema DDB
Code in package procedure DDbWebform.drawinlist that access
reportserver.pdf
htp.tabledata('<A
HREF="'||reportserver.pdf||'ddb_actdetail_rdf+P_DRAWING_NUMBER='||replac
e(c1.dwg_number, ' ', '+')||
'">'||c1.dwg_number||'</A>');


Reportserver.pdf resides in schema raicore

What grant will allow me not to have to specify the schema before the
procedure? I have tried to grant all on reportserver to ddb while in
raicore but I still need to put raicore in front of the procedure to get
it to compile.

Duane Dunn
206.655.5936 M/C 14-ME



Oracle LazyDBA home page