Jump to content


Luke

Member Since 04 Jan 2006
Offline Last Active Mar 14 2006 01:04 PM
-----

Posts I've Made

In Topic: core dump with external record format files

14 March 2006 - 01:05 PM

Joseph

cheers for the reply, I'm going to take the clear flag out of the function to see if that helps at all.

In Topic: core dump with external record format files

13 March 2006 - 12:39 PM

Thanks for the reply Lew. Yeah, currently the 1st update reads all the files with clearflag = 'Y' - which incidentally still seems to be working, it's not until we try come write to the file in a later function that we get a problem. Have tried manually deleting and recreating the file with chmod 777 before starting the process, but got the same problem.

I could understand the problem if it was something that wasn't working previously, but it's worked fine like this for years. I may try simply deleting the file manually and allowing the process to recreate it, to see if this makes any difference.

just about driving me potty this one :mad:

In Topic: Simultaneous transactions

04 January 2006 - 02:42 PM

sorry, I should say

SQL
select seq_name.nextval
into :#variable
from dual
ENDSQL