Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating Error Log table
<jthlcf_at_gmail.com> a écrit dans le message de news: 1148098569.277760.37340_at_38g2000cwa.googlegroups.com...
| Hi guys I am new to PL/SQL and trying to create an error event table
| that logs errors, naturally. I was wondering if you can help a newb to
| , yes LOL create TABLE like this. The difficulty that i have is in the
| following code that i use in ISQL
|
| CREATE TABLE EVENT_ERROR(
| row_id ROWID,
| table_name VARCHAR2(20),
| filter_id NUMBER,
| date_time DATE,
| action NUMBER(1) CHECK (action IN (2,3,4))
|
| I get the following error:
|
| action NUMBER(1) CHECK (action IN (2,3,4))
| *
|
| ERROR at line 6:
| ORA-00907: missing right parenthesis
|
|
| Anyone able to point me to wats wrong? Thanks heaps
|
You missed one right parenthesis (at the end).
Regards
Michel Cadot
Received on Sat May 20 2006 - 01:00:52 CDT