MQSeries.net :: View topic

SANTYP · Posted: Sun Jan 16, 2011 7:36 pm Post subject:

Hi all,
I think few of you guys already come across this problem,

Problem is I have a broker say BRK in AIX environment, which has a DSN called BRKDSN with username as "username" and password as "password".

I come across a situation where I need to access one table in same database(Oracle) with different schema, which has username as "username1" and password as "password1".

So I set the these credentails to BRKDSN using mqsichangeproperties command.

All are fine .. till the point..

In my one of my compute node I have statement like below...

INSERT INTO Database.ABAT_EXPORTER (FEED_CODE) VALUES ("feed_value");
note: I didn't used the statement inthe Passthru function.

this peace of code is working fine before I change the DSN properties...
but after changing the properties... it's throwed an exception..

"[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-04044: procedure, function, package, or type is not allowed here' (CHARACTER)"

after I changed the above code to
INSERT INTO BRKDSN.ABAT_EXPORTER (FEED_CODE) VALUES ("feed_value");

it is worked..

table ABAT_EXPORTER is in old schema only.. mean which has username as "username" and password as "password"..

Can any one tell me what could be reason for the failure...