Oracle multimedia组件问题

[复制链接]
查看11 | 回复0 | 2003-8-4 16:50:00 | 显示全部楼层 |阅读模式
我在往库里导入图象文件时,它总是提示RPC错误,请问哪位大拿知道怎么解决?
ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "ORDSYS.ORDIMG_PKG", line 419
ORA-06512: at "ORDSYS.ORDIMAGE", line 65
ORA-06512: at line 13

我的导入图象的脚本如下:
CREATE TABLE emp (
ename VARCHAR2(50),
salary NUMBER,
job VARCHAR2(50),
department INTEGER,
photo ORDSYS.ORDImage,
large_photo ORDSYS.ORDImage);
DECLARE
Image ORDSYS.ORDImage;
BEGIN
INSERT INTO emp VALUES ('John Doe', 24000, 'Technical Writer', 123,
ORDSYS.ORDImage(ORDSYS.ORDSource(empty_blob(),'file','IMGDIR',
'title2.jpg',SYSDATE,0),
NULL,NULL,NULL,NULL,NULL,NULL,NULL),
ORDSYS.ORDImage(ORDSYS.ORDSource(empty_blob(),'file','IMGDIR',
'title.bmp',SYSDATE,0),
NULL,NULL,NULL,NULL,NULL,NULL,NULL));
SELECT large_photo INTO Image FROM emp
WHERE ename = 'John Doe' FOR UPDATE;
Image.setProperties;
UPDATE emp SET large_photo = Image WHERE ename = 'John Doe';
COMMIT;
END;
/
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行