[support23]

отлично, я нашел что искал, спасибо!

добавил строки:
$aResultsArray = $rs.GetRows()
_ArrayDisplay($aResultsArray, "Results")

конечный результат:

Код:

$conn = ObjCreate( "ADODB.Connection" )
$DSN =   "Driver={Microsoft ODBC for Oracle}; " & _
         "CONNECTSTRING=(DESCRIPTION=" & _
         "(ADDRESS=(PROTOCOL=TCP)" & _
         "(HOST=hostname)(PORT=1521))" & _
         "(CONNECT_DATA=(SERVICE_NAME=dbname))); uid=login;pwd=password;"
$conn.Open($DSN)
$rs = ObjCreate( "ADODB.RecordSet" )

$select = "select vr.NAME from dwb.USERS us join dwb.USER_ROLE ur on ur.id_user=us.id_user join dwb.V_ROLE vr on ur.id_role = vr.ID_USER where us.NAME = 'Ivanov'"
$rs.Open($select, $conn )


$aResultsArray = $rs.GetRows()
_ArrayDisplay($aResultsArray, "Results")

$conn.close