Oracle Intermedia / Image Import

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • lars-jacob hove

    Oracle Intermedia / Image Import

    Hello.

    I'm having trouble importing images. I have the following procedure :

    declare
    Image ORDSYS.ORDImage ;
    ctx RAW(4000) := null;

    begin
    insert into bilde_test values (
    4, null, ORDSYS.ORDImage .init(), ORDSYS.ORDImage Signature.init( ));

    SELECT PHOTO into Image FROM bilde_test WHERE photo_id = 4 for update;

    Image.SetSource ('file', 'LARSDIR', 'logo_phpBB.gif ');
    Image.importFro m(ctx, 'file', 'LARSDIR', 'logo_phpBB.gif ');

    UPDATE bilde_test SET photov = Image where photo_id = 4;
    commit;
    End;

    When I try to execute the procedure, I get the following error report.
    (It's in Norwegian, so I've tried to translate the norwegian text) :

    declare
    *
    ERROR on linj 1:
    ORA-06510: PL/SQL: untreated useddefined exception
    ORA-06512: at "ORDSYS.ORDSOUR CE", line 266
    ORA-22288: file- or LOB-operation FILEOPEN failed
    The data is invalid.
    ORA-06512: at "ORDSYS.ORDIMG_ PKG", line 701
    ORA-06512: at "ORDSYS.ORDIMAG E", line 223
    ORA-06512: at line 12

    ---
    I've tried several other procedures, with the same result. Seems like
    the trouble occurs around the "import" statement.

Working...