写入到blob字段的存储过程
-- Create tablecreate table JFORUM_POSTS_TEXT( POST_ID NUMBER(18) not null, POST_TEXT BLOB, POST_SUBJECT VARCHAR2(200), ISDELETED NUMBER(1) default 0)tablespace XZFY pctfree 10 initrans 1 maxtrans 255 storage ( initial 128 minextents 1 maxextents unlimited );-- Create/Recreate primary, unique and foreign key constraints alter table JFORUM_POSTS_TEXT add primary key (POST_ID) using index tablespace XZFY pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited );
