[GUSDEV] Study-Annotator OCI suppport

[Amruta J. <am...@st...>]

Hi Junmin,

The problem is not with php compilation; all oci functions are working fine.
Oracle 10g does not support ora_ functions. Hence, to use the
StudyAnnotator, we'll need to migrate the existing code to OCI ie rewrite
the ora_ fuction calls with equivalent oci ones. If you have any simpler
solution for this problem, please let me know.

If you have a copy of StudyAnnotator with OCI, it will prove helpful as a
starting point/guideline.

If anyone has an OCI version of StudyAnnotator, we'll appreciate if you can
share the code.

Thanks,
Amruta

Quoting Junmin Liu <ju...@pc...>:

> Hi, Amruta,
> Yes, the OCI is more modern oracle php lib. At one point I migrated the
> code to use OCI, but I had to revert them back due to some reasons I
> cann't
> remember for now. Sorry about that, it could be that I cann't find a way
> to "fetch clob datatype from Oracle using OCI fucntion".
>
> Anyway, could you please check your php config? What is the options you
> use to compile PHP? Do you have the following two options:
>
>   --with-oracle=/path/to/oracle/home/dir
>   --with-oci8=/path/to/oracle/home/dir
>
>
> ---junmin
>
>
>
>
> On Wed, 9 Nov 2005, Amruta Joshi wrote:
>
> > Hi,
> >
> > We have installed GUS & have some basic data in it. We are using Oracle
> 10g
> > (Release 10.1).
> >
> > I have compiled the Study-Annotator for entering study-related data.
> However,
> > all the ora_ calls in the php files (likeora_logon, ora_getColumn etc.)
> fail.
> > I keep getting the error:
> >   Fatal error: Call to undefined function: ora_logon()
> >
> > The function ociLogon works just fine. It seems that Oracle 10g
> supports only
> > OCI calls and not ora_ functions, which means I may have to rewrite
> chunks of
> > code that use ora_ calls.
> >   Is there a better alternative to this?
> >   Is Study-Annotator also made available with the new OCI calls?
> > I'm using the Study-Annotator source code from
> > http://www.cbil.upenn.edu/downloads/RAD/
> >
> > Please reply soon, we need to get this working asap.
> >
> > thanks,
> > Amruta
> >
> >
> >
> > -------------------------------------------------------
> > SF.Net email is sponsored by:
> > Tame your development challenges with Apache's Geronimo App Server.
> Download
> > it for free - -and be entered to win a 42" plasma tv or your very own
> > Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> > _______________________________________________
> > Gusdev-gusdev mailing list
> > Gus...@li...
> > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> >
>