NEWBIE: declare causes ora-00936
have just upgraded from 817 on HP to 9204
using exp, install new DB and imp.
Now the simple scripts don't start...
select date from dual ;
Oracle9i Enterprise Edition Release 22.214.171.124.0 - 64bit Production
JServer Release 126.96.36.199.0 - Production
ERROR at line 4:
ORA-06550: line 7, column 8:
PL/SQL: ORA-00936: missing expression
ORA-06550: line 7, column 1:
PL/SQL: SQL Statement ignored
I am obviously missing something important.
Maybe also an installation problem.
Application using SQL is fine - only my scripts.
Any ideas ??
Click Here to Expand Forum to Full Width