Executing an oracle statement from mainframe using access manager [message #111665] |
Fri, 18 March 2005 08:59 |
mandycool
Messages: 5 Registered: February 2005
|
Junior Member |
|
|
Hi,
I am using the tool Access manager for CICS to conect from mainframes to Oracle database and extract data.
The problem I am facing right now is the mainframe program is connected to Oracle database, but none of the Oracle statements can be executed.Not even select user from dual works.
But Oracle log says that I am connected to the machine.
Please advise.
Thanks & Regards,
Mandar.
|
|
|
|
|
Re: Executing an oracle statement from mainframe using access manager [message #112685 is a reply to message #112647] |
Mon, 28 March 2005 13:48 |
Michael Hartley
Messages: 110 Registered: December 2004 Location: West Yorkshire, United Ki...
|
Senior Member |
|
|
Ok,
have you confirmed the statements are not executing against the databases? eg. Have you bounced the database to clear the v$sqlarea, connected from the mainframe, executed a number of simple queries, then examined v$sqlarea to confirm they have been parsed and executed?
Are you getting any error messages?
Michael Hartley
|
|
|