Unable to obtain oracle version or status info as value

[JuezFenix]

I'm submitting a ...

• question

What is the current behavior?

Unable to obtain text from "SELECT banner FROM v$version;", SELECT instance_number, version_full, status, edition, database_type FROM v$instance" o obtain oracle version as value.

Using con_id as dummy metric (i cant put banner in metricsdesc because its a text):

• context: "oracle_version"
  labels: [banner]
  metricsdesc:
  con_id: "Dummy"
  request: "SELECT con_id, banner FROM v$version"

I only see banner as a label and con_id as value, what is completely upside down.

Same case for the other:

• context: "oracle_instance"
  labels: [version_full, status, edition, database_type]
  metricsdesc:
  instance_number: "Version Oracle"
  request: "SELECT instance_number,version_full, status, edition, database_type FROM v$instance"

What is the expected behavior?

Banner value from SELECT banner FROM v$version; as metric value.

Text values from SELECT instance_number, version_full, status, edition, database_type FROM v$instance" as metric value.

Please tell us about your environment:

Oracle 19c - Oracle exporter 0.6.0 Docker