Re: ORA-01003: no statement parsed *URGENT*

In article <9pie4k$jq2$1_at_innbox.cnet.com>, srik_at_cnet.com says...

I don't know if it would account for it totally, but your datatype for hiredate doesn't work. You've assigned X_hiredate the number 11/17/81 (7.9883...) and declared it as a VARCHAR2 later on.

By the way, why have you not specified datatypes in the declaration section of your procedure?

>X_hiredate := 11/17/81;
...
>begin
>srik_update_row(
...
>X_hiredate,

...
>X_attribute1);
>end;
>create or replace PROCEDURE
>_Update_Row(
...
> X_hiredate IN OUT VARCHAR2,
...
> ) IS
>dummy varchar2(1);
>begin
> UPDATE emp
> SET
...
> hiredate = X_hiredate,
...
> WHERE empno = X_empno;
>
> if (SQL%NOTFOUND) then
> Raise NO_DATA_FOUND;
> end if;
> END srik_Update_Row;
Received on Sun Oct 07 2001 - 00:45:19 CEST