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?????
end;
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