Database Insert error: ora-06550 [How to Solve]

Problem: an error is reported when inserting data into the database:

ORA-06550: line 1, column 7: PLS-00905: object TEST.USERINFO_INSERT is invalid

ORA-06550: line 1, column 7: PL/SQL: Statement ignored


Debug server, error found:

Unable to find ‘struts.multipart.saveDir’ property setting. Defaulting to javax.servlet.context.tempdir

Resolution of this error:

Directly execute the stored procedure on the database, 9i normal, 10g error: ora-06575 package or function is in an invalid state

In Oracle SQL developer, we found dependencies, procedure_The status of insertde is invalid

Looking at the procedures item in the database, I found that many stored procedures have errors

The original error reason for this problem is: the fields in the table are changed, and the stored procedure is not changed together, so the stored procedure is wrong


This database table was built by elder martial brother with PD. After it was built, a tool was used to automatically generate some stored procedures. By default, this tool generated SQL server, and the elder martial brother processed it into oracle

Hehe, we need to change the stored procedure. I’ve hardly touched stored procedures before

Similar Posts: