Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / November 2004

Tip: Looking for answers? Try searching our database.

ORA-00911 error on insert

Thread view: 
shankar - 18 Nov 2004 13:23 GMT
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
> );


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.