I am using the following statement in Oracle 8.0.6 and getting an error I and I do not understand why it is giving it to me.
CODE: CREATE OR REPLACE procedure primus_temp_dump_test(in_tab_name in varchar2) as cursor_id integer; execute_return_value integer; last_function_code integer; Begin cursor_id := dbms_sql.open_cursor; dbms_sql.parse (cursor_id,'TRUNCATE TABLE '||UPPER(PRIMUS_TEMP_DUMP),dbms_sql.v7); execute_return_value := dbms_sql.execute(cursor_id); last_function_code := dbms_sql.last_sql_function_code; dbms_sql.close_cursor(cursor_id); End; / Error: * ERROR at line 1: ORA-06550: line 1, column 29: PLS-00357: Table,View Or Sequence reference 'PRIMUS_TEMP_DUMP' not allowed in this context ORA-06550: line 1, column 7: PL/SQL: Statement ignored Thank you in advance. Lance --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php