Re: PRO*C && strange errors :-(
Date: 15 Aug 1994 18:27:47 GMT
Message-ID: <32oc33$hs3_at_k2.San-Jose.ate.slb.com>
In article <32iadc$3ed_at_stud.uni-sb.de>, magri_at_stud.uni-sb.de (Martin Grimsehl) writes:
|> Hi!
|>
|> I got serious problems with my PRO*C Compiler (OS/2, Version 1.3.17.0.8).
|> (Server: NOVELL 3.11, Novell SPX Server: 1.1.1.1)
|>
|>
|> When I do:
|>
|> EXEC SQL SELECT x INTO :y FROM SYS.Z WHERE i=:j;
|>
|> It crys:
|>
|> PCC-U-0061, PL-SQL Check #20108
|> .................Please inform your ORACLE Representative..............!
|>
|> So I did, no results so far.
|>
|> PS: the same error occurs with UPDATE and INSERT... but: all things
|> witch CURSOR- operations *work* !
|>
|> Do I have not enough rights? wrong server/compiler version?
|>
|>
|>
|> cu martin
|>
|>
If the SELECT returns more than 1 row, you will get an error.
You will not get the error when using a cursor.
See page 4-8, 'Using the Select Statement' in
Programmers' Guide to the Oracle Precompilers for details.
Received on Mon Aug 15 1994 - 20:27:47 CEST