Why do we receive the Oracle error ORA-01007: variable not in the select list in the uv_scan_s.log?

Document ID : KB000055039
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

We just created a user defined scan "usersql2" (User SQL Numeric Type 02) and this error is in the uv_scan_s.log:

Oracle error returned from usersql
Error number - 1007
ORA-01007: variable not in select list

Solution

The user defined scan was created incorrectly. The results of the SQL statement must return two columns. Modify the SQL so that it returns two columns.