interMedia - III

[Milan Sorm]

Thu, Mar 09, 2000 ve 09:41:37PM +0100 Vojtech Novacek napsal:
# On Wed, 8 Mar 2000, Milan Sorm wrote:
# 
# > jede indexovani. vivat, 50% je za nami. ted jeste proc nejede contains ?
# > 
# > SQL> select * from k_uzivatele where contains(ascii_jmeno,'Petr') > 0;
# > ORA-00604: error occurred at recursive SQL level 1
# > ORA-06550: line 1, column 7:
# > PLS-00201: identifier 'CTXSYS.DR_REWRITE' must be declared
# > ORA-06550: line 1, column 7:
# > PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute)
# > 
# > nemate napad co s tim ? ja se tim tedy budu zase zitra zabyvat, ale uz me
# > nebavi delat furt jen interMedia (nyni uz to delam skoro 25 hodin, grr).
# > 
# > --milan
# >  
# > 
# 
# Jenom si tipnu: spatna prava na ctxsys.
# 

Ne. Problem je v jedine vete, kterou se 8.0.5 odlisuje od 8.1.5:

If this database was an existing ConText site, make sure to remove
text_enable from initSID.ora. It is no longer used in Oracle 8i, and will
actually prevent Oracle 8i from operating properly -- you'll get errors like
"cannot find package DR_REWRITE".

Chapete ? Proste desnej figl. Ach jo, 4 dny casu. Ale jsem dukazem toho, ze
to opravdu jde :)

--milan