[Cartoweb-users] Oracle 9i Problem

Max Ueda mhanzo at yahoo.com
Mon Nov 27 14:02:37 EST 2006


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:


$conn = OCILogon("usuario_1", "pronto_278",

$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";



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

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

More information about the Cartoweb-users mailing list