calling jc_compare inside a SQL procedure

Hi , i am using jc_compare in a cursor as following, i keep getting an Oracle error

PL/SQL: ORA-00942: table or view does not exist.

however all the tables, columns do exist. How do i get around the problem?

Thanks

Dong

CREATE OR REPLACE PROCEDURE insertD2SMol IS
cursor cur_mol (v_smiles varchar2) is
select * from molecules
where jc_compare(molecule,v_smiles,'t:ef')=1;
BEGIN
   dbms_output.put_line('hello');
END insertD2SMol;
/

Hi Dong,

If the same structure search query works outside the stored procedure (as a top-level SQL call), the solution is to grant the JCC/Oracle user privileges on the JChem objects schema directly (as opposed to their being granted through a role). Executing the following command in the jchem/cartridge directory will guide you through the (not so complex) process of doing the required grants:

config-util list-sqls-for-jcc-user-privs

Peter

this is mighty annoying !!!! the grants are done by DBA ... you thought everything is set and ready to go but ...

Let me know if directly granting privileges doesn't solve the issue.

Peter