2 Replies Latest reply on Jul 13, 2017 6:14 PM by user4966038

    Sql*developer 17.2 find db-object not working

    KarstenH-dk

      hi

       

      trying to find db-objects using the binocular

      0 objects found which is incorrect

       

      grabbing from the statements log gives me this for the all_source search:

       

      select text name, LINE, instr(upper(text),upper(:text)) COL, null USAGE, TYPE, OWNER, type OBJECT_TYPE, name OBJECT_NAME

      from sys.all_source where rownum <= 500

      and upper(text) like upper(:text1) and name not like 'BIN$%'

      and owner in ( :4 )

       

      the parameters seems to messed up 1="SBO_PERSONDATA_DUB", 2="D191030", 3="D191030", 4="SBO_PERSONDATA_DUB", 5="D191030", 6="SBO_PERSONDATA_DUB", 7="SBO_PERSONDATA_DUB", 8="%SBO_PERSONDATA_DUB%", 9="D191030", 10="SBO_PERSONDATA_DUB", 11="%SBO_PERSONDATA_DUB%", 12="D191030"

       

      the owner is not :4 but :5

      correcting this statement to this

       

      select text name, LINE, text COL, null USAGE, TYPE, OWNER, type OBJECT_TYPE, name OBJECT_NAME

      from sys.all_source where rownum <= 500

      and upper(text) like upper('%SBO_PERSONDATA_DUB%') and name not like 'BIN$%'

      and owner in ( 'D191030' )

       

      Am I doing something wrong ?

       

      regards Karsten

      gives me the result