Re: updatable view question

From: Cantonese Boy <waynewan_at_yahoo.com>
Date: Sun, 28 Oct 2001 23:58:27 +0800
Message-ID: <3BDC2B23.7E6C8204@yahoo.com>

Hi,

> It is not. You are mixing up pl/sql and sqlserver code.
Are you saying that the code "create trigger ..." is a sqlserver code? But I copy it from the oracle doc "oracle8 concept chapter 18".... just can't believe it's not excecutable.

Thanks

> You still would need to use
> begin
> <some boolean> := true;
> select <key column>
> into ...
> from <table>
> where key_column = :new...
> exception
> when no_data_found then
> <some_boolean> := false;
> end;
>
> Hth,
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Sun Oct 28 2001 - 09:58:27 CST