Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 6.0 and ORACLE 8.0
Message
From
23/09/1999 08:13:29
 
 
To
23/09/1999 07:07:12
Fida Shamsoodeen
Combined Systems (Pty) Ltd
Centurion, South Africa
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00267452
Message ID:
00267915
Views:
21
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
Map
View

Click here to load this message in the networking platform