locked
ORA - 06550 Error Please help! RRS feed

  • Question

  • User-659973843 posted

    I am trying to execute a stored procedure using TOAD in Oracle. I am getting the below error.

     

    The code for SP is as below:

    CREATE OR REPLACE PROCEDURE RDAED.SP_GetList (
       update_dt  IN           date,
       cur_out    OUT          sys_refcursor

    )
    AS
    BEGIN
       OPEN cur_out FOR
       SELECT
                 s.name        ,
                 s.bu_no       ,
                 s.Str_NO          ,
                 s.LUDT   
            
                        
      FROM study s
      where s.LUDT > TO_DATE('update_dt','MM/DD/YYYY')
     
      union
     
      SELECT
                 s.name        ,
                 s.bu_no       ,
                 s.Str_NO          ,
                 d.LUDT   

                        
      FROM study s  ,STR_D_DATA   D
      where D.LUDT > TO_DATE('update_dt','MM/DD/YYYY')
      and s.STR_ID = D.STR_ID
     
      union
     
      SELECT
     
               s.name         ,
               s.bu_no        ,
               s.Str_NO            ,
               r.LUDT
           -- Story Rights
          
      FROM study s,STUDY_RIGHTS R
      where r.LUDT > TO_DATE('update_dt','MM/DD/YYYY')
      and s.STR_ID= r.STR_ID
      order by name ;

    END SP_GetList;

     

    Please help someone!

     

    Regards,

    MadCapz!

    Monday, January 30, 2012 4:38 AM

All replies

  • User705563967 posted

    try to work without where clause I think date format problem used like this to_date('update_dt','MM/dd/YYYY')

    Monday, February 6, 2012 12:31 AM