[Cartoweb-users] Oracle 9i Problem

[Max Ueda]

Hi,

Well, I still could not retrieve data from the Oracle
database I need to access (because of the problem I
mentioned in the post before) by  using the PEAR
interface, so, I´d tried to do this via PHP funcions
(ocilogon(), ociparse(), etc.). When I'm using php
scritps outside Cartoweb (for example, something very
simple, say, test.php), something like:

<?php

$conn = OCILogon("usuario_1", "pronto_278",
'//192.168.0.222:1521/BANCODEMAPAS);

$query = 'select * from TABELA_01';

$stid = OCIParse($conn, $query);
OCIExecute($stid, OCI_DEFAULT);
 while ($succ = OCIFetchInto($stid, $row)) {
    foreach ($row as $item) {
      echo $item." ";
    }
    echo "<br>\n";
 }

 OCILogoff($conn);

?>

I can connect normally to my database and retrive the
data I'm looking for. But when I copy/paste that
section of code to my recenter plugin, it returns 

"Fatal error: Call to undefined function OCILogon() in
filename.php on line XXX"

Is there any way of calling those OCI functions from a
Cartoweb plugin? What class should I use to call them?

Thanks in advance,

Max H. Ueda


--- Max Ueda <mhanzo at yahoo.com> wrote:

> Hi,
> 
> I'm developing a Cartoweb Application that has to
> access an Oracle (9i) Database, and although I had
> configured everything as the Oracle (installed the
> OCI10 Instant Client, as it is described here:
>
http://www.oracle.com/technology/pub/notes/technote_php_instant.html)
> and PEAR documents say, it is returning the
> following
> error:
> 
> Class : CartocommonException
> Message : Error [2, dl() [function.dl]: Unable to
> load
> dynamic library 'c:/wamp/php/ext/php_oci8.dll' -
> N&#65533;o foi poss&#65533;vel encontrar o
> procedimento especificado.
> , C:\php5\PEAR\PEAR.php, 753]
> 
> At the phpinfo() page, it says that the OCI Support
> is
> enable, thus, I thought that the php_oci8.dll has no
> problems at all, nor I have no problems by
> configuring
> the paths and environment variables (I'm using
> WinXP).
> 
> 
> Can anybody help?
> 
> Thanks in advance,
> 
> Max H. Ueda
> 
> 
>  
>
____________________________________________________________________________________
> Do you Yahoo!?
> Everyone is raving about the all-new Yahoo! Mail
> beta.
> http://new.mail.yahoo.com
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
>
http://lists.maptools.org/mailman/listinfo/cartoweb-users
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com