Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Miscellaneous > ORA-00911 error...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 9 Topic 6953 of 7280
Post > Topic >>

ORA-00911 error and COMMIT

by William Maslin <CATmaslin@[EMAIL PROTECTED] > Jun 16, 2008 at 11:13 AM

Hi,

I'm been playing with using Filemaker Pro to generate and send sql to an 
Oracle 10g database.  The following works fine:


UPDATE BEVIS_DL_TEST_RESULTS_ENTRY

SET BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_VALUE = 'A section of liver is 
examined microscopically. '

WHERE BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_NAME = 'HISTOPATHOLOGY' AND

BEVIS_DL_TEST_RESULTS_ENTRY.ACCESSION_ID = '30257' AND 

BEVIS_DL_TEST_RESULTS_ENTRY.TEST_CODE = '6005';



But when I add a COMMIT to the end I get an ORA-00911 error.



UPDATE BEVIS_DL_TEST_RESULTS_ENTRY

SET BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_VALUE = 'A section of liver is 
examined microscopically. '

WHERE BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_NAME = 'HISTOPATHOLOGY' AND

BEVIS_DL_TEST_RESULTS_ENTRY.ACCESSION_ID = '30257' AND

BEVIS_DL_TEST_RESULTS_ENTRY.TEST_CODE = '6005';

COMMIT;


These statements are generated in Filemaker "calculation" fields in 
which text and field values are concatenated to produce statements like 
those above.  Please understand admit that I'm a complete Oracle and SQL 
novice.  The little that I've learned has come from SQL Visual 
Quickstart Guide and from hacking queries that I've stolen from Crystal 
Re****ts.

Thanks!
 




 9 Posts in Topic:
ORA-00911 error and COMMIT
William Maslin <CATmas  2008-06-16 11:13:47 
Re: ORA-00911 error and COMMIT
Ken Denny <ken@[EMAIL   2008-06-16 11:47:30 
Re: ORA-00911 error and COMMIT
William Maslin <CATmas  2008-06-16 18:20:00 
Re: ORA-00911 error and COMMIT
"gym dot scuba dot k  2008-06-17 02:23:44 
Re: ORA-00911 error and COMMIT
William Maslin <CATmas  2008-06-17 11:06:13 
Re: ORA-00911 error and COMMIT
Ken Denny <ken@[EMAIL   2008-06-17 06:58:51 
Re: ORA-00911 error and COMMIT
William Maslin <CATmas  2008-06-17 10:51:02 
Re: ORA-00911 error and COMMIT
spambait@[EMAIL PROTECTED  2008-06-17 15:20:55 
Re: ORA-00911 error and COMMIT
William Maslin <CATmas  2008-06-17 11:08:27 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 0:10:02 CST 2008.