Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact

Error code groups

ACE ADA/Same Backup Branding and Installation Class Libraries Connection (>V6) Connectivity CM CSS DBAccess Debugger ESQL/C ESQL/C (Windows) Embedded Languages Form Compiler Form and Menu Gateway with DRDA INet (Windows) INet Relay Module ISAM Locales mkmessage NLS Online/Secure Open View Operating System Optical Disk Subsystem Perform Postive Numbers Preprocessor Smart Blobs Roles SQL SQL Utility 4GL Runtime NewEra Compiler 4GL/NewEra Compiler 4GL/NewEra Runtime Unknown
Finderr

-705 Cannot drop/modify procedure procedure-name. It is currently in use.

An attempt was made either to drop a currently executing procedure or to run UPDATE STATISTICS on a currently running procedure. This condition can occur if a procedure tries to drop itself or if a nested procedure tries to drop a procedure that called it.

Example of error:

CREATE PROCEDURE testproc() ... DROP PROCEDURE testproc; -- error END PROCEDURE

Correction: You can use an ON EXCEPTION statement to trap this error and not carry out the DROP PROCEDURE or UPDATE STATISTICS statement.

This error also occurs if you try to drop a function or procedure that a functional index is using.

This error also occurs if you try to drop a function or procedure that a xadatasource type is using.