Re: update a vie

On Thu, 10 Oct 2002 11:33:45 +0800, "iim" <lianghs_at_163.net> wrote:

>sorry
>
>my view is
>
>CREATE FORCE VIEW
> users ( id, name, password, group_id )
>AS
> SELECT
> student_no,
> student_name,
> password,
> group_id
> FROM
> student
> UNION
> SELECT
> teacher_no,
> teacher_name,
> password,
> group_id
> FROM
> TEACHER
>;
>
>
>"iim" <lianghs_at_163.net> 写入消息新闻:ao2s5k$2k4i$1_at_mail.cn99.com...
>> When i update data from a view, i got the following error. how can i
>correct
>> it ?
>>
>> 01732, 00000, "data manipulation operation not legal on this view"
>> // *Cause:
>> // *Action:
>> /export/home/
>>
>>
>>
>

The documentation would have told you UNION views are not updatable (which is logical, as Oracle can't decide from which table a record comes)
If you are running 8i or higher (you don't mention a version) you can try instead of triggers. Please consult your documentation for further details.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Oct 09 2002 - 23:41:31 CDT