Lance,
You seem to be missing quotes around the argument to the upper function.
The following works for me (with 2 quotes added):
dbms_sql.parse (cursor_id,'TRUNCATE TABLE'||UPPER('PRIMUS_TEMP_DUMP'),dbms_sql.v7);
Was this what you meant?
HTH,
Bruce Reardon
-----Original Message-----
Sent: Thursday, 14 February 2002 11:38
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: Reardon, Bruce (CALBBAY)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
