Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
declare type nt_type is table of string(10); nt nt_type := nt_type ('08.05.2013','09.05.2013'); begin for i in 1..nt.count loop select request_id, request_emode, request_pgm, pp.description, name_id_no, substr(addressee,1,15), policy_no, pr.print_job,request_date from print_request pr, print_program pp where request_pgm = program_id and request_pgm not like ('B8350') and request_pgm not like ('BAT%') and request_pgm not like ('F%') and request_pgm not like ('KX%') and request_pgm not like ('269') and (pr.printer_id in (1,2) or pr.document_pile is not null) and request_emode not like ('X%') and trunc(request_date) = to_date(nt(i), 'DD.MM.YYYY') order by pr.print_job desc, name_id_no; end loop; end;
Error report: ORA-06550: linje 8, kolonne 1: PLS-00428: an INTO clause is expected in this SELECT statement 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a PL/SQL compilation error.