我的存储过程现在是这样如下：
(
plateid in Varchar2,
platecolor in Varchar2,
platetype in Varchar2,
crossingtime in Date,
crossingname in Varchar2,
aspectname in Varchar2,
wayname in Varchar2,
speed in Varchar2,
illegaltype in Number,
blackstate in Number,
filepath1 in Varchar2,
filepath2 in Varchar2,
filepath3 in Varchar2,
filepath4 in Varchar2,
result_blackstate out Number,
result_plateid out Varchar
)
as
v_count number;
begin
select count(*) into v_count from tb_plate where plateid=plateid ;
if v_count>0
then
result_plateid:=plateid;
else
insert into sysadmin.tb_plate(ID,plateid,platecolor,platetype) values(plate_id.nextval,plateid,platecolor,platetype);
end if;
if illegaltype>1 and blackstate!=3
then
insert into sysadmin.tb_illegalcar(
id,
plateid,
crossingtime,
crossingname,
aspectname,
wayname,
speed,
illegaltype,
blackstate,
filepath1,
filepath2,
filepath3,
filepath4)
values(
ILLEGALCAR_ID.nextval,
plateid,
to_date(crossingtime,'YYYY-MM-DD HH24:MI:SS'),
crossingname ,
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
查了一天的blob，还是没理解到，我想在VC下存取二进制的文件，使用的是oo4o，照着帮助文档上面的写了写入数据库的代码，还是没写对，错误提示是this operation is not permitted on a empty LOB，这是什么意思啊？照 ......
