top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

ORA-06550 SQL command not ended properly

+2 votes
139 views

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

posted Aug 29, 2014 by Varadhu

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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;

answer Sep 11, 2014 by Arun Gowda
Similar Questions
0 votes

Oracle: What all important parameters of the init.ora are supposed to be increased if you want to increase the SGA size?

+2 votes

unable to connect to the DB using Taod it throws below error:

ORA-12571 TNS packet writer failure

Please help.

0 votes

When i try to create a repository service i am getting the below error.

Domain setting:

jdbc:informatica:oracle://localhost:1521;ServiceName=orcl;
MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true

Error:

REP_51002
Failed to logon to Databse Server
Database driver error
Function Name : Logon
ORA-12154: TNS:could not resolve the connect identifier specified
Database driver error
Function Name : Connect

Database Error: Failed to connect to database using user [apps] and connection string [orcl.world].

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...