Cartridge and Variable Syntax

User e4183f4538

14-07-2011 05:23:52

Hi!


This may be outside the scope of support, and if so, my apologies!


I'm trying to pass variables into Cartridge calls, and am having a bit of a time doing so (granted, it may also be my SQL syntax).


I have two tables:


INVEST, which has SMILES, PLATE, and FOUND (varchar2)


PLATES, which has SMILES, and PLATE_ID


Essentially, I am trying to run a jc_compare in order to determine which PLATE_ID in the table PLATES matches with the SMILES from INVEST, based on the smiles.


This requires I pass in variables to both the query and the target for jc_compare, but I'm getting an invalid identifier. My current attempt is:


UPDATE (select invest.FOUND, invest.SMILES, plate.SMILES, plate.PLATE_ID
from PLATES plate,
INVEST invest
WHERE jc_compare("plate.SMILES", "invest.SMILES", 't:t simThreshold:1.0')=1)
set invest.FOUND=plate.PLATE_ID;
ORA-00904: "invest.SMILES": invalid identifier

 



I *think* that invest.SMILES is a valid identifier (as the table and column do exist) - any ideas?

 

ChemAxon aa7c50abf8

14-07-2011 09:03:30

Hi,


What happens if you remove the double quotes from the statement?

User e4183f4538

14-07-2011 15:23:46

Peter,


That seems to fix the issues with the jc_compare, but now I'm getting invalide identifiers in the non-Cartridge areas - I'm back to straight up Oracle syntax issues. I'll pursue those elsewhere.


Thanks for your help!


 


Erin