Re: ora-01003

From: C Marc <cmarcoux_at_webnet.qc.ca>
Date: Tue, 12 Dec 2000 13:48:26 GMT
Message-ID: <K0qZ5.590$Wd4.50255340_at_news1.mtl.metronet.ca>

Declare
Cursor c_id_cli is
Select c.id_cli, c.nom_cli, co.id_com
from client c, comcli co, dcocli

where DCOCLI.id_ser_ite = :id_ser_ite
and DCOCLI.id_com = COMCLI.id_com
and COMCLI.id_cli = CLIENT.id_cli;

BEGIN Open c_id_cli;
message('ok');

fetch c_id_cli into :ITEM.id_cli,:ITEM.nom_cli,:ITEM.id_com;
close c_id_cli;
raise form_trigger_failure;

END; On when mouse click on id_cli on my form, I wrote this. I can't see why it dont work
Claire

Cliff Dabrowski <cliffdw_at_my-deja.com> a écrit dans le message : y2OY5.139629$hD4.35277556_at_news1.rdc1.mi.home.com...
> Claire,
>
> You are trying to execute a "statement" on the database but no "statement"
> was parsed. So in other words you are expecting the database to do
 something
> but you did not "tell" it what to do.
>
> Post the code or tell us more about what you are doing.
>
> Hth,
>
> Cliff
>
>
> "C Marc" <cmarcoux_at_webnet.qc.ca> wrote in message
> news:dsIY5.555$Wd4.48738508_at_news1.mtl.metronet.ca...
> > 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
> >
> >
>
>
Received on Tue Dec 12 2000 - 14:48:26 CET