Re: Oracle OCI8 and rowid

Try converting the ROWID to a character string first: select rowidtochar(rowid), field1 from table1 Now you can echo it out or do whatever you would do with a character string. There's also the Oracle function CHARTOROWID to go the other way around. signup wrote: > > On Mon, Jan 22, 2001 at 01:38:22PM -0800, signup wrote: > > Hello, > > does anyone know how to write te result of the following SQL statement (I have problems > > with rowid): > > > > select rowid, field1 from table1 > > rowid is an opaque datatype in php. you cannot "output" it > but only use it for further processing using ocibindbyname(). > > tc > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- ------------------------------------------------------ Harry N. C. Ng Office of Information Services Air Resources Board 1001 I Street E-mail: hng@arb.ca.gov P.O. Box 2815 Phone: 916-322-6201 Sacramento, CA 95812 FAX: 916-327-0640