Problem:

How can ORA_ROWSCN be accessed from Net Express?

Net Express 4.0

Oracle 10g

OpenESQL/ODBC

Oracle ODBC driver 9.02.00.63

Resolution:

It is possible to access ORA_ROWSCN by defining a TIMESTAMP host variable:

...

01  my-rowscn-hvar            sql type is timestamp.

...

    ...

        exec sql

        select ora_rowscn, last_name into :my-rowscn-hvar, :my-last-name

        from employees

        where employee_id = 188

    end-exec

    ...

Please note that Oracle's documentation would indicate that this is an Oracle 10g feature only.