Hello
I need help on this.
We have a Oracle 7.3.4 database and Oracle 8.1.6 database
The application is as follows
package in Oracle 8.1.6 calls package in Oracle 7.3.4
using Database link
Package in Oracle 7.3.4 does a lot of processing
but now
sometimes Oracle 7.3.4 package gives distributed lock timeout error
and sometimes Oracle 8.1.6 packages gives this error.
This has made us wonder
'what is happeneing'!
Can someone help me with
a. understaning this phenomenon
b. in oracle 8.1.6 the parameter distributed_lock_timeout
is obsolete
and the users want to run this package
is there someway of 'running' this
c. Is this type of processing
ie calling package executing a lot of statements
called package also executing a lot of statements
and the final commit being back in the
calling package the 'suggested' (recommended)
way?
isn't there a better way of doing this?
Thanks
_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril Thankappan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
