I'm currently working on a project for my Database Management class working with PL/SQL (Oracle 9i) which concerns the use of explicit cursors.
Basically, I have to use an explicit cursor to select two values from three different tables and display them. I think I've got the basic idea of how it works but I'm having issues with displaying the actual results in SQL*Plus.
So far, I'm only working with one variable from one table until I can get this problem solved.
------- Here's what I have now:
CURSOR project_cursor IS
FOR project_row IN project_cursor LOOP
I get no output from that and only get
"PL/SQL Procedure successfully completed"
Any ideas? I'm fairly desperate here. I've been working on this for the past few days and it's due tomorrow. I don't wanna sit around here pulling my hair out anymore so I thought I might try seeking a little expert advice =)