Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP 6.0 and ORACLE 8.0
Message
De
23/09/1999 08:13:29
 
 
À
23/09/1999 07:07:12
Fida Shamsoodeen
Combined Systems (Pty) Ltd
Centurion, Afrique du Sud
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00267452
Message ID:
00267915
Vues:
20
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
Fil
Voir

Click here to load this message in the networking platform