Question about jc_delete

Hi.


Must I use jc_delete to delete a row from the structure table created by jcman, or can I just use sql (ie delete from table where cd_id=1) ?





Regards,


Mikael

Hi,





You must use jc_delete with structure tables created by jcman.





Peter

Hi.


JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production


PL/SQL Release 9.2.0.6.0 - Production


CORE 9.2.0.6.0 Production


TNS for Solaris: Version 9.2.0.6.0 - Production


NLSRTL Version 9.2.0.6.0 - Production


NLSRTL Version 9.2.0.6.0 - Production


JChem version in the database: 3.1.4


JChem version in the Tomcat server: 3.1.4


java.vm.version: 1.4.2_10-b03


java.vm.vendor: Sun Microsystems Inc.


Apache Tomcat/5.5.12





JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Major JDBC version in Tomcat: 1


Minor JDBC version in Tomcat: 0








My cartridge is installed in schema jchem.


My structure and index tables are in schema chemspec_test.


Chemspec_test also has its own jchemproperties table.


My table is called jcbvtmol_moltable.





If I execute call jc_delete('chemspec_test.jcbvtmol_moltable','where regno = ''341422''') in chemspec_test schema it works.


But if I execute it in my schema (SE18693)


I get the following error.





ORA-29532: Java call terminated by uncaught Java exception: oracle.jdbc.driver.OracleSQLException: ORA-00942: table or view does not exist


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 0


ORA-06512: at "JCHEM.JC_DELETE", line 4


ORA-06512: at line 1








The catalina.out shows no errors.





I granted full privs on the following tables in


chemspec_test to SE18693.


jcbvtmol_moltable


jcbvtmol_moltable_ul


jchemproperties


jc_idx_property


jc_idx_udop





I also granted select on the following sequences to SE18693


jcbvtmol_moltable_sq


jcbvtmol_moltable_usq


jchemidx_seq





Can you please tell me what I am missing.


Regards,


/Mikael

Hi Mikael,





Specify the jchemproperties table like:

Code:

call jc_delete('chemspec_test.jcbvtmol_moltable','where regno = ''341422''', 'chemspec_test.jchemproperties')

This applies to jc_insert(b) and jc_update(b) as well.





Regards,


Peter