Preamble
Oracle CURSOR – When dealing with cursors, you will need to determine your cursor status. Below is a list of cursor attributes that you can use.
| Attributes | Explanation |
| %ISOPEN | – Returns TRUE if the cursor is open, returns FALSE if the cursor is closed. |
| %FOUND | – Returns INVALID_CURSOR if the cursor is declared but not opened; or if the cursor was closed. – Returns NULL if the cursor is open but the selection was not made. – If finished the selection successfully, it returns TRUE. – If no lines are returned, returns FALSE. |
| %NOTFOUND | – Returns INVALID_CURSOR if the cursor is declared but not opened; or if the cursor was closed. – Return NULL if the cursor is open but the selection was not made. – Returns FALSE if the selection was successfully completed. – Returns TRUE if no lines are returned. |
| %ROWCOUNT | – Returns INVALID_CURSOR if the cursor is declared but not opened; or if the cursor was closed. – Returns the number of rows to be returned. – The ROWCOUNT attribute does not give a real number of rows until you pass the entire cursor. In other words, you don’t have to rely on this attribute to tell how many rows a cursor has after it has opened. |
Here is an example of how the Oracle % NOTFOUND attribute can be used.
CREATE OR REPLACE Function FindCourse
( name_in IN varchar2 )
RETURN number
IS
cnumber number;
CURSOR c1
IS
SELECT course_number
FROM courses_tbl
WHERE course_name = name_in;
BEGIN
open c1;
fetch c1 into cnumber;
if c1%notfound then
cnumber := 9999;
end if;
close c1;
RETURN cnumber;
END;
Cursors in Oracle PLSQL
About Enteros
Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
Enteros for Financial Institutions: Uniting AI Performance Management, Observability, and Cloud FinOps for Operational Excellence
- 2 November 2025
- Database Performance Management
Introduction In today’s fast-paced digital finance ecosystem, agility, scalability, and operational efficiency have become the cornerstones of competitiveness. From high-frequency trading systems to AI-driven fraud detection models, financial institutions rely heavily on massive data infrastructure and complex applications to deliver real-time insights and secure, personalized services. However, this digital transformation brings forth significant challenges — … Continue reading “Enteros for Financial Institutions: Uniting AI Performance Management, Observability, and Cloud FinOps for Operational Excellence”
Revolutionizing Manufacturing Efficiency with Enteros: Harnessing Generative AI, AI SQL, and Advanced Database Software for Smarter Performance Management
Introduction The manufacturing sector is undergoing one of the most transformative periods in its history. The rise of Industry 4.0 has ushered in a new era of digitalization—one defined by intelligent automation, IoT devices, robotics, and data-driven decision-making. Yet, at the heart of this revolution lies a critical challenge: managing, optimizing, and interpreting the ever-growing … Continue reading “Revolutionizing Manufacturing Efficiency with Enteros: Harnessing Generative AI, AI SQL, and Advanced Database Software for Smarter Performance Management”
Inside a Fintech Outage: How 200 Milliseconds of Latency Reshaped Risk
- 31 October 2025
- Software Engineering
Introduction In fintech, performance isn’t just a technical metric — it’s a financial one.Transactions, pricing engines, credit scoring, fraud detection — they all run on milliseconds.But what happens when those milliseconds multiply? In mid-2025, a mid-tier digital lender experienced an unusual outage.Not a crash.Not downtime.Just slow time — an invisible 200 ms delay that rippled … Continue reading “Inside a Fintech Outage: How 200 Milliseconds of Latency Reshaped Risk”
Open Banking APIs: Where Performance = Trust
- 30 October 2025
- Software Engineering
Introduction Open banking promised to be a paradigm shift — enabling consumers to share financial data securely and allowing banks, fintechs, and third parties to build innovative services on that foundation. But as the ecosystem evolves, one truth stands out: it’s not just about access — it’s about performance. An open banking API that’s slow, … Continue reading “Open Banking APIs: Where Performance = Trust”