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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
