execute() vs executeUpdate() callable statements

I get an error on executing a callable statement (it takes forever and the system hangs) where as when i use executeUpdate the callable statement executes fine

Search the text in DB schema

desc dba_source

select * from dba_source where upper(text) like '%ENTER THE TEXT YOU WANT TO SEARCH HERE%'

DISTINCT only for some columns

https://community.oracle.com/thread/1120347

select *
  from (select col1,
               col2,
               col3,
               col4,
               col5,
               col6,
               row_number () over (partition by col1, col2, col3, col4, col5 order by null) rn
          from table1)
 where rn = 1