IFS or Crystal Report里的Oracle视图脚本文件写法注意

CREATE OR REPLACE VIEW &VIEW AS
SELECT session_id                     session_id,
       log_no                         log_no,
       pkg                            pkg,
       oper                           oper,
       flow                           flow,
       info                           info,

       HT_SESSION_API.Get_ip_addr(session_id) ip_addr,       
       &OBJID                         objid,
       &OBJVERSION                    objversion
FROM   ht_log_tab
WITH   read only;

>>此视图从ORACLE的语法角度并没有什么错误;
若要在IFS里做客户化或者在Crystal Report里作报表，通常会碰到此ip_addr栏位资料出不来或者找不到此ip_addr栏位;
但是：在PL/SQL里查看视图，数据正常

》》解决办法: 输出字符串指定长度

CREATE OR REPLACE VIEW &VIEW AS
SELECT session_id                     session_id,
       log_no                         log_no,
       pkg                            pkg,
       oper                           oper,
       flow                           flow,
       info                           info,

       substr(HT_SESSION_API.Get_ip_addr(session_id),1,50) ip_addr,      
       &OBJID                         objid,
       &OBJVERSION                    objversion
FROM   ht_log_tab
WITH   read only;