| ORA-00903 [message #37916] |
Wed, 06 March 2002 04:39 |
roberto
Messages: 10
Registered: February 2002
|
Junior Member |
|
|
This is my procedure
CREATE or replace PROCEDURE income(amount number,nome varchar2) IS
id number;
n number;
BEGIN
--
id:= dbms_sql.open_cursor;
dbms_sql.parse(id, 'drop table :nome_tab' , dbms_sql.native);--line 16
dbms_sql.bind_variable(id, 'nome_tab', nome);
n := dbms_sql.execute(id);
dbms_sql.close_cursor(id);
--
--
id:= dbms_sql.open_cursor;
dbms_sql.parse(id, 'create table :nome_tab(campo varchar2(12),numero number(2))'
, dbms_sql.native);
dbms_sql.bind_variable(id, 'nome_tab', nome);
n := dbms_sql.execute(id);
dbms_sql.close_cursor(id);
--
id:= dbms_sql.open_cursor;
dbms_sql.parse(id, 'insert into :nome_tab values(''income'', :numero)', dbms_sql.native);
dbms_sql.bind_variable(id, 'nome_tab', nome);
dbms_sql.bind_variable(id, 'numero', amount);
n := dbms_sql.execute(id);
dbms_sql.close_cursor(id);
--
end;
/
this is the error:
SQL> exec income(1,'po');
BEGIN income(1,'po'); END;
*
ERROR at line 1:
ORA-00903: invalid table name
ORA-06512: at "SYS.DBMS_SYS_SQL", line 487
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "SYS.INCOME", line 16
ORA-06512: at line 1
Why?Thank's
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
