User d8da4712c1
27-05-2013 12:17:23
Hello,
I'm using jc_insert like this (1), and getting this error (2) but don't understand why!
(1)
$stmt = OCIParse($link,"
declare
cd_id cd_id_array;
begin
cd_id := jchem_table_pkg.jc_insert(:molfile1, :table, :jc_prop, 'true', 'false', ''); end;");
$jc_table='sub_structure';
$jc_prop='jchemproprities';
$blob2=OCINewDescriptor($link, OCI_D_LOB);
OCIBindByName($stmt, ':molfile1', $blob2, -1, OCI_B_BLOB);
$blob2->writetemporary($molfile1, OCI_TEMP_BLOB);
//OCIBindByName($stmt,":slot_labo_id_lotlabo_id",$slot_labo_id_lotlabo_id,-1);
OCIBindByName($stmt,":table",$jc_table,-1);
OCIBindByName($stmt,":jc_prop",$jc_prop,-1);
ociexecute($stmt);
ocicommit($link);
$Blob2->close();
$Blob2->free();
OCIFreeStatement($stmt);
(2):
Warning: ociexecute(): ORA-29532: appel Java arrete par une exception Java non interceptee : oracle.jdbc.driver.OracleSQLException: ORA-00942: Table ou vue inexistante
ORA-06512: a "KIET.JCHEM_TABLE_PKG", ligne 45
ORA-06512: a "KIET.JCHEM_TABLE_PKG", ligne 50