-
NEWBIE: declare causes ora-00936
Hi Gurus,
have just upgraded from 817 on HP to 9204
using exp, install new DB and imp.
Now the simple scripts don't start...
eg:
declare
c number;
d number;
sqlstring varchar2(2000);
begin
select date from dual ;
END;
/
exit
--------------------
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
JServer Release 9.2.0.5.0 - Production
sqlstring varchar2(2000);
*
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 ??
Rgds
Nick
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|