weird error on select
- From: "Remigiusz Sokolowski" <remigiusz.sokolowski@xxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Jan 2010 09:43:51 +0100
Hi,
while this is not a problem as we deal with it somehow - it is somewhat
mysterious .
Environment is db v.10.2.0.4. with patches 8576156, 6119455 on Linux x86-64
The problem was a statment "SELECT * FROM acc_stmt", which returned
ORA-00936 missing expression. While this indicates an error in syntax
(usually) there is nothing wrong with the statement as You see.
On this table there are no triggers and 2 unique indexes. There are also
3 packages which reference it.
Every SELECT query ended with the error mentioned above. Moving this
table with rebuilding indexes did not change anything.
I rename it and checked again - the error was there.
Then I simply loaded a new table under the old name, created indexes on
it and recompiled packages.
After this set of operations both tables work properly (also this old one).
Anybody hit something like it or is able to explain this?
Best regards
Remigiusz Sokolowski
--
Pole nakazi
Remigiusz
----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
pos : DBA at DUSB
addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone: +48 58 667 17 43
Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod numerem:
0000021828,
dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku,
VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego,
o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych,
NIP: 586-000-78-20, REGON: 190024711
--
//www.freelists.org/webpage/oracle-l
Other related posts:
