Hi,
The below INSERT throws a Invalid character (ORA-00911) error when
done thru jdbc.
INSERT INTO E(expid,callattr,operator,callaval,ruleid)
VALUES(8,'CallType','=','Voice',20).
The same when done directly at the SQL prompt works !
Anyone got ideas ?
The schema is
CREATE TABLE Expression (
ExpId INTEGER PRIMARY KEY,
Operator VARCHAR(5) CHECK (Operator IN ('=','<','>','<=','>=','<>')),
CallAttrValue VARCHAR(64),
CallAttr VARCHAR(32) CHECK (CallAttr IN
('CallType','StartTime','EndTime','Bandwidth','SrcIpAddr','DestnIpAddr','SrcPhoneNum','DestnPhoneNum')),
RuleId INTEGER REFERENCES Rule(RuleId) ON DELETE CASCADE
);
Lionel - 18 Nov 2004 15:11 GMT
> Hi,
> The below INSERT throws a Invalid character (ORA-00911) error when
[quoted text clipped - 3 lines]
>
> The same when done directly at the SQL prompt works !
The callaval column does not exist.
If I replace it with CallAttrValue, it works fine through jdbc.
> Anyone got ideas ?
> The schema is
[quoted text clipped - 3 lines]
> CallAttrValue VARCHAR(64),
> CallAttr VARCHAR(32) CHECK (CallAttr IN
('CallType','StartTime','EndTime','Bandwidth','SrcIpAddr','DestnIpAddr','Src
PhoneNum','DestnPhoneNum')),
> RuleId INTEGER REFERENCES Rule(RuleId) ON DELETE CASCADE
> );