Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PLEASE HELP !!! Getting error ORA-02438 and ORA-00910

339339Aug 8 2003 — edited Aug 8 2003
Hi,

I am trying to create a table, have a field "Financial_Aid_Requested" declared as CHAR() and has a check constraint on it, when I try to run it, it gives me error "ORA-00910: specified length too long for its datatype" and so when I try to change the datatype to VARCHAR2 or even CHAR(2000), or CHAR(2) it gives me error "ORA-02438: Column check constraint cannot reference other columns"

PLEASE HELP, I AM STUCK WITH THIS THING !!

Below is What I have written as a part of query :

Financial_Aid_Requested CHAR() NULL
CONSTRAINT CK3APPLICATION_INFO
CHECK (Financial_Aid_Requested IN (Y,N))


Thank you in advance.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 5 2003
Added on Aug 8 2003
#general-database-discussions
2 comments
432 views