EXECUTE IMMEDIATE ORA-00911: invalid character
183703May 30 2008 — edited May 30 2008Any thoughts around this ...
SQL> Declare
2 v_sequence number;
3 v_sql varchar2(200);
4 begin
5 v_sql := 'SELECT ' || TRIM ('TEST_IDS') || '.NEXTVAL FROM DUAL;';
6 EXECUTE IMMEDIATE v_sql RETURNING INTO v_sequence;
7
8 dbms_output.put_line ('Seq Num '||v_sequence);
9 end;
10 /
Declare
*
ERROR at line 1:
ORA-00911: invalid character
ORA-06512: at line 6