Consultor Eletrônico



Kbase P6726: Do FIND-FIRST and CAN-FIRST queries reuse the Oracle cursor?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   31/01/2005
Status: Unverified

GOAL:

Do FIND-FIRST and CAN-FIST statements reuse oracle cursors?

FIX:

No, The FIND-FIRST and the CAN=FIND are two separate statements, thus they should invoke two separate cursors. They can not reuse the same cursor within Oracle.