xfedex, yes you can connect to a remote Oracle DB, I'm doing for an app
I'm trying to write. You have to configure php with the oracle version
you have, more than likely with the --with-oci8=/u1/oracle/product/10g
line, of course your oracle location will differ.
I chose to use the PEAR::DB to do
Yeah, you can connect to Oracle remotely. The standard PHP functions should do
it probably, but I've done it using ADODB.
I don't know if this is the same on a *nix box, but I was running PHP on a
Windows box and needed special Oracle stuff installed on my machine to connect
to the Oracle DB.
Create a sequence, like so
CREATE SEQUENCE "WHATEVER_IDS"
INCREMENT BY 1
START WITH 1
MAXVALUE 1.0E28
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;
then when you insert
INSERT INTO test (whatever_ids.nextval);
the nice thing is that in your
3 matches
Mail list logo
