Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 439 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
OCI and ORA-24315
Hi all,
I have a problem connecting to an oracle database using oci, I'm all out of options, so I hope you can help me..
I installed a WAMPserver on a Windows Server machine.
I've also downloaded instantclient_11_1, and made a PATH entry to this locatiion.
I also set the following in php.ini:
+;extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client+
extension=php_oci8_11g.dll ; Use with Oracle 11g Instant Client
if I run phpinfo() I see an OCI8 section.
This machine has OracleXE installed and is also in a network where an oracle11g db is installed.
I have the following code in index.php:
*<?php*
echo "Hello world!";
*$conn = oci_connect('hr', 'welcome', 'localhost/XE');*
*if (!$conn) {*
*$e = oci_error();*
trigger_error(htmlentities($e['message']), E_USER_ERROR);
*}*
*?>*
This results in:
Hello world!
*Warning: oci_connect() [function.oci-connect]: ORA-24315: illegal attribute type in C:\wamp\www\index.php on line 3*
Fatal error: ORA-24315: illegal attribute type in C:\wamp\www\index.php on line 7
I am pretty sure that my code is correct, It seems to me that oci functions per definition generate an ORA-24315 error.
Any help is welcome
Grtz Sake
I have a problem connecting to an oracle database using oci, I'm all out of options, so I hope you can help me..
I installed a WAMPserver on a Windows Server machine.
I've also downloaded instantclient_11_1, and made a PATH entry to this locatiion.
I also set the following in php.ini:
+;extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client+
extension=php_oci8_11g.dll ; Use with Oracle 11g Instant Client
if I run phpinfo() I see an OCI8 section.
This machine has OracleXE installed and is also in a network where an oracle11g db is installed.
I have the following code in index.php:
*<?php*
echo "Hello world!";
*$conn = oci_connect('hr', 'welcome', 'localhost/XE');*
*if (!$conn) {*
*$e = oci_error();*
trigger_error(htmlentities($e['message']), E_USER_ERROR);
*}*
*?>*
This results in:
Hello world!
*Warning: oci_connect() [function.oci-connect]: ORA-24315: illegal attribute type in C:\wamp\www\index.php on line 3*
Fatal error: ORA-24315: illegal attribute type in C:\wamp\www\index.php on line 7
I am pretty sure that my code is correct, It seems to me that oci functions per definition generate an ORA-24315 error.
Any help is welcome
Grtz Sake
Answers
-
<?php
echo "Hello world!";
$conn = oci_connect('hr', 'welcome', 'xe');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message']), E_USER_ERROR);
}
?>
Edited by: user6724455 on Feb 26, 2010 10:14 AM -
It sounds like a library mismatch issue. Having both a 10.2 (the XE
install) and the 11.1 libraries might be causing a clash. The error
seems rare. There was one old report of the problem in
http://bugs.php.net/bug.php?id=25123
I'd step back and make a decision about which client libraries you
want to use.
I expect the WAMP install uses a version of the OCI8 DLL that was
compiled with 10gR2 libraries. So it should run with the XE or the
11g instant client, because there is backward compatibility.
If PHP runs with the libraries in the XE install you can still connect
to your XE DB or your remote 11g DB.
Let us know what you find. -
Is there anyone to help on this?I having the similar warning and errors too. keep trying it for few days edi....
-
If you use a dependency checker, what libraries are being accessed?
-
I'm having similar issues.
If I install the a wamp on a separate machine with instant client, it seems to work, but not when the database and php script is on the same machine...
-
If you want help, you'll need to give a lot more detail about the environment, what you installed, and how you installed it.
This discussion has been closed.