ORA-01743: only pure functions can be indexed Cause: The indexed function uses SYSDATE or the user environment. Action: PL/SQL functions must be pure (RNDS, RNPS, WNDS, WNPS). SQL
expressions must not use SYSDATE, USER, USERENV(), or anything else
dependent on the session state. NLS-dependent functions are OK.
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 2016-7-18 15:15:18
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对