Re: Cascade Update

BNFL BNFL <ap05_at_dial.pipex.com> wrote in article <33B0E825.5BEF_at_dial.pipex.com>...
> We're converting several Microsoft Access databases to work with Oracle
> V7.3 tables. We are keeping the Access forms etc and using ODBC to
> connect to the Oracle tables. MS Access referential integrity provides
> cascade update and cascade delete, but Oracle only provides cascade
> delete.
>
> How can we apply cascade update to the referential integrity on the
> Oracle tables?
>
> Bryn Charlton
> British Nuclear Fuels plc
>

you can simulate it through the use of triggers and pl/sql packages. Oracle Govt web site (www.govt.oracle.com?) has examples of how to do this--look for cascade.tar.

I cant say that I have ever used it. Whenever I needed a cascade delete, I wrote a package to do exactrly what I wanted.

-- 
Miles Thomas
Logica UK Ltd
thomasm "at" logica "dot" com
The above are personal opinions, and are
not necessarily the opinions of my employer.