Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ora-01003

Re: ora-01003

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Mon, 11 Dec 2000 11:55:28 -0500
Message-ID: <3A350700.B5EBBAA6@Unforgetable.com>

C Marc wrote:

> Hi.
>
> Always get this message, and I can't figure what it mean.
>
> ORA-01003 no statement parsed
>
> Cause: A host language program call referenced a cursor with no associated
> parsed SQL statement. A SQL call (for example, OSQL3) must be used to pass a
> SQL statement to Oracle and to associate the statement with an open cursor.
> A cursor must already have an associated SQL statement if referenced in any
> of the following calls: DESCRIBE, NAME, DEFINE, BIND, EXECUTE,and FETCH.
> Action: Do the SQL call, for example, OSQL, to pass the required SQL
> statement before referencing the cursor.
>
> Thanks for help
>
> Claire
>
> Reply
> cmarcoux_at_webnet.qc.ca

Make sure that the last line in your script contains an end-of-line character. Oterwise the parser doesn't know that the sql has ended. Received on Mon Dec 11 2000 - 10:55:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US