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