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