Re: PRO*C && strange errors :-(

In article <32fmpi$ro6_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
|>
|>

This is a known problem, fixed in 1.4.4 and higher of Pro*C. The check number occurs when you prefix a table with the owner name. Try using SQLCHECK=LIMITED to turn off the semantic checking of SQL statements, which will avoid the error. Received on Fri Aug 12 1994 - 20:25:08 CEST