CREATE TABLE stockphotos (
photo_id NUMBER,
photographer VARCHAR2(64),
annotation VARCHAR2(255),
photo ORDSYS.ORDImage,
photo_sig ORDSYS.ORDImageSignature);
DECLARE
Image ORDSYS.ORDImage;
ctx RAW(4000) := NULL;
BEGIN
INSERT INTO stockphotos VALUES (
1,'John Doe', 'red plaid',
ORDSYS.ORDImage.init(),
ORDSYS.ORDImageSignature.init());
SELECT photo INTO Image FROM stockphotos
WHERE photo_id = 1 for UPDATE; Image.setSource('file','ORDIMGDIR','redplaid.gif'); Image.import(ctx); //屏蔽掉这一句后可运行,可是图像实际没有存进去 UPDATE stockphotos SET photo = Image WHERE photo_id = 1;
COMMIT;
-- Continue processing
END;
错误:
ERROR 位于第 1 行:
ORA-29400: 数据插件错误IMG-00002: 无法恢复的错误
ORA-06512: 在"ORDSYS.ORDIMG_PKG", line 590
ORA-06512: 在"ORDSYS.ORDIMAGE", line 65
ORA-06512: 在"ORDSYS.ORDIMG_PKG", line 677
ORA-06512: 在"ORDSYS.ORDIMAGE", line 213
ORA-06512: 在line 9请各位高手指点,谢谢!!
photo_id NUMBER,
photographer VARCHAR2(64),
annotation VARCHAR2(255),
photo ORDSYS.ORDImage,
photo_sig ORDSYS.ORDImageSignature);
DECLARE
Image ORDSYS.ORDImage;
ctx RAW(4000) := NULL;
BEGIN
INSERT INTO stockphotos VALUES (
1,'John Doe', 'red plaid',
ORDSYS.ORDImage.init(),
ORDSYS.ORDImageSignature.init());
SELECT photo INTO Image FROM stockphotos
WHERE photo_id = 1 for UPDATE; Image.setSource('file','ORDIMGDIR','redplaid.gif'); Image.import(ctx); //屏蔽掉这一句后可运行,可是图像实际没有存进去 UPDATE stockphotos SET photo = Image WHERE photo_id = 1;
COMMIT;
-- Continue processing
END;
错误:
ERROR 位于第 1 行:
ORA-29400: 数据插件错误IMG-00002: 无法恢复的错误
ORA-06512: 在"ORDSYS.ORDIMG_PKG", line 590
ORA-06512: 在"ORDSYS.ORDIMAGE", line 65
ORA-06512: 在"ORDSYS.ORDIMG_PKG", line 677
ORA-06512: 在"ORDSYS.ORDIMAGE", line 213
ORA-06512: 在line 9请各位高手指点,谢谢!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货