Writing a procedure

[varun]

CREATE OR REPLACE PROCEDURE SERVICE_ALTER IS
IS
1_COUNT
BEGIN
@<SELECT COUNT(*) INTO 1_COUNT>
@FROM HR.HR_PA_EMP_PRIMARY_ASSIGNMENT;
+IF "1_COUNT < '90000'" THEN
+RAISE_APPLICATION_ERROR(FAILED IN MEETING THRESHOLD);
END;
/

this is the procedure i have in oracle 10g and keep getting this error:

2/1 PLS-00103: Encountered the symbol "IS" when expecting one of the following:

begin function pragma procedure subtype type <an identifier>
<a double-quoted delimited-identifier> current cursor delete
exists prior external language

I am not able to figure it out.

[ngalemmo]

Its all wrong. Have you written an Oracle SP before?

You got "IS" in twice. I have no idea what the @ and + characters are there for, you didn't declare 1_count right, also I don't think you can have a name that starts with a number, and why is the IF condition in quotes and the error message you are trying to send isn't???

[MTomasura]

You have IS twice.

Should be:

create or replace procedure
()
as (or is)

local variable declaration
begin
code section
exceptions
end;

[Sponsored content]