Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Oracle Insert not working||10||74|
|DECLARATION OF CURSOR IS INCOMPLETE OR MALFORMED||5||74|
|looking for guidance on Oracle Sql Formatting standards||9||45|
|MS SQL Server Management Studio R2||4||60|
Join the community of 500,000 technology professionals and ask your questions.