I code on both SQL Server and Oracle.
When I'm coding in SQL Server, I used this:
OPEN curUSERS;
CLOSE curUSERS;
DEALLOCATE curUSERS;
Now, when I'm coding in Oracle, I used this:
OPEN curUSERS;
CLOSE curUSERS;
I saw a DEALLOCATE keyword in PL/SQL but when I used this statement
DEALLOCATE(curUSERS);
It throws an error. How can I do the same thing (deallocation) in PL/SQL?
Oracle doesn't require to deallocate cursor's memory explicitly. Just CLOSE(cursor)
is fine.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With