Re: SQL statement works with SQL/Plus - but not with ODBC

Hi,

> You didn't mention the version of Oracle.
> The syntax is legal in Oracle8i, not prior to Oracle8i.

I am using Oracle 8i (8.1.6).

> You may change as following:
>
> UPDATE ... SET ...
> VERSION_NUMBER = (SELECT 1+MAX(VERSION) ... ) ...
>
> It does not need to be put into a PL/SQL block, remove the BEGIN/END.

Well I tried it even without the BEGIN ... END block ... noop :-(

Regards,
Christian

-- 
___________________________________________________
eYesoft                        We see your visions.
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Christian Weyer               http://www.eyesoft.de

christian.weyer_at_eyesoft.de    Bernhard-Krieg-Str. 4
Tel.: +49-9393-993161         97845 Neustadt/Main
___________________________________________________
       Building Smart Internet Architectures       
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯