目前我正在用oracle intermedia,oracle是8.1.7.4
建了一张表,字段只有两个,一个是id number
一个是sndoradsys.audio的。目前可以把音频文件
从硬盘导入库中,但是从库中导出音频文件到硬盘
的时候,就不行。
##############我的导出脚本########
declare
obj ORDSYS.ORDAudio;
ctx RAW(4000) :=NULL;
begin
select snd into obj from sounds where id=1;
--- we export the sound into the table using a buffer (ctx).
if (obj.isLocal) then
obj.export(ctx, 'FILE', 'MYDIR', 'weiyi.mp3');
dbms_output.put_line('sound '||1||' exported');
else
dbms_output.put_line('sound cannot be exported since not stored locally in the database');
end if;
exception
when ORDSYS.ORDSourceExceptions.INCOMPLETE_SOURCE_INFORMATION then
DBMS_OUTPUT.PUT_LINE('Export: value of srcType is NULL');
when ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED then
DBMS_OUTPUT.PUT_LINE('Export: method not supported');
-- to see the complete errormessage for the source plugin exception,
-- you might remove the following exception handling for the source_plugin_exception
--when ORDSYS.ORDSOURCEExceptions.SOURCE_PLUGIN_EXCEPTION then
--DBMS_OUTPUT.PUT_LINE('Export: source plugin exception caught');
when ORDSYS.ORDSourceExceptions.IO_ERROR then
DBMS_OUTPUT.PUT_LINE('Export: problems writing BLOB data to the file specified');
when no_data_found then
dbms_output.put_line('no sound exist for number : '||1);
end;
######################
导出前的情况是,表中有一行数据,id为1,现想export到硬盘。
运行后报错信息是:
#######################
DECLARE
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORDSYS.ORDSOURCE", line 354
ORA-29540: class oracle/ord/media/source/OrdSourceSvr does not exist
ORA-06512: at "ORDSYS.ORDAUDIO", line 558
ORA-06512: at line 8
#########################
他说我缺少一个类,这是怎么回事呢?不要告诉我重装
intermedia,这个库是我已经专门重装了的。
|