ORA-01003: no statement parsed *URGENT*

From: Jack Dawson <srik_at_cnet.com>
Date: Thu, 4 Oct 2001 12:56:56 -0700
Message-ID: <9pie4k$jq2$1_at_innbox.cnet.com>



I am getting the above error..Please help ,, Where is that I went wrong?????

the script is shown below

declare

X_empno := 7839;
X_ename := 'Lamb';
X_Job := 'Cricketer';
X_mgr := 'Fletcher';
[Quoted] X_hiredate := 11/17/81;
X_sal    :=  '2000';
X_comm := '200';
X_deptno := 2098;
X_attribute1 :=  'No Comments';

begin
[Quoted] srik_update_row(

X_empno,
X_ename,
X_job,
X_mgr  ,
X_hiredate,
X_sal,
X_comm,
X_deptno,
X_attribute1);

end;

[Quoted] create or replace PROCEDURE
_Update_Row(

                         X_empno                    IN OUT number,
                          X_ename              IN OUT varchar2,
                          X_job                  IN OUT VARCHAR2,
                          X_mgr             IN OUT VARCHAR2,
[Quoted]                             X_hiredate           IN OUT VARCHAR2,
                          X_sal                      IN OUT VARCHAR2,
                          X_comm                       IN OUT VARCHAR2,
                          X_deptno          IN OUT VARCHAR2,
                          X_attribute1            IN OUT VARCHAR2
                          ) IS
 

[Quoted] dummy varchar2(1);

begin

    UPDATE emp
    SET

       ename                  =     X_ename,
       job                    =     X_job,
       mgr               =     X_mgr,
[Quoted]        hiredate               =     X_hiredate,
       sal                    =     X_sal,
       comm               =     X_comm,
       deptno            =     X_deptno,
       attribute1         =     X_attribute1
[Quoted]     WHERE empno = X_empno;

    if (SQL%NOTFOUND) then
      Raise NO_DATA_FOUND;
    end if;           

    END srik_Update_Row; Received on Thu Oct 04 2001 - 21:56:56 CEST

Original text of this message