文章存档
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2007-03-06 13:53:27
empty_blob and empty_clob return an empty lob locator that can be used to initialize a lob variable or, in an insert or update statement, to initialize a lob column or attribute to empty. empty means that the lob is initialized, but not populated with data.
update print_media set ad_photo = empty_blob();
oci operation lob column first use empty_blob, empty_clob initialize the lob column.
if not initialize the lob column get error ora-01405:fetched column value is null.
bfilename is initialize for bfile datatype.
update print_media set ad_photo = empty_blob();
oci operation lob column first use empty_blob, empty_clob initialize the lob column.
if not initialize the lob column get error ora-01405:fetched column value is null.
bfilename is initialize for bfile datatype.
给主人留下些什么吧！~~