Re: Urgent! Got a ORA-6550 when call a stored procedure in servlet.
Wednesday, November 7, 2001 01:06 PM
oerr ora 6550
06550, 00000, "line %s, column %s:
// *Cause: Usually a PL/SQL compilation error.
When the table "schedule" is modified the store code would become invalid and may require compliation which can be done with the follwoing:
Alter Function user_schd compile;
Make sure there are not multiple versions of the function stored in the database under different schemas for instance praticularly if the owner of the function differs from the executer id in the java code.
using SQL*PLUS or like
login as userid from Java Code
select user_schd (1,'1003654800000','1003658400000')
Does this work?
If so it will work in your Java code, too.
If not then there must be more than one illiteration of the PL/SQL code in DB or the object it references are being modified causing the invalidation/ cannot compile circumstance.