Solved by adding: "dokument.import(ctx,false);" But i have another problem while taking out some properties of file. I have precedure: CREATE OR REPLACE PROCEDURE wlasciwosci AS dokument ORDSYS.ORDDOC; ctx RAW(64) :=NULL; BEGIN SELECT przepis INTO dokument FROM przepisy WHERE prze_id = 1 FOR UPDATE; dokument.setProperties(ctx,TRUE); DBMS_OUTPUT.PUT_LINE('Format pliku: ' || dokument.getformat); DBMS_OUTPUT.PUT_LINE('Rozmiar dokumentu: ' || dokument.getContentlength); DBMS_OUTPUT.put_line('Typ Mime: ' || dokument.getMimeType); UPDATE przepisy SET przepis = dokument WHERE prze_id = 1; COMMIT; EXCEPTION WHEN ORDSYS.ORDDocExceptions.DOC_PLUGIN_EXCEPTION THEN DBMS_OUTPUT.put_line('DOC PLUGIN EXCEPTION caught'); WHEN OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; /
and it compiles without any error, but when i try to execute it: SET serveroutput ON; EXECUTE wlasciwosci; i receive exception: DOC PLUGIN EXCEPTION caught. File with id = 1, is a *.txt file, but when i change into a *.doc file which i also have inserted into database, i receive same exception, no matter if i change: "dokument.setProperties(ctx,TRUE);" on FALSE or not. -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en