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
