Can anybody send me the script deplete_inv.pls?
Error when run a workload by using the workload generator: $ ./workgen 2 1
The Oracle base for
The Oracle base for ORACLE_HOME=/u01/OracleHomes/db12c/product/dbhome_1 is /u01/OracleHomes/db
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
deplete_inv(order_item_rec.product_id, order_item_rec.quantity);
*
ERROR at line 89:
ORA-06550: line 89, column 6:
PLS-00201: identifier 'DEPLETE_INV' must be declared
ORA-06550: line 89, column 6:
PL/SQL: Statement ignored
The database do not have "deplete_inv" store procedure (SP) for the "oe" schema, and the.O.S. do not have the script "deplete_inv.pls" to create the SP too: