• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 797
  • Last Modified:

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 .
0
avi_ny
Asked:
avi_ny
  • 2
  • 2
  • 2
  • +3
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
select [NAME] into str11
  from gis.period_info
  where [name]='SP500TR88I' and
sdate='21-JUN-06' and [deleted]='N';
0
 
avi_nyAuthor Commented:
This code is a part of PL/SQL.
I made your suggested changes it is not working that way.
Thanks for help.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
sapnamCommented:
If you give desc gis.period_info in SQL, do you get the description.  
0
 
MohanKNairCommented:
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
0
 
MohanKNairCommented:
Please ignore the above comments
0
 
cdemirCommented:
can you try this :

sdate = to_date('21-JUN-06','DD-MMM-YY')

OR

to_char(sdate,'DD-MMM-YY') = '21-JUN-06'
0
 
awking00Commented:
cdemir has a point, although if sdate has a time element, you need
trunc(sdate) = to_date('21-JUN-06','DD-MMM-YY')
0
 
avi_nyAuthor Commented:
Thanks
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now