Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3895233
  • 博文数量: 534
  • 博客积分: 10470
  • 博客等级: 上将
  • 技术积分: 4800
  • 用 户 组: 普通用户
  • 注册时间: 2006-05-26 14:08
文章分类

全部博文(534)

文章存档

2021年(1)

2019年(1)

2017年(1)

2016年(2)

2013年(2)

2012年(10)

2011年(43)

2010年(10)

2009年(17)

2008年(121)

2007年(253)

2006年(73)

分类: Oracle

2006-12-29 15:01:38

ORA-01405:fetched column value is NULL

Cause:The INTO clause of a FETCH operation contained a NULL value, and no indicator was used. The column buffer in the program remained unchanged, and the cursor return code was +2. This is an error unless you are running Oracle with DBMS=6, emulating version 6, in which case it is only a warning.
Action:You may do any of the following:
  • Use the NVL function to convert the retrieved NULL to another value, such as zero or blank. This is the simplest solution.
  • Use an indicator to record the presence of the NULL. You probably should use this option when you want a specific action to be taken when a NULL arises.
  • Revise the cursor definition so that no columns possibly containing NULL values are retrieved.
阅读(3476) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~