I want generate report for Oracle8i

Som commented on Sep 7, 2021

we are having data in oracle8i which is installed on windows 2003 server. we are accessing oracle8i database thru oracle8i client on windowsXP. i want generate reports using PHP. can i do it?

Sebastian Morales commented on Sep 8, 2021

Please test if you can create a OCI connection or PDO connection to your Oracle8i successfully. Then you could use KoolReport's either OracleDataSource or PdoDataSource:

https://www.koolreport.com/docs/datasources/oracledatasource/

https://www.koolreport.com/docs/datasources/pdodatasource/

Let us know if you have any problem. Tks,

Som commented on Sep 8, 2021

i tried to create php file

<?php
class MyReport extends \koolreport\KoolReport
{
    public function settings()
    {
        return array(
            "dataSources"=>array(
                "oracle_mydb"=>array(
                    'connectionString' => 'localhost:11000/XE',
                    'username' => 'username',
                    'password' => 'password',
                    'class' => "\koolreport\datasources\OracleDataSource",
                ),
            )
        );
    }
    public function setup()
    {
        $this->src('oracle_finance')
        ->query("SELECT * FROM paymst where fyear=2021")
        ->pipe(..);
        ->pipe(..);
        ->pipe($this->dataStore('Finance'));
    }
}

But i am not able to connect it to Oracle8i and generate report... pls help

Sebastian Morales commented on Sep 8, 2021

We need to know what error is to debug it. Pls turn on your error reporting in php.ini (display_errors = on), restart your http server, and add the following commands to the beginning of your index.php:

ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);
include "MyReport.php";
$report = new MyReport().
//...

Som commented on Sep 8, 2021

Still i am not getting... can you help me either remotely or thru chatting... i just want connect oracle8i and display records from a table... if it works, i can ask management to buy Koolreport with 24/7/365 support

Sebastian Morales commented on Sep 8, 2021

Pls send an email to support@koolreport.com and mention this topic. Tks,

KoolReport's Forum

I want generate report for Oracle8i #2324

Build Your Excellent Data Report