How do i fix this.
I created the plsql code below and it was successful, but it will only insert into the table, it does not return the values when the numjob is greater than 3. How do i fix it
CREATE OR REPLACE PROCEDURE pub_detail IS
CURSOR publisherCursor is
SELECT publisher.publishername,city, phonenumber, COUNT(printjob.publishername) as numjob
FROM publisher, printjob
WHERE publisher.publishername = printjob.publishername
GROUP BY publisher.publishername, citY, phonenumber;
tempRec publisherCursor%Rowtype;
CURSOR printjobCURSOR IS
SELECT publisher.publishername, jobno, startdate, completiondate, count(publishername) as numjob
FROM publisher, printjob
WHERE publisher.publishername = printjob.publishername
GROUP BY publisher.publishername, jobno, startdate, completiondate;