我在往库里导入图象文件时,它总是提示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;
/
|