实例解析acle ORA-00903错误的具体原因

acle ORA-00903错误具体原因分析            
acle ORA-00903错误具体原因分析 
 

　　ORA-00903 invalid table name

　　ORA-00903：无效的表名

Cause A table or cluster name 
is invalid or does not exist. This 
message is also issued if an invalid 
cluster name or no cluster name is 
specified in an ALTER CLUSTER or DROP 
CLUSTER statement.

Action Check spelling. A valid table 
name or cluster name must begin with 
a letter and may contain only 
alphanumeric characters and the 
special characters $, _, and #. 
The name must be less than or 
equal to 30 characters and cannot 
be a reserved word.

The DBMS_SQL package can be used to execute 
DDL statements directly from PL/SQL.

CREATE OR REPLACE PROCEDURE ddlproc 
(tablename varchar2, cols 

varchar2) AS
cursor1 INTEGER;
BEGIN
cursor1 ：= dbms_sql.open_cursor;
dbms_sql.parse(cursor1, 'CREATE TABLE ' || tablename || '
( ' || cols || ' )', dbms_sql.v7);
dbms_sql.close_cursor(cursor1);
end;
/
SQL> execute ddlproc ('MYTABLE','COL1 NUMBER,
 COL2 VARCHAR2(10)');
PL/SQL procedure successfully completed.
SQL> desc mytable;
Name Null? Type
------------------------------- --------
COL1 NUMBER
COL2 VARCHAR2(10)