> The NULL is the problem because Oracle doesn't know what datatype, scale, or > precision you want the PROVIDER column to be. And, as the error message > states, "zero-length columns" are not permitted... > > How about breaking it up into two statements: a CREATE TABLE followed by an > INSERT ... SELECT? IIRC, it is also possible to use CAST in such statement to set a datatype to a column. Tanel. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------