Hi Tim,
Thanks for the reply.
I am using the ORCALE UPSIZING WIZARD...
So can I still do as your answer says??
Thanks
Fida
> 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
Wannabe FoxPert!!!