Where can I find more information about the ResultSet object returned by the session.executeQuery method?
According to the very limited extension API docs, the method “Executes a DQL query and returns a ResultSet object.”
I am struggling to find the correct documentation on how to extract the data from the ResultSet object.
How can I extract it to a json, similar to how it is displayed in the extension log?
Content-Type: application/json
Request-Id: r7m3AwOrA9cFmaALnLfk_Q
Link: <http://localhost:51439/20221610/tasks/MKoW2kE28Av5rV68mtw_Ow/> ; rel="dbtools:rel:task"
{
"env": {
"defaultTimeZone": "Z"
},
"items": [
{
"statementId": 1,
"statementType": "query",
"statementPos": {
"startLine": 0,
"endLine": 0
},
"statementText": "select user from dual",
"statementSqlId": "ahc9t761kxw30",
"resultSet": {
"metadata": [
{
"columnName": "USER",
"columnTypeName": "VARCHAR2",
"precision": 128,
"scale": 0,
"isNullable": 1
}
],
"items": [
{
"USER": ""
}
],
"count": 1,
"links": [
{
"rel": "dbtools:rel:result_set_large_objects",
"href": "http://localhost:51439/20221610/databases/connections/sessions/1JAFuaCVAEMz2SRkHfW6Mg/largeObjects/?requestId=r7m3AwOrA9cFmaALnLfk_Q"
}
]
},
"response": []
}
]
}
or alternatively as the QueryResultSet-container div