delete data from another's schema
688463Jan 8 2010 — edited Jan 12 2010I want to delete records from another user schema's table using stored procedure. I am using Oracle 10.2.0.3.
Procedure:
1 create or replace procedure test as
2 begin
3 execute immediate 'delete from ' || admin || ' . ' || b;
4* end;
5 /
Warning: Procedure created with compilation errors.
SQL> show errors;
Errors for PROCEDURE test:
LINE/COL ERROR
-------- -----------------------------------------------------------------
3/1 PL/SQL: Statement ignored
3/37 PLS-00201: identifier 'ADMIN' must be declared
ADMIN= Schema name
b= table name
Edited by: user10659725 on Jan 8, 2010 12:21 AM