Hi Team,
db version : oracle 10g
i was deploying the the script in particlaur schema and as i do not have schema password i used alter session set current_schema=odb;
i am able to create the table but i am not able to drop the created table inside the pl/sql block
OPEN c_obj_exists('test', 'TABLE');
FETCH c_obj_exists INTO vc_obj_exists;
IF c_obj_exists%FOUND THEN
EXECUTE IMMEDIATE 'drop table test';
DBMS_OUTPUT.PUT_LINE('Temporary table test dropped.');
END IF;
CLOSE c_obj_exists;
appreciated any help on this
PGR