Posted by Mladen Gogala on 10/16/82 11:53

On Wed, 19 Jul 2006 16:29:38 -0700, sam.lumbroso wrote:

> I have the following object type created in Oracle (OCI8):
>
> create or replace type address as object
> (
> address VARCHAR2(80),
> city VARCHAR2(80),
> state VARCHAR2(20),
> zip VARCHAR2(10)
> )
>
> and I have the following table created:
>
> create table test
> (
> address ADDRESS
> )
>
> and when I run this:
>
> $sql = "SELECT * FROM test";
> $s = ociparse(O_CON, $sql);
> ociexecute($s);
>
> I get this error:
>
> Warning: ociexecute(): OCIDefineByPos: ORA-00932: inconsistent
> datatypes in /home/httpd/html/stats/test.php on line (the ociexecute
> line)
>
> Can I not select custom types from Oracle or is there something else I
> have to do?

Sam, I haven't ever done named types, but I would try using OCI8 instead
of using OCI and I would try oci_define_by_name with OCI_NTY bind type.
I'm not sure that OCI supports object type bindings and I am sure that OCI
is deprecated.

--
http://www.mgogala.com

• Next in forum: Need to install Tidy with PHP 5.0.4
• Prev in forum: Re: mysql_connect()
• Thread view: Re: Problem with Oracle selecting object types

[Reply to this message]