How to fix the Oracle error DRG-10827: open_con must be performed before count_last?

In this post, you’ll learn more about the Oracle ErrorDRG-10827: open_con must be performed before count_last with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-10827: open_con must be performed before count_last

Reason for the Error DRG-10827: open_con must be performed before count_last

Cause: last_count returns hit from in-memory query,so an in-memory query must be run before you can use count_last

How to fix the Error DRG-10827: open_con must be performed before count_last ?

You can fix this error in Oracle by following the below steps

Action: execute open_con before run count_last