Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> invalid identifier. function in where clause wrapped by to_char
perhaps tthis select will be very slow and terrrible, but I get
invalid identifier on this line right on the function
monthsfirstattempt.
I know the function works. Any reason I can't do this? I get the error here:
and
to_char( monthsfirstattempt(o.account_number,'200710'),'yyyymm' )='200710'
select
main_ani(o.account_number) ANI,
u.creation_date , u.nombre, u.apellido, o.address, o.city, o.st, o.zip, o.validation_date CHARGEDATE,
Thanks in advance for any help or information. Received on Thu Nov 08 2007 - 17:36:35 CST
![]() |
![]() |