Re: Deferred constraint question

That was my thought as well, but, although the statement parses and executes without error, the constraint remains in immediate mode.

Thank you for your response.

Jonathan Lewis wrote in message
<930130821.14033.1.nnrp-03.9e984b29_at_news.demon.co.uk>...
>There doesn't seem to be, even in 8.1.5.
>I would have expected to find it in dbms_transaction,
>but get grep'ed my way through everything in
>$ORACLE_HOME/rdbms/admin looking for it.
>
>An oversight to be raised with Oracle support
>perhaps. In the meantime I guess you'll have to
>write it using dbms_sql - somthing like:
>
> n := dbms_sql.open_cursor;
> dbms_sql.parse(
> c =>n,
> statement =>'set constraint ' || i_constraint || ' deferred' ,
> language_flag => dbms_sql.v7
> );
> v_junk := dbms_sql.execute (n);
>
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
Received on Wed Jun 23 1999 - 19:36:56 CDT