# Object Search gives Could not convert variant of type (Null) into type (OleStr) error

**URL:** <https://forums.toadworld.com/t/object-search-gives-could-not-convert-variant-of-type-null-into-type-olestr-error/48058>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [November 4, 2019, 3:12pm UTC](https://forums.toadworld.com/t/object-search-gives-could-not-convert-variant-of-type-null-into-type-olestr-error/48058 "2019-11-04T15:12:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [November 4, 2019, 3:12pm UTC](https://forums.toadworld.com/t/object-search-gives-could-not-convert-variant-of-type-null-into-type-olestr-error/48058/1 "2019-11-04T15:12:54Z")

</div>

I was searching some code snippets with Object search (the logon schema was selected in the left list, only Search source option was selected and job/program/scheduler job and mat.views object types was unselected in the list) which sometimes gives "Could not convert variant of type (Null) into type (OleStr)" error message.

Database|Spool to screen shown the error message with the following query:

Select av.owner, 'VIEW' result\_type, 'Source Search' object\_type,  
av.view\_name object\_name, av.text text  
FROM SYS.DBA\_VIEWS av  
WHERE av.owner IN ('xx');