Richard Lynch wrote:
DB truncation could be either of the following:
#1.
The column is not large enough to hold that data.
Research LONGTEXT and BLOB
#2.
The query buffer is not large enough to pass the data in.
Re-configure your db/php setup.
It was definitely to do with casting it to a CLOB
DB truncation could be either of the following:
#1.
The column is not large enough to hold that data.
Research LONGTEXT and BLOB
#2.
The query buffer is not large enough to pass the data in.
Re-configure your db/php setup.
Note that cramming all that XML into the DB seems kinda silly to me,
unl
Brad Bonkoski wrote:
Brad Bonkoski wrote:
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2007-01-18 11:46:10 -0500:
Hello All,
I have this Oracle function, and within my code I call it like this:
$sql = "BEGIN :result := my_funtion_name('$parm1', $parm2, null,
null, null); END;";
$s
Brad Bonkoski wrote:
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2007-01-18 11:46:10 -0500:
Hello All,
I have this Oracle function, and within my code I call it like this:
$sql = "BEGIN :result := my_funtion_name('$parm1', $parm2, null,
null, null); END;";
$stmt = $db->parse($sql)
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2007-01-18 11:46:10 -0500:
Hello All,
I have this Oracle function, and within my code I call it like this:
$sql = "BEGIN :result := my_funtion_name('$parm1', $parm2, null, null,
null); END;";
$stmt = $db->parse($sql);
$rc = null;
# [EMAIL PROTECTED] / 2007-01-18 11:46:10 -0500:
> Hello All,
>
> I have this Oracle function, and within my code I call it like this:
>
> $sql = "BEGIN :result := my_funtion_name('$parm1', $parm2, null, null,
> null); END;";
>$stmt = $db->parse($sql);
>$rc = null;
>ocibi
[snip]
did the execute actually succeed? does the data get into the DB if you
use OCI_COMMIT_ON_SUCCESS instead of OCI_DEFAULT?
I don't support using oci_internal_debug() gives you any extra info?
[/snip]
I finally did an oci_bind_by_name and then performed the commit. It
worked. Oci_internal_de
Jay Blanchard wrote:
> Good afternoon and salutations denizens of the greatest list generated
> by electrons!
>
> I have a situation where I am trying to commit a transaction in Oracle
> with PHP as follows;
>
> $udGeocode = oci_parse($conn, "UPDATE CONT_ADDRESS SET GEOCODE =
> '".$geocode[0]."'
[snip]
I am using PHP with Oracle, but not executing stored procedures.
I assume you are already validating the contents of the $addr variable
before you bind it?
Otherwise, no real ideas here...
[/snip]
Yes, I am validating the contents of the variable. I have ton some
reading, but details a
I am using PHP with Oracle, but not executing stored procedures.
I assume you are already validating the contents of the $addr variable
before you bind it?
Otherwise, no real ideas here...
-B
Jay Blanchard wrote:
[snip]
I have a stored procedure in Oracle;
p_BILL_TO_ADDRESS1 IN C
[snip]
I have a stored procedure in Oracle;
p_BILL_TO_ADDRESS1 IN CONT_ADDRESS.ADDRESS1%TYPE
Default NULL, --VC(50)
With a condition;
IF p_BILL_TO_ADDRESS1 is NULL THEN
Raise_Application_Error(-20100,'BILL TO Address cannot be a NULL
Value');
END IF;
I have some PHP code that tri
Marc G. Fournier wrote:
http://www.businessweek.com/technology/content/feb2006/tc20060209_810527.htm
"Also in Oracle's crosshairs: closely held Zend, based in Cupertino,
Calif.
Zend's PHP software language is one of the most prevalent on the Web,
present in more than 18 million Web sites.
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.
Hi guys!! I'm just getting back into harness after 4 months off work
following major surgery, so I'm well behind on all the PHP groups. It's
nice to be back!
Forgive me for responding to this one over a month later, but I haven't seen
anybody else pointing this out:
On 13 June 2005 13:30, Shan
On 6/13/05, Jay Blanchard <[EMAIL PROTECTED]> wrote:
> To find out how your PHP was compiled create a test page with this
> only...
>
>
> phpinfo();
>
> ?>
>
> And then load the page from your web server. It will return a wealth of
> information to you. As far as Oracle compatability it would
[snip]
How do I find out how my PHP was compiled? The documentation states:
You have to compile PHP with the option --with-oracle[=DIR], where
DIR defaults to your environment variable ORACLE_HOME.
But I'm using PHP from the Red Hat default install (I didn't compile
it).
Also, do you know if th
On 6/10/05, Richard Lynch <[EMAIL PROTECTED]> wrote:
> On Fri, June 10, 2005 8:48 am, Shane Presley said:
> > Where can I find some info on integrating Oracle and PHP?
>
> http://php.net/oracle
>
> pretty much covers it.
Thanks! You're right, that looks pretty straight forward. Although I
do h
On Fri, June 10, 2005 8:48 am, Shane Presley said:
> Where can I find some info on integrating Oracle and PHP?
http://php.net/oracle
pretty much covers it.
> I had some PHP front ends to a MySQL database, worked great. Our DBAs
> want to change the back end from MySQL to Oracle 10g. How hard w
Shane Presley wrote:
Where can I find some info on integrating Oracle and PHP?
I had some PHP front ends to a MySQL database, worked great. Our DBAs
want to change the back end from MySQL to Oracle 10g. How hard would
it be to convert my PHP scripts, and where would I go to read up on
Oracle
[snip]
Where can I find some info on integrating Oracle and PHP?
I had some PHP front ends to a MySQL database, worked great. Our DBAs
want to change the back end from MySQL to Oracle 10g. How hard would
it be to convert my PHP scripts, and where would I go to read up on
Oracle <--> PHP?
[/snip]
Thanks, i catch the prob, after ociparse(), using ocifetchinto, the indexes
in the array are generated as UPPERCASE...
-Original Message-
From: Fidencio Monroy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 2:08 PM
To: (PHP General List)
Subject: [PHP] Oracle 8 functions
Hi, im
IT WORKS.
Exactly, I need to unset the locale variables With that It works
without problems.
Thank you all.
in the start script to see which variables are set. Boot, move
/tmp/apache-start to /tmp/apache-boot, stop apache, start apache from
your root shell. "diff -u /tmp/apache-boot /tmp/ap
Ok, thanks
I will try it.
Michael Mauch wrote:
Luis Moran Ochoa wrote:
ORACLE_SID=OWEB ;export ORACLE_SID;
ORACLE_HOME=/usr/oracle/product; export ORACLE_HOME;
TNS_ADMIN=/usr/oracle/product/network/admin; export TNS_ADMIN;
ORACLE_BASE=/usr/oracle; e
Luis Moran Ochoa wrote:
> ORACLE_SID=OWEB ;export ORACLE_SID;
> ORACLE_HOME=/usr/oracle/product; export ORACLE_HOME;
> TNS_ADMIN=/usr/oracle/product/network/admin; export TNS_ADMIN;
> ORACLE_BASE=/usr/oracle; export ORACLE_BASE;
> ORA_NLS33=/usr/oracle/product/oc
These are the exact details...
/usr/oracle permissions 750 owner oracle.oinstall
apache belongs to oinstall.
script permissions in /etc/init.d/apache --> 755
ORACLE_SID=OWEB ;export ORACLE_SID;
ORACLE_HOME=/usr/oracle/product; export ORACLE_HOME;
TNS_ADMIN=/usr/
In mail.php.general, imran <[EMAIL PROTECTED]> wrote:
[snip]
> format like such: php_xxx. For Oracle DD, you'll need php_oracle.dll. Take
> the oracle dll.
Only use the oracle dll if you are using oracle 7 client libs. If you are
using Oracle 8+ then you want the oci8 dll. Do not copy the php_o
-Edit the php.ini file
GET THE DLLs:
The Dlls for mssql and others (oracle, sybase, etc.) are NOT included in the
installation (Install Shield Wizard) in the root folder.
Get the other package for windows systems (NO Install shield!). Just plain
files. After unzipping the file, look for the su
[EMAIL PROTECTED] wrote:
Hello mailing list, I want to use Oracle function in PHP parser in Win32
OS,
but I don't know how to install it, in the official documentation tell
this:
Installation
You have to compile PHP with the option --with-oracle[=DIR], where DIR
defaults to your environmment vari
> Hello mailing list, I want to use Oracle function in PHP parser in Win32
OS,
> but I don't know how to install it, in the official documentation tell
this:
>
> Installation
> You have to compile PHP with the option --with-oracle[=DIR], where DIR
> defaults to your environmment variable ORACLE_HO
> I'm recalling this from memory, and I may not be 100% right, but it
> should put you on the right path. You will need to install the Oracle
> client libraries on the box with php (you can find these on the Oracle
> discs used to install the actual database).
Yes
> correctly, the Oracle disc
I'm recalling this from memory, and I may not be 100% right, but it
should put you on the right path. You will need to install the Oracle
client libraries on the box with php (you can find these on the Oracle
discs used to install the actual database). However, if I remember
correctly, the Or
> First, let me just say that I'm no Oracle guru. :) But while we're waiting
> for them...
Thanks, all help appreciated :)
> *I think* you need to have Oracle installed even if you wouldn't really
> connect to it but instead connect to a different server. Since I installed
> Oracle with most of t
"Maxim Maletsky" <[EMAIL PROTECTED]> wrote:
>
> Well, I will spread some light - I maintain OCI8 extension :)
>
> Your machine does not need Oracle Server installed, it needs Oracle
> Client installed. These are two completely different things.
>
> So, try this in your command prompt:
>
> ec
Dan Field wrote:
functionality included. If I recompile PHP, will I need the Oracle
headers on the machine also? If so this could be a problem as the Oracle
server I wish to use is not on the same machine as the webserver.
Seems lots of us have not actually tried doing it without Oracle
instal
Well, I will spread some light - I maintain OCI8 extension :)
Your machine does not need Oracle Server installed, it needs Oracle
Client installed. These are two completely different things.
So, try this in your command prompt:
echo $ORACLE_HOME
if you get a result, means the client is there a
Your machine will need the Oracle headers which are included in Oracle
Client. So, in two words - your machine needs Oracle client installed.
Try doing:
echo $ORACLE_HOME
in your command prompt
--
Maxim Maletsky
[EMAIL PROTECTED]
Dan Field <[EMAIL PROTECTED]> wrote... :
> On Tue, 2002-11-1
Hello,
First, let me just say that I'm no Oracle guru. :) But while we're waiting
for them...
"Ford, Mike [LSS]" <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: Dan Field [mailto:danf@;ceredigion.gov.uk]
> > Sent: 12 November 2002 13:39
...[snip]...
> > That is great news,
> -Original Message-
> From: Dan Field [mailto:danf@;ceredigion.gov.uk]
> Sent: 12 November 2002 13:39
>
> On Tue, 2002-11-12 at 13:03, Ford, Mike [LSS] wrote:
> > > -Original Message-
> > > From: Dan Field [mailto:danf@;ceredigion.gov.uk]
> > > Sent: 12 November 2002 12:18
> > >
On Tue, 2002-11-12 at 13:03, Ford, Mike [LSS] wrote:
> > -Original Message-
> > From: Dan Field [mailto:danf@;ceredigion.gov.uk]
> > Sent: 12 November 2002 12:18
> >
> > Can anyone tell me if Oracle 7 is supported by PHP 4.2.2 ?
>
> Yes.
>
> > I have found functions specific to Oracle 8
OCI 7 does not need any modification to support 8 and 9 but they aren't
as powerful, thus should only be used for Oracle 7.
OCI8 is the 8th OCI and fully supports Oracle 8 with and Oracle 9. For
Oracle 9 there are a few thing that are missing, but overall can be
safely used on high level productio
Dan Field <[EMAIL PROTECTED]> wrote... :
> Can anyone tell me if Oracle 7 is supported by PHP 4.2.2 ?
Yes, it is. Oracle extension is supporting Oracle 7th version, while OCI8
is primarily for 8 and 9th versions, they might be also working for
Oracle 7.
> I have found functions specific to Ora
> -Original Message-
> From: Dan Field [mailto:danf@;ceredigion.gov.uk]
> Sent: 12 November 2002 12:18
>
> Can anyone tell me if Oracle 7 is supported by PHP 4.2.2 ?
Yes.
> I have found functions specific to Oracle 8i and some more generic
> functions (are these only for Oracle 9?).
No
"Maxim Maletsky" <[EMAIL PROTECTED]> wrote in message
news:20021028122405.4F05.MAXIM@;php.net...
> What's the Oracle version?
8.1.7
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
What's the Oracle version?
OCIServerVersion($stmt);
--
Maxim Maletsky
[EMAIL PROTECTED]
www.PHPBeginner.com // PHP for Beginners
www.maxim.cx // my Home
// my Wish List: ( Get me something! )
http://www.amazon.com/exec/obidos/registry/2IXE7SMI5EDI3
Juhan Kundla <[EMAIL PROTECT
Hei!
Ühel ilusal päeval [27-10-2002 21:27] kirjutas Nick Eby:
> I'm running oracle 8.1.7 w/ php 4.2. I use the oci8 functions to update
> clob columns, and maybe 1 out of every 15 or 20 times, updating a clob
> column causes the mysterious "ora-600, internal error code". Anybody out
> there expe
On Wed, Sep 18, 2002 at 02:48:13PM +0200, Rasmus Sellberg wrote:
> Does PHP release the Oracle connection if I run PHP from the command line?
yes
tc
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Oracle 9i would be happy with the left join syntax but not 8i.
-Original Message-
From: Martin Towell [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 6:09 AM
To: 'Nick Oostveen'; Frank S. Kicenko; [EMAIL PROTECTED]
Subject: RE: [PHP] Oracle 8i SQL Problem..
You'l
ssage-
From: Nick Oostveen [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 1:47 PM
To: Frank S. Kicenko; [EMAIL PROTECTED]
Subject: Re: [PHP] Oracle 8i SQL Problem..
I could be wrong on this but I believe that Oracle 8i uses a proprietary
join syntax. This support has been added in the l
I could be wrong on this but I believe that Oracle 8i uses a proprietary
join syntax. This support has been added in the latest version of Oracle,
but with 8i I believe you're out of luck using the left join keywords.
Check out
http://certcities.com/certs/oracle/columns/story.asp?EditorialsID
On Tue, Jul 23, 2002 at 11:39:20AM -0700, Eric Thelin wrote:
> That is what I figured. The problem is that oracle doesn't even seem to
> have per-process limits.
the oci-driver will only open one server-connection per
TNS-name/process.
so if you use
$a = ociplogon("scott", "ti
That is what I figured. The problem is that oracle doesn't even seem to
have per-process limits.
Eric
On Tue, 23 Jul 2002, Thies C. Arntzen wrote:
> On Tue, Jul 23, 2002 at 11:00:43AM -0700, Eric Thelin wrote:
> > Is there a way to limit the total number of persistent connection to an
> > orac
On Tue, Jul 23, 2002 at 11:00:43AM -0700, Eric Thelin wrote:
> Is there a way to limit the total number of persistent connection to an
> oracle database? I know this functionality exists for MySQL through a
> setting in the php.ini but I haven't found it for oracle. I am in an
> environment wher
hen installing this in RedHat?
>
>
>Regards,
>
>Mike
>
>- Original Message -
>From: "Chris Hewitt" <[EMAIL PROTECTED]>
>Cc: "php" <[EMAIL PROTECTED]>
>Sent: Thursday, June 06, 2002 5:41 PM
>Subject: Re: [PHP] oracle again!!!
edHat
but still it doesnt work.
Is there something i need to consider when installing this in RedHat?
Regards,
Mike
- Original Message -
From: "Chris Hewitt" <[EMAIL PROTECTED]>
Cc: "php" <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 5:41 PM
Subject: Re:
Michael,
I have not used Oracle from PHP but I may be able to provide some
pointers/questions.
You do not say where the Oracle database is. If it is on the AIX
computer then to connect you will need the "system@tnsname" form of user
name to specify which connection in your tnsnames.ora file t
ot;Maurice
Kevenaar"To: [EMAIL PROTECTED]
Subject: [PHP]
Try to install the windows 2000 support tools and check width the Dependency
Walker the file and ll see witch file is missing!
--
Maurice
"Mauricio" <[EMAIL PROTECTED]> schreef in bericht
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi for all.
> I have php+apache+win2000+client oracle in my
At 25.03.2002 15:10, you wrote:
>
>
>hi.. is there any way to use the php oracle function to check to see if
>there are any records in the selected set before calling ora_fetch?
>ora_exec doesn't error if ther are no records, and ora_num_rows doesn't
>return the numbe of rows in the set.,
>
>than
On Thu, Mar 21, 2002 at 12:33:13PM +1100, Bradley Goldsmith wrote:
> Hi All,
>
> Is it possible to store/fetch blobs/clobs with the oracle (ORA not
> OCI8) functions?
no
tc
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
PHP has to be compiled with the oci8 support (built-in module). The oracle
extension is the "old one", the newest is oci8.
Regards,
Philippe
"Gkin" <[EMAIL PROTECTED]> a écrit dans le message news:
[EMAIL PROTECTED]
> I get "undefined function" when I use PHP/Oracle-functions like
ociconnect.
> F
there's the OCI* or ORA_* functions depending on the version of oracle
you're using.
-Original Message-
From: Phillip B. Bruce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 10:54 AM
To: PHP
Subject: [PHP] Oracle
Hi,
Has any one on this list worked with Oracle, Apache a
> I am under the (possibly flawed) assumption that you need to
> have the oracle client installed on the web server in order
> to use the oracle PHP module. Since I don't want to use the
> client on this machine at all, I would prefer to use the Perl
> DBI/DBD modules to connect to the data
.
- Original Message -
From: "Martin Marconcini" <[EMAIL PROTECTED]>
To: "'Marisol Díaz E.'" <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 4:11 PM
Subject: RE: [PHP] oracle
> Estas intentando declarar Environment Variables?
>
> No enten
> $lugar="D:\Oracle";
"D:\\Oracle" I suppose. The escape character!
Regards,
Martin Marconcini
www.marconcini.com.ar
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrat
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
you could move to a database that supports hot backups. postgresql perhaps ?
> -Original Message-
> From: Thies C. Arntzen [mailto:[EMAIL PROTECTED]]
> Sent: 10 July 2001 10:40
> To: Taylor, Stewart
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Oracle 8i + non pe
On Tue, Jul 10, 2001 at 09:32:32AM +0100, Taylor, Stewart wrote:
> Hello,
>
>
> I'm using
> OCI8 Revision 1.96
> Oracle Version 8.1
> Apache Apache/1.3.11
> Redhat Linux 6.2
> php 4.0.2
>
> I am connecting to my database using a non-persistant connection (ocilogin).
> My applications run wit
> // Define Oracle_Home and Oracle_Sid
> putenv("ORACLE_HOME=/opt/ORACLE/product");
> putenv("ORACLE_SID=MYDATA");
IIRC, Thies posted once that the Environment variables *must* be defined in
the environment, before PHP starts, for things to really work properly.
That's all he said (IIRC), so I d
need the
Oracle client libs installed.
- James
> -Original Message-
> From: Dunaway, Brian [mailto:[EMAIL PROTECTED]]
> Sent: June 26, 2001 7:25 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: [PHP] Oracle and PHP
>
>
> >I'm a newbie in PHP, what should I
; Zeev Suraski
Cc: [EMAIL PROTECTED]; '[EMAIL PROTECTED]'
Subject: Re: [PHP] Oracle Database keeps disconnecting - or something
On Fri, Jun 22, 2001 at 02:23:14PM +0100, Taylor, Stewart wrote:
> Hello,
>
> Just in case anyones got any ideas.
>
> I've been testing
>I'm a newbie in PHP, what should I do to connect to Oracle Database.
>Do I have to install a library to do that?
>Please anyone, help.
http://www.phpbuilder.com/manual/ref.oracle.php
I usually do something similiar to this.
(psuedo code follows):
// Define Oracle_Home and Oracle_Sid
putenv("O
On Mon, Jun 25, 2001 at 04:17:50PM +0300, Rouvas Stathis wrote:
> "Thies C. Arntzen" wrote:
> >
> > On Sun, Jun 24, 2001 at 09:50:05PM +0300, Rouvas Stathis wrote:
> > > "Thies C. Arntzen" wrote:
> > > >
> > > > On Fri, Jun 22, 2001 at 09:16:08PM +0300, Rouvas Stathis wrote:
> > > > > Do you expe
I can only say that you must have the Oracle extensions installed and
enabled in PHP.ini
Please post in text format next time!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list ad
"Thies C. Arntzen" wrote:
>
> On Sun, Jun 24, 2001 at 09:50:05PM +0300, Rouvas Stathis wrote:
> > "Thies C. Arntzen" wrote:
> > >
> > > On Fri, Jun 22, 2001 at 09:16:08PM +0300, Rouvas Stathis wrote:
> > > > Do you experience any other sort of problems other than those warnings?
> > > > I mean, i
On Sun, Jun 24, 2001 at 09:50:05PM +0300, Rouvas Stathis wrote:
> "Thies C. Arntzen" wrote:
> >
> > On Fri, Jun 22, 2001 at 09:16:08PM +0300, Rouvas Stathis wrote:
> > > Do you experience any other sort of problems other than those warnings?
> > > I mean, is anything wrong with the data? Normally
"Thies C. Arntzen" wrote:
>
> On Fri, Jun 22, 2001 at 09:16:08PM +0300, Rouvas Stathis wrote:
> > Do you experience any other sort of problems other than those warnings?
> > I mean, is anything wrong with the data? Normally, nothing should be
> > wrong.
> >
> > I have seen the same messages (espe
On Fri, Jun 22, 2001 at 09:16:08PM +0300, Rouvas Stathis wrote:
> Do you experience any other sort of problems other than those warnings?
> I mean, is anything wrong with the data? Normally, nothing should be
> wrong.
>
> I have seen the same messages (especially the "service handle not
> intitia
Do you experience any other sort of problems other than those warnings?
I mean, is anything wrong with the data? Normally, nothing should be
wrong.
I have seen the same messages (especially the "service handle not
intitialized" one) in my server too.
I have traced it to attemtps to close an alrea
On Fri, Jun 22, 2001 at 02:23:14PM +0100, Taylor, Stewart wrote:
> Hello,
>
> Just in case anyones got any ideas.
>
> I've been testing an application for a few weeks on a test server without
> any problems.
> After releasing it onto the live server, which is - according to the
> administrator
You can use ODBC as well.
Compile PHP with iODBC (http://www.iodbc.org) and you can use an ODBC driver
instead of the oci - this can bypass the Oracle client install in many
cases.
Best regards,
Andrew
Andrew Hill . Director Technology Evangelism
OpenL
At 08:42 AM 4/10/01 -0700, Dunaway, Brian wrote:
>I need to access a remote oracle database. What I mean is that the machine
>that is allowed access to the oracle database is not running php...I have
>access to the machine with the oracle access from my machine which is
>running php. Boy that
Hello Dominick,
Wednesday, April 04, 2001, 12:32:26 PM, you wrote:
DV> Maybe a bit offtopic, but is there an equivalent for the NVL function in
DV> Oracle for MySQL?
DV> NVL is a function that returns a given result when a value is null
>From MySQL manual:
IFNULL(expr1,expr2)
If expr1 is not
"Dominick Vansevenant" <[EMAIL PROTECTED]> wrote:
> Maybe a bit offtopic, but is there an equivalent for the NVL function in
> Oracle for MySQL?
>
> NVL is a function that returns a given result when a value is null
You do know there's a MySQL list, don't you? There's no such beast in
MySQL, but
On Mon, Mar 26, 2001 at 10:19:28AM +0800, Chien-pin Wang wrote:
>
> If you use sequence to generate your last_inserted_id, then you can always
> get that ID by calling
>
> SELECT sequence_name.CURRVAL
> FROM DUAL;
>
> within the same session.
re,
tc
>
> Chien
If you use sequence to generate your last_inserted_id, then you can always
get that ID by calling
SELECT sequence_name.CURRVAL
FROM DUAL;
within the same session.
Chien-pin
On Sun, 25 Mar 2001, almir wrote:
> is there a way to get last inserted id from oracle as
> mys
Thanks guys. I'm going to try and tackle this later today.
I was s happy just to get ODBC and oracle working yesterday.
I had to install the oracle 8.1.6 client.
Then i rolled back to php3.
Works fine.
I'm going to try the OCI stuff later, i'll letcha know.
-ken
-Original Message
From: Sam Masiello [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 5:13 PM
To: Brooks, Ken; [EMAIL PROTECTED]
Subject: RE: [PHP] Oracle, Win2000, Apache, OCI
It sounds like PHP was not compiled with the -with-oracle directive when the
configure script was run. This will co
It sounds like PHP was not compiled with the -with-oracle directive when the
configure script was run. This will compile in support for the PHP Oracle
functions.
HTH
Sam Masiello
Systems Analyst
Chek.Com
(716) 853-1362 x289
[EMAIL PROTECTED]
-Original Message-
From: Brooks, Ken [ma
-
From: Greig, Euan [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 04:25
To: Hardy Merrill; Rudolf Visagie
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] Oracle error messages
To suppress the error messages on a single command, you can put an @ in
front of it, eg:
@$conn=ora_plogon(...
-Original
To suppress the error messages on a single command, you can put an @ in front of it,
eg:
@$conn=ora_plogon(...
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 13:43
To: Rudolf Visagie
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Oracle error messages
Rudolf Visagie [[EMAIL PROTECTED]] wrote:
> Hi All,
>
> Does anybody have an idea how to stop the automatic error and warning
> messages from the Oracle data base being displayed on the screen. I want to
> do my own error message display but by the time I get the error message
> using OCIError it
Hi!
I mean running php in an oracle server!
thanks
>From: Adi Wibowo <[EMAIL PROTECTED]>
>To: kaab kaoutar <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: Re: [PHP] Oracle Web & Php
>Date: Thu, 15 Feb 2001 02:22:03 +0700 (GMT+0700)
>
&g
On Wed, 14 Feb 2001, kaab kaoutar wrote:
> Hi!
> thanks but i'm talking of oracle server! i mean instead of using pws or IIS
> or apache , may i use php with an oracle server
>
> thanks
Yes, you could access oracle server using PHP without any web server.
Just compile it as a CGI (without any
Hi!
thanks but i'm talking of oracle server! i mean instead of using pws or IIS
or apache , may i use php with an oracle server
thanks
>From: Christian Reiniger <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: Re: [PHP] Oracle Web &
On Wednesday 14 February 2001 11:44, kaab kaoutar wrote:
> is there a possiblily to use with in an Oracle Web server ?
RTFM (look at the manual, topic "Oracle functions")
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
Even idiots can handle computers, and many do.
--
PHP Gene
>Hi,
>
>My oracle sessions are getting full all the time...
>
>I use a OCILogoff at the end of my script...
>
>What could be the problem. I don¹t use a persistent logon.
Wild Guess:
You have transactions that are not getting committed nor rolled back?
--
Visit the Zend Store at http://www.zend.
> I found a list of some of the Oracle Functions at the main PHP site. Is
> this all there is?
Probably. Anything in particular you felt was missing?...
--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a li
""kaab kaoutar"" ...
> Hi!
> I'm using orcale8 and as long as oracle8 ocilogon does not work, i tried
the
> oracle function and i always get:
> for Ora_Logon("kaab@KKAnn", "kaab");
> connection failed could not resolve service name
Just try to reinstall PHP, and the Oracle 8 libraries for PHP
Can you connect to the DB with sql plus !!!
-Original Message-
From: kaab kaoutar [mailto:[EMAIL PROTECTED]]
Sent: woensdag 31 januari 2001 13:36
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject:[PHP] Oracle failed to connect
Hi!
I'm using orcale8 and as long a
1 - 100 of 102 matches
Mail list logo