Link to home
Start Free TrialLog in
Avatar of avi_ny
avi_ny

asked on

ORA-00995

select NAME into str11
  from gis.period_info
  where name='SP500TR88I' and
sdate='21-JUN-06' and deleted='N';


ERR:  missing keyword

why i am getting this error .
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

select [NAME] into str11
  from gis.period_info
  where [name]='SP500TR88I' and
sdate='21-JUN-06' and [deleted]='N';
Avatar of avi_ny
avi_ny

ASKER

This code is a part of PL/SQL.
I made your suggested changes it is not working that way.
Thanks for help.
>This code is a part of PL/SQL.
can you post a bit more of that pl/sql. if it's large, only some lines above and below yours...

also: ORA-00995:      missing or invalid synonym identifier

it looks to me that it's not THAT statement issing the error, but rather a CREATE or DROP SYNONYM.
If you give desc gis.period_info in SQL, do you get the description.  
One option is to query the data dictionary views and generate the DDL scripts.

See the link below
http://www.dbasupport.com/oracle/scripts/Detailed/279.shtml

orafaq
http://www.orafaq.com/scripts/sql/cre8like.txt
Please ignore the above comments
ASKER CERTIFIED SOLUTION
Avatar of cdemir
cdemir

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
cdemir has a point, although if sdate has a time element, you need
trunc(sdate) = to_date('21-JUN-06','DD-MMM-YY')
Avatar of avi_ny

ASKER

Thanks