RE: PLEASE HELP WITH STATEMENT.

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 13 Feb 2002 17:34:29 -0800
Message-ID: <F001.0040EF02.20020213172818@fatcity.com>

If primus_temp_dump is an Oracle table name, then you would just say dbms_sql.parse (cursor_id, 'TRUNCATE TABLE PRIMUS_TEMP_DUMP', dbms_sql.native) ;

If primus_temp_dump is a PL/SQL variable, you would want to declare it in your procedure, and then your statement would be correct.

> -----Original Message-----
> From: Lance Prais [mailto:lprais_at_ts.checkpoint.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
Received on Wed Feb 13 2002 - 19:34:29 CST