db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: How to extend this system procedure?
Date Fri, 01 Apr 2011 14:29:07 GMT
Hi Clark,

It would help if you could give us more information about the problem 
you are seeing:

1) What are your table definitions, including primary/unique and foreign 
keys.

2) What is the sequence of statements which results in the failure you 
are seeing.

Thanks,
-Rick

On 4/1/11 6:17 AM, 鲍少明 wrote:
> Hi Group,
> I use this procedure SYSCS_UTIL.SYSCS_IMPORT_TABLE to import data from 
> csv. But there is another table depend on the table I need to import 
> into. Then I cannot use the mode 1. It will throw an error to tell me 
> I cannot delete the data in this table, because there is a FK point to it.
> Can anyone provide an extension of this procedure to support this. 
> Since the FK I define is delete cascade. I am thinking why the 
> procedure will not cascade delete the data. So what I did is to call 
> delete all before this import. But it's not an optimized method of 
> delta importing.
> Anyone can help it? I want it to support cascade delete and still 
> using delta update mode. So as to reach best performance.
> Thanks,
> Clark


Mime
View raw message