Thanks for pointing out that syntax mistake. I have changed it and still get the same error.
I am running Oracle8i on Solaris and I do have all the required privileges. Can I use DBMS_SQL package to create temporary tables too??


Shiva.