ORA-06550 SQL command not ended properly

Question

Hi All,

Help me to solve the below error.

Select
c1.part_number, c1.serial_number into part_examine, serial_examine
from
components c1
where
aircraft_code in (select aircraft_code from aircraft_header_2 AH2 where AH2.current_aircraft_indicator<>'Y'
and trim(AH2.aircraft_code) is not null);

dbms_output_put_line('part in question'||Part_examine||serial_examine);

for i in (dbms_output_put_line('Part In question'||part_examine)
select
c1.part_number, c1.serial_number
from
components c1
where aircraft_code in (select aircraft_code in (select aircraft_code from aircraft_header_2 AH2 where AH2.current_aircraft_indicator<>'Y'
and trim(AH2.aircraft_code) is not null);
dbms_output_put_line('part in question'||Part_examine||serial_examine);
)
loop
components_pkg.delete_part_serial_number(I.Part_number, I.Serial_number, '500', 'CSL')
end loop;
End;

Error:
ORA-06550
PL/SQL: ORA-00933: SQL command not properly ended
ORA:06550
PL/SQL: SQL Statement ignored
ORA:06550
PLS-00103 encountered the symbol";'
loop
065550.0000 -line %s column %s\n%s
plsql compilation Error

Answer 1

I believe this will solve your problem:

BEGIN
SELECT c1.part_number, c1.serial_number
INTO part_examine, serial_examine
FROM components c1
WHERE aircraft_code IN (SELECT aircraft_code FROM aircraft_header_2 AH2
WHERE AH2.current_aircraft_indicator <> 'Y' AND TRIM (AH2.aircraft_code) IS NOT NULL);

dbms_output_put_line ( 'part in question' || Part_examine || serial_examine);
dbms_output_put_line ('Part In question' || part_examine);
dbms_output_put_line ( 'part in question' || Part_examine || serial_examine);

FOR i
IN (SELECT c1.part_number, c1.serial_number FROM components c1
WHERE aircraft_code IN (SELECT aircraft_code FROM aircraft_header_2 AH2
WHERE AH2.current_aircraft_indicator <> 'Y' AND TRIM (AH2.aircraft_code) IS NOT NULL)) LOOP
components_pkg.delete_part_serial_number (I.Part_number, I.Serial_number, '500', 'CSL');
END LOOP;
END;