Re: [Gusdev-rad-issues] Oci8 and oracle

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

Hi, Juan,

> directly.  When I run on the command line, the web pages seem to work just
> fine, and I see all the HTML and javascript spit out to STDOUT, BUT I get
> the following error in my error log:
>
>    [30-Nov-2005 12:08:37] PHP Warning:  ora_getcolumn(): Ora_Fetch failed
>    (ORA-01002: fetch out of sequence -- while processing OCI function
>    OFETCH/OFEN) in /usr/local/apache2/htdocs/misc/user_registration.php on
>    line 153
>

This will be due to the bug in the code, ora_fetch will return a record 
within the results, most likely the code assumes it return many 
records and try to loop through it, while the correponding table you have 
in your instance is empty, so the cursoe has o record. Then you got the 
"out of sequence".


> I assume this has something to do with the issues in compiling PHP with OCI8
> and with oracle.
>
> When I try to run user_registration.php from the web-browser, I get a blank
> page, and I get the following in the error log:
>
>    [30-Nov-2005 12:10:22] PHP Warning:
>    dbConnectionSetup(/home/oracle/RADSA_2.0.0/db-include.inc) [<a
>    href='function.dbConnectionSetup'>function.dbConnectionSetup</a>]:
>    failed to open stream: Permission denied in
>    /usr/local/apache2/htdocs/include/php/db.inc on line 6
>
>    [30-Nov-2005 12:10:22] PHP Fatal error:  dbConnectionSetup() [<a
>    href='function.require'>function.require</a>]: Failed opening required
>    '/home/oracle/RADSA_2.0.0/db-include.inc'
> ---(include_path='.:/usr/local/apache2/htdocs/include/php/:./include/php:..
> ----/include/php') in /usr/local/apache2/htdocs/include/php/db.inc on line 6

what is the permission for this file. You should let it owned by apache, 
set it to 700 for security reason.

/home/oracle/RADSA_2.0.0/db-include.inc

---junmin