gusdev-gusdev

[GUSDEV] RAD Study-Annotator issues

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

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

[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
> >
>

[GUSDEV] Re: Study-Annotator OCI suppport

[Junmin L. <ju...@pc...>]

Hi, Amruta,
The error you got "Fatal error: Call to undefined function: ora_logon()", 
means you don't have ORA module installed when you compile the php.

Our RAD-SA in cbil here is using ora module against Oracle 10g. We don't 
have any problem. So looks like Oracle 10g DOES support ORA module.

If you still want to use OCI, you might try global replacement the ora 
functions with corresponding oci functions.

If you want me to further look at this problem. Please send me 
the followings, that may help me quickly solve your problem:

1. configuration string when you compile the php
2. the exact error message you got in php log.

Thanks, 
---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
>>

Re: [GUSDEV] RAD Study-Annotator issues

[Elisabetta M. <man...@pc...>]

Hi Amruta,
the RAD study annotator (RADSA) tarballs currently available at the 
donwload site you indicated below are both for previous version of GUS (< 
3.5). A tarball for a RADSA compatible with GUS 3.5 will be released 
probably next week or early the following week and I'll send an 
announcement as soon as that occurs.
Regarding the specific error and Oracle, I had a look at the code for the 
function that is used to connect to the db in the upcoming release (which 
we have been testing and using here in the past month and which works for 
us). 
It appears that it still uss ora_logon (albeit I see a commented out 
OCILogon call). I'll let Junmin, here cc-ed comment on this.
Elisabetta

---

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
>

Re: [GUSDEV] RAD Study-Annotator issues

[Junmin L. <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
>