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 .
from gis.period_info
where name='SP500TR88I' and
sdate='21-JUN-06' and deleted='N';
ERR: missing keyword
why i am getting this error .
ASKER
This code is a part of PL/SQL.
I made your suggested changes it is not working that way.
Thanks for help.
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.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
cdemir has a point, although if sdate has a time element, you need
trunc(sdate) = to_date('21-JUN-06','DD-MM M-YY')
trunc(sdate) = to_date('21-JUN-06','DD-MM
ASKER
Thanks
from gis.period_info
where [name]='SP500TR88I' and
sdate='21-JUN-06' and [deleted]='N';