Environment
Novell ZENworks 7.5 Asset Management - ZAM7.5
Situation
Error: "java.sql.SQLException: ORA-00911:
invalid character" deleting Software Collection with JDBC
Oracle driver
Resolution
If downloading the Interim Release manually fromhttps://download.novell.com, select ZENworks Asset Management from the product drop down field, and then hit search and go to the Patches tab. The Interim releases can also be set up within the ZAM Manager for the Task server to check the site on a scheduled basis, and download and apply them automatically. Please refer to the Help Section for details of how to set up automatic downloads if desired.
Each interim
release is cumulative. If Interim Release 5 is not available due to
a newer interim release being placed on the website, be assured
that the code needed is in the later release.
Additional Information
The cause is a
semi-colon at the end of the SQL statement that the JDBC driver
doesn't handle.