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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only