Technical Support Forum Index
Technical Support Forum
Access ChemAxon scientists and developers here. For confidential or other support please email.		 The time now is Sat Jul 04, 2009 11:43 pm
 <b>Register</b> (required to post and download)Register (required to post and download)
 Username:    Password:   Remember login       
 FAQFAQ   SearchSearch   DigestsDigests 
JC_INSERT issue with "ORA-00903: invalid table name&quo
To watch this topic for replies  Register (enables digests) or give email address:
Reply to topic    Home -> Forums -> Support -> Storage & search: JChem Base /Cartridge -> JC_INSERT issue with "ORA-00903: invalid table name&quo

Display posts from previous:        View previous topic :: View next topic    
Author Message
ftm
Joined: 17 Jan 2007
Posts: 61


View user's profile

Visit poster's website
Back to top
Post subject: JC_INSERT issue with "ORA-00903: invalid table name&quo
Link to postPosted: Wed Apr 30, 2008 9:59 am  Reply with quote
I am attempting to insert structures into my JChem structures table. I have a PL/SQL procedure that includes a call to the JC_INSERT function but it is giving me the error message below:

Code:
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
oracle.jdbc.driver.OracleSQLException: ORA-00903: invalid table name
ORA-06512: at "JCHEM.JCHEM_TABLE_PKG", line 30
ORA-06512: at "JCHEM.JCHEM_TABLE_PKG", line 19
ORA-06512: at "JCHEM.SID", line 561
ORA-06512: at "JCHEM.SID", line 766
ORA-06512: at line 1


The line giving the error is:

Code:
aCDReturn := jchem_table_pkg.jc_insert(vSmiles, 'compounds', null, 'false', 'false', '');
iCDNum := aCDReturn(1);


The COMPOUNDS table does exist and the PL/SQL is called from within the same schema. Any ideas where I might be going wrong here?
pkovacs
Joined: 23 Jul 2004
Posts: 1038
ChemAxon personnel

View user's profile

Visit poster's website
Back to top
Post subject:
Link to postPosted: Wed Apr 30, 2008 1:51 pm  Reply with quote
Which JChem version are you using?

The corresponding Java stack trace from Oracle session trace (in the udump directory) would be also helpful.

Thanks
Peter
ftm
Joined: 17 Jan 2007
Posts: 61


View user's profile

Visit poster's website
Back to top
Post subject:
Link to postPosted: Wed Apr 30, 2008 1:59 pm  Reply with quote
It's JChem v5.0.2

 Filename: sidtest_ora_3160.trc    Filesize: 8.3 KB    Downloaded: 270 Time(s)
 Description:  I hope this is the trace that you need.
pkovacs
Joined: 23 Jul 2004
Posts: 1038
ChemAxon personnel

View user's profile

Visit poster's website
Back to top
Post subject:
Link to postPosted: Wed Apr 30, 2008 2:32 pm  Reply with quote
This is a bug in JChem Cartridge which will be fixed in the next JChem release. In the meantime, I suggest to explicitely specify the name of the JChemProperties table (third parameter to jc_insert).

Thank you for reporting this problem and sorry for the inconvenience.

Thanks
Peter
pkovacs
Joined: 23 Jul 2004
Posts: 1038
ChemAxon personnel

View user's profile

Visit poster's website
Back to top
Post subject:
Link to postPosted: Sun May 25, 2008 6:30 pm  Reply with quote
JChem 5.0.4 has been released including the fix for this problem.

Thanks
Peter
Display posts from previous:   
Reply to topic    Home -> Forums -> Storage & search: JChem Base /Cartridge -> JC_INSERT issue with "ORA-00903: invalid table name&quo All times are GMT + 1 Hour
Page 1 of 1
To watch this topic for replies   Register (enables digests) or give email address  
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum