ORA - 06550 Error Please help!

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!

Answer 1

User705563967 posted

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