I have problems with configuring oracle database gateway for drda
One of the steps in this process is (according to the manuel) is:

- GRANT EXECUTE ON PACKAGE oraclegtw.* TO PUBLIC

If I execute this statement I receive the following error:

- An unexpected token "*" was found following "N PACKAGE
oraclegtw.".
Expected tokens may include: "<identifier>".. SQLCODE=-104,
SQLSTATE=42601, DRIVER=3.61.65

Can somebody help me with this problem

On Fri, 04 Nov 2011 13:30:09 -0700, mar.houweninge (AT) wxs (DOT) nl wrote:

The Oracle syntax is: GRANT EXECUTE ON oraclegtw TO PUBLIC;
Serge Rielau maybe able to help with the DB2 side. BTW, who's Manuel?




--
http://mgogala.byethost5.com

Mladen Gogala <gogala.mladen (AT) gmail (DOT) com> wrote in
newsan.2011.11.04.21.20.14 (AT) gmail (DOT) com:

The grant is not performed on Oracle but on DB2.

The OP should mention platform (LUW, z/OS, AS400) and version of DB2 first,
as syntax for the GRANT differs. As an example, here is the syntax for v9
on z/OS:

http://publib.boulder.ibm.com/infoce...ex.jsp?topic=%
2Fcom.ibm.db2z9.doc.sqlref%2Fsrc%2Ftpc%
2Fdb2z_sql_grantpackageprivileges.htm

And the syntax for v9.5 for LUW:

http://publib.boulder.ibm.com/infoce...ex.jsp?topic=%
2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0007699.htm l

As an alternative to executing the grant remotely via the Oracle Gateway
interface, the OP could ask his DB2 DBA to execute it directly on the DB2
side.

He's from Barcelona!

http://en.wikipedia.org/wiki/Manuel_%28Fawlty_Towers%29

http://www.youtube.com/watch?v=pOEbCQIfndc

HTH

--
Jeroen

On Sat, 05 Nov 2011 21:35:50 +0000, TheBoss wrote:

If so, why is the question on the Oracle group?



--
http://mgogala.byethost5.com

Mladen Gogala <gogala.mladen (AT) gmail (DOT) com> wrote in
newsan.2011.11.05.21.37.59 (AT) gmail (DOT) com:

Well, I'm not the one posing the question, but I think because the gateway
software is an Oracle product and the OP didn't realise that part of the
products configuration (more specifically: binding and authorising packages
and plans that the gateway uses to access DB2) is performed on DB2.
In the mean time the OP has (may be because of my previous answer) posted
the question in the DB2 group, with the additional info that (like I
suspected) he is configuring for DB2 for LUW, which doesn't allow a generic
grant on all packages for a certain schema (via <schema>.*), where DB2 for
z/OS does allow such a generic grant.
This also means the doco for the gateway is incorrect/incomplete.
The OP needs to find out what packages are used in the oracletgw schema.
As this info is not available in the doco, his best bet would be to query
the DB2 catalog for this.

Cheers!

--
Jeroen

TheBoss <TheBoss (AT) invalid (DOT) nl> wrote in
news:Xns9F95F14C7F5BATheBossUsenet (AT) 194 (DOT) 109.133.133:

I did some more analysis of the gateway doc, and it's a little more
complicated than I thought.
The part of the gateway configuration that the OP is referring to is
documented here:
http://download.oracle.com/docs/cd/E11882_
01/gateways.112/e12013/configdrda_server.htm#OTGIS1073

In DB2 it is possible to grant privileges on objects that are not existing
(yet), and that's the case here: privileges are granted for the oraclegtw
packages during configuration, while these packages are created/bound
during the first gateway usage. So my previous advice to query the DB2
catalog won't help here.
Fortunately the docs also offers an alternative way in the next section
13.4 "Manually Binding of DRDAQ Gateway Packages".
More specifically, paragraph 13.4.2 gives the exact procedure to follow for
DB2 LUW.

Cheers!

--
Jeroen