After upgrading the client to 9.2.0.4, JDBC/OCI client gives problem when it invokes stores procedure which returns CLOB datatype. On Wed, 29 Sep 2004 12:53:27 +0200, Jeroen van Sluisdam <jeroen.van.sluisdam@xxxxxxxxxx> wrote: > > Problem is due to a jre installation that is not compatible with jvm > The only jre that is present is the old one 1.1.8 Java is installed > in version 1.4. I have HP-UX 11.11 here. I suspect HP java installation for > 1.4 > is either wrong or I have to correct manually a link > > $ORACLE_HOME/JRE@ -> /opt/java/jre > PATH=/opt/oracle/product/9.2.0.1/bin:/opt/oracle/product/9.2.0.1/bin:/usr/bi > n:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/upgr > ade/bin:/opt/fcms/bin:/opt/pd/bin:/opt/resmon/bin:/usr/bin/X11:/usr/contrib/ > bin/X11:/opt/graphics/common/bin:/opt/gnome/bin:/opt/mozilla:/opt/mx/bin:/op > t/ignite/bin:/usr/sbin/diag/contrib:/opt/spb/bin:/home/oracle/bin:/opt/java1 > .4/bin > > Oracle version is 9.2.04 > $ uname -a > HP$ ls jre > COPYRIGHT install.sh* > jre.os11.release.notes > ControlPanel.html* javalogo52x88.gif > lib/ > LICENSE javaws/ > plugin/ > THIRDPARTYLICENSEREADME.txt javaws-1_2_0_00-hpux-PA_RISC.tar.Z > readme.html > bin/ javaws-1_2_0_00-hpux-PA_RISC2.0.tar > sunlogo64x30.gif > hplogo.gif* javaws.release.notes > $ ls jre/bin > ControlPanel* PA_RISC2.0/ jcpm_server* policytool* > servertool* > HPUXChildWrapper* PA_RISC2.0W/ keytool* rmid* > tnameserv* > PA_RISC/ java* orbd* rmiregistry* > $ pwd > /opt/java1.4-UX niki B.11.11 U 9000/800 863889681 unlimited-user license > > So there is no jre in my /opt/java1.4/bin/jre/bin directory > > Hope you can help me urgently because I'm not getting any progress with my > sysdadmin > here. > > > > Tnx, > > Jeroen > -- > //www.freelists.org/webpage/oracle-l > -- Sami Seerangan Oracle DBA HSBC.com -- //www.freelists.org/webpage/oracle-l