PLS-00201: identifier 'DO_SEARCH_VT' must be declared

Hi.

I've just installed jchem on my Windows 2008 R2 64 bit server.

JCHEM_CORE_PKG.GETENVIRONMENT()
----------------------------------------------------------------------------

Oracle environment:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

JChem Server environment:
Java VM vendor: Sun Microsystems Inc.
Java version: 1.6.0_24
Java VM version: 19.1-b02

JCHEM_CORE_PKG.GETENVIRONMENT()
----------------------------------------------------------------------------

JChem version: 5.4.1.1
JChem Index version: 5040100
JDBC driver version: 11.1.0.7.0-Production


Disconnected from Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

 

The package JCHEM_BLO_PKG and JCHEM_CLOB_PKG will not compile due to

PLS-00201: identifier 'DO_SEARCH_VT' must be declared.

 

What have I missed ?

Regards,

Micke

Hi Micke,

Is this a fresh installation of JChem Cartridge? Is this not an upgrade?

In 5.4.1.1, I see no reference to DO_SEARCH_VT either in jchem_clob_pkg or in jchem_blob_pkg (or in any PL/SQL scripts for that matter), so I don't see at this point how a fresh install could have this problem.

If this is an upgrade, which version did you upgrade from?

Thanks

Peter

Hi Peter.

I think the error was caused by old objects being created by import.

I dropped and reinstalled the cartridge.

 

Regards,

Micke