Hi,
I'm using Oracle 8i. I'm trying to a select into temp table...here is my syntax:
declare
type t_temp_storage is table of ccardi.tools_mappings%rowtype;
my_temp_storage t_temp_storage;
begin
select * into t_temp_storage from ccardi.tools_mappings
where NEW_table_name = v_new_tablename;
end;
I'm running into the error:
Error report -
ORA-06550: line 2, column 36:
PLS-00201: identifier 'CCARDI.TOOLS_MAPPINGS' must be declared
ORA-06550: line 2, column 4:
PL/SQL: Item ignored
ORA-06550: line 7, column 42:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 7, column 1:
PL/SQL: SQL Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
I used this as an example: https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/selectinto_statement.htm
Your input is appreciated.
Thank you.