Do you need to use ad_zd_table.drop_table to drop tables for EBS 12.2? Or can I use DROP command?
I tried below and got error:
exec ad_zd_table.drop_table(x_table_owner => ‘COSDCUST’, x_table_name => 'COSD_CT_TEST');
Error starting at line : 1 in command -
BEGIN ad_zd_table.drop_table(x_table_owner => 'COSDCUST', x_table_name => 'COSD_CT_TEST'); END;
Error report -
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'DROP_TABLE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action: