Archive for May, 2009

File locking…

Friday, May 29th, 2009

I am building a file upload package (or actually it has been built and I am expanding it). The file should be uploaded by a third party and when it’s done, then this code should kick off and upload the file to a clob for further processing.
The problem is that the third party can still [...]

Filed under: Oracle, PL/SQL | 3 Comments »

Semaphores (revisited)

Wednesday, May 6th, 2009

In a previous blog I talked about turning triggers on and off using semaphores. I created a semaphore for every table I needed along with its programs to set and unset the semaphore and to get its current state. This was a rather cumbersome process, because for every new trigger I needed to add these [...]

Filed under: Oracle, PL/SQL, Tools | No Comments »