Hello everybody,
I did some modifies for making PHP Weather work with Oracle 8.
I modify the phpweather.inc substituting the calls to Postgres with the
similar commends for Oracle. I created a table in the same way you did but I
enlarged the fields METAR up to 450 because the string I fetched was larger
than 255.
This is the new table in a Oracle instance:

Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.2.0 - Production
SQLWKS> desc metars
Column Name                    Null?    Type
------------------------------ -------- ----
METAR                          NOT NULL VARCHAR2(450)
TIMESTAMP                               DATE
STATION                        NOT NULL VARCHAR2(4)

This is an example of data from metars table:

SQLWKS> select * from metars
     2>
METAR
TIMESTAMP            STAT
----------------------------------------------------------------------------
---- -------------------- ----
 Server: Domino-Go-Webserver/4.6.2.7 Date: Mon, 02 Jul 2001 10:16:48 GMT
Accept- 02-JUL-01            LIQN
 Server: Domino-Go-Webserver/4.6.2.7 Date: Mon, 02 Jul 2001 11:45:15 GMT
Accept- 02-JUL-01            LIMF
 Server: Domino-Go-Webserver/4.6.2.7 Date: Mon, 02 Jul 2001 11:46:12 GMT
Accept- 02-JUL-01            LIPL
 Server: Domino-Go-Webserver/4.6.2.7 Date: Mon, 02 Jul 2001 11:46:48 GMT
Accept- 02-JUL-01            LIPE
 Server: Domino-Go-Webserver/4.6.2.7 Date: Mon, 02 Jul 2001 09:07:00 GMT
Accept- 02-JUL-01            LIRZ
5 rows selected.

I put in attachement the new phpweather.inc.

Bye


Francesco Dini
Aeroporti di Roma spa
Via dell'Aeroporto di Fiumicino, 320
00050 - Fiumicino (RM)
Tel.: 06/65953817
Fax.: 06/65953997
e-mail: [EMAIL PROTECTED]

phpweather.inc

Reply via email to