مساعده

السلام عليكم

اخواني عندي هذا السؤال

Print the name and address of company that post job number "02" through enter the job number from keyboard

وهذا حلي

set serveroutput on

set verify off;

accept num prompt 'enter the number'

declare

cursor cur is select*

from company

where postjob=#

co company%rowtype;

begin

open cur

fetch cur into co;

exist (cur %notfound)

dbms_output.putline(name||address);

close cur;

end;

ويطلع لي خطا ياليت تفيدوني اش المشكلة

وشكرا