Home » Developer & Programmer » Reports & Discoverer » locking database while report is running
locking database while report is running [message #88377] Tue, 23 July 2002 23:18 Go to next message
candy cane
Messages: 1
Registered: July 2002
Junior Member
is there a way for us to prevent updates on the database when a report is run until the preview/printout of the report is generated? this would be to prevent any inconsistency on the data displayed in the report.... thanks! =)

Report message to a moderator

Re: locking database while report is running [message #88381 is a reply to message #88377] Thu, 25 July 2002 05:37 Go to previous message
Geoffrey
Messages: 32
Registered: February 2002
Member
if you are using oracle you don't need to lock the database, oracle is read consitend.

but if you realy want to lock the database you can do it like this :

select
....
from
....
where
...
for update

Report message to a moderator

Previous Topic: Reinstalling ORACLE 9i AS
Next Topic: Re: Problem with Report 6i during Printing i.e. in Compression
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 19:32:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.