Connectivity error: [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
PLS-00905: object BAUD.RWF_INSERT_ is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Does this make any sense to u.
This means that your object "RWF_INSERT_"
has a syntax error at line 1 column 7.
OR most likely this line contains the name of a table you have recently altered (added a column changed a datatype ect...)
Try to go to SQLPLUS and type
PROCEDURE,PACKAGE,TRIGGER
alter PROCEDURE BAUD.RWF_INSERT_ recompile;
OR
alter TRIGGER BAUD.RWF_INSERT_ recompile;
(or do it with SQLEXEC....)
I see this most when the DDL has changed on a table
referenced in a trigger or procedure.
PS This code will recompile your invalid objects...
IF gnconnectionhandle<=0
gnconnectionhandle=SQLCON()
ENDIF
*!* lcSQL="{Call RECOMPILE() }"
*!* nerror=SQLEXEC(gnconnectionhandle,lcsql)
IF gnconnectionhanlde>0
lcSQL=" SELECT owner, object_name, object_type FROM ALL_OBJECTS "
lcSQL=lcsql+" WHERE status='INVALID' "
nerror=SQLEXEC(gnconnectionhandle,lcsql,'invalidobjects')
IF NOT USED("invalidobjects") or nerror=-1
messagebox('Error Recompiling Invalid Objects. Cause: No Select Access to ALL_OBJECTS')
RETURN .f.
ENDIF
*Checkforerror(nerror,lcsql)
SELECT invalidobjects
GO TOP
DO WHILE NOT EOF()
lcsql='ALTER '+ALLTRIM(object_type)+' '+ALLTRIM(owner)+'.'+ALLTRIM(object_name)+' RECOMPILE '
nerror=SQLEXEC(gnconnectionhandle,lcsql)
IF nerror!=-1
messagebox('Object : '+ALLTRIM(object_name)+' Recompiled ')
ELSE
messagebox('Error Recompiling Object:'+ALLTRIM(object_name))
ENDIF
skip 1
ENDDO
ENDIF
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement