Roberto Mansfield wrote:
Mikey wrote:
Roberto Mansfield wrote:
Hi Mikey,
OCI doesn't directly support the XMLtype so you need to convert to
string (if < 4k) or clob before retrieving. Use:
select xml_metadata.getClobVal() ... OR
select xml_metadata.getStringVal() ...
If converting to clob, y
Mikey wrote:
> Roberto Mansfield wrote:
>> Hi Mikey,
>>
>> OCI doesn't directly support the XMLtype so you need to convert to
>> string (if < 4k) or clob before retrieving. Use:
>>
>> select xml_metadata.getClobVal() ... OR
>> select xml_metadata.getStringVal() ...
>>
>> If converting to clob, you
Mikey wrote:
Roberto Mansfield wrote:
Hi Mikey,
OCI doesn't directly support the XMLtype so you need to convert to
string (if < 4k) or clob before retrieving. Use:
select xml_metadata.getClobVal() ... OR
select xml_metadata.getStringVal() ...
If converting to clob, you get a clob object back
Roberto Mansfield wrote:
Hi Mikey,
OCI doesn't directly support the XMLtype so you need to convert to
string (if < 4k) or clob before retrieving. Use:
select xml_metadata.getClobVal() ... OR
select xml_metadata.getStringVal() ...
If converting to clob, you get a clob object back and you'll nee
Hi Mikey,
OCI doesn't directly support the XMLtype so you need to convert to
string (if < 4k) or clob before retrieving. Use:
select xml_metadata.getClobVal() ... OR
select xml_metadata.getStringVal() ...
If converting to clob, you get a clob object back and you'll need to run
the load() method
D A GERM <[EMAIL PROTECTED]> writes:
> Is there an rpm to install the oracle compnents for version 4.3.4 php?
I don't think so. The way to do it is to download the SRPM for the
php from your vendor's web site, do a rpm -ivh php-blah.srpm. This
will give you a spec file in the /usr/src/SOMETHING
To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 19 October 2004 13:19, David Robley wrote:
> On Tue, 19 Oct 2004 16:20, Syed wrote:
>
> > Hi All,
> >
> > will anybody tell me how to connect oracle database using php
> > scri
On Tue, 19 Oct 2004 16:20, Syed wrote:
> Hi All,
>
> will anybody tell me how to connect oracle database using php script.
>
> Thanx
>
> Syed
Start at http://php.net/oracle
--
David Robley
If winning isn't important then why keep score?
--
PHP General Mailing List (http://www.php.net/)
To
>Hi,
>This really isn't a PHP issue..sorry.
>
>I'm having a nightmare with Oracle 8i (pos!). I'm writing common SQL
>which works for MSSQL 2K and seems correct for Oracle... but keeps
>giving me a Error.. ORA-00933 SQL command not properly ended on the
>following query...
>
>SELECT grp.grpdescrip
>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 where we have about 10 users that connect to oracle from
>each of 10
> Which are the environment variables? (i.e. ORACLE_SID, ORACLE_HOME, etc)
>I've using this kind of code, but it doesn't connect me to the server.
>putenv("ORACLE_HOME=C:\Program Files\Ora81"); <-- Is this the home
directory?
> putenv("ORACLE_SID=SID");
Look in the windows registry to find what t
Thursday, March 22, 2001 11:16 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too
long]
I got it.
I had the table name listed as aradmin_eps_service_instructions
when in fact it should have been aradmin.eps_service_instructions (with the
dot).
I d
At 10:16 AM 3/22/01 -0500, Brooks, Ken wrote:
>I got it.
ah. :) good
>I had the table name listed as aradmin_eps_service_instructions
>when in fact it should have been aradmin.eps_service_instructions (with
>the dot).
>
>I did not know this because all of the tables I had seen linked to
At 09:52 AM 3/22/01 -0500, Brooks, Ken wrote:
>Lets start at the basics.
>
>What is the easiest way to *make sure* that i am connecting to that oracle
>db?
>
>Anyway I can just list the tables, or something.
>odbc_tables or something like that?..
To get a list of the tables, you could:
SE
have priveledge to even
view) uses the .
Whee!
-Original Message-
From: Brooks, Ken [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 9:52 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too
long]
Lets start at the basics.
What is the ea
, 2001 9:32 AM
To: [EMAIL PROTECTED]
Subject: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long]
I only mentioned the part about the access, just to prove that I know i have
a select
statement working with an ODBC source.
I know that I am connecting to the Oracle database, because if
riginal Message-
From: Greig, Euan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 9:21 AM
To: Brooks, Ken
Cc: [EMAIL PROTECTED]
Subject: [PHP] RE: Oracle ODBC sql [ORA-00972: identifier is too long]
I haven't used Oracle with ODBC, but nothing leaps out at me from your code.
S
I haven't used Oracle with ODBC, but nothing leaps out at me from your code. Some
comments/ideas:
The full meaning of error 0972 is that the name of a schema object (table, view,
username etc) is too long (longer than 30 characters, maybe more for Oracle 8). The
query statement you are using
18 matches
Mail list logo
