Re: ORA 1003 - No Statement Parsed error
From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1996/01/12
Message-ID: <aVtWvDAlzo9wEwzG_at_jimsmith.demon.co.uk>#1/1
Shouldn't this be .arr?
You may also need to set the length, eg V_MainSlctStmt.len=strlen(...
Date: 1996/01/12
Message-ID: <aVtWvDAlzo9wEwzG_at_jimsmith.demon.co.uk>#1/1
In article <4d1h3c$1s1_at_leto.pcc.edu>, Howard Thompson <hthompso_at_pcc.edu>
writes
>I'm having a bummer. I've got a Pro*C program that is producing an
>ORA-1003 error (no statement parsed) and I cannot figure out why.
>
<SNIP>
> V_MainSlctStmt.len = sprintf(V_MainSlctStmt.arr,
^^^
Shouldn't this be .arr?
You may also need to set the length, eg V_MainSlctStmt.len=strlen(...
> EXEC SQL PREPARE MainSlctS FROM :V_MainSlctStmt;
> EXEC SQL DECLARE MainSlctC CURSOR FOR MainSlctS;
> EXEC SQL OPEN MainSlctC;
>
> EXEC SQL WHENEVER NOTFOUND DO break;
> EXEC SQL WHENEVER SQLERROR DO vf_SqlError();
I think these WHENEVERs will only take effect from here on, so you may
be missing errors on your prepare,declare or open statements.
-- Jim Smith Oracle DBAReceived on Fri Jan 12 1996 - 00:00:00 CET