SQL & PL/SQL

Hi Masters,



I am getting error(String is too long for internal buffer) with returning caluse when I am returning timestamp,
It is working fine with seperate select statement. Please clarify it.

Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bi
PL/SQL Release 10.1.0.5.0 - Production
"CORE 10.1.0.5.0 Production"
TNS for HPUX: Version 10.1.0.5.0 - Production
NLSRTL Version 10.1.0.5.0 - Production


l_lstupdate1 TIMESTAMP(6);
time stamp in the table is : 15-OCT-12 07.31.02.599189000 AM

  UPDATE        REPORTSCHEDULE
        SET        SCHEDULE  = XMLTYPE(l_schedulexml)
                     ,NOTFEMAIL = l_notfmail
                     ,REPORTOUT = l_reportout
   WHERE        SETID = l_setid 
       AND        REPORTID = l_reportid 
       AND        USERID = l_userinfo.hpuserid;
--RETURNING LSTUPDATE, REPORTID, SETID
--   INTO l_lstupdate1, l_reportid, l_setid;
              
       SELECT    LSTUPDATE, SETID, REPORTID
          INTO    l_lstupdate1, l_setid,l_reportid 
         FROM    REPORTSCHEDULE
        WHERE   SETID = l_setid 
            AND   REPORTID = l_reportid 
            AND   USERID = l_userinfo.hpuserid;

Edited by: Nag Aswadhati on Oct 15, 2012 5:00 AM