PLEASE HELP WITH STATEMENT.

From: Lance Prais <lprais_at_ts.checkpoint.com>
Date: Wed, 13 Feb 2002 16:46:10 -0800
Message-ID: <F001.0040EEE8.20020213163819@fatcity.com>

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Lance Prais
  INET: lprais_at_ts.checkpoint.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Feb 13 2002 - 18:46:10 CST