User 247a2c5018
09-10-2013 16:42:56
Hello,
with this query, i search if my structure is already in the database :
$sqlstruid=OCIParse($link, "select stru_id, cd_id from sysadmin.sub_structure where jc_compare(cd_structure,:molfile1,'t:d')=1");
$blob_0=OCINewDescriptor($link, OCI_D_LOB);
OCIBindByName($sqlstruid, ':molfile1', $blob_0, -1, OCI_B_BLOB);
$blob_0->writetemporary($molfile1, OCI_TEMP_BLOB);
OCIExecute($sqlstruid);
ocifetchstatement($sqlstruid, $ligstruid, 0, 1,OCI_FETCHSTATEMENT_BY_ROW);
ocicommit($link);
$blob_0->close();
$blob_0->free();
OCIFreeStatement($sqlstruid);
I would like to know if my structure represented in the query by ":molfile1" is automatically standardized to compare with the cd_structure field?
When I create the structure table with JchemManager, I downloaded a custom xml file for standardization.