so, I apologize for the truncated post...)
So, I'm not sure that I completely understand how a CLOB works in
Oracle, although I believe it acts as a pointer to the actual data,
which resides.... somewhere. I have the need to expand beyond the
4000-character limit in Oracle's VARCHAR2 field type, and believe CLOBs
are the way to go. However, I'm not accessing Oracle via the standard
PHP Oracle 8i calls or ADODB or PEAR or whatnot -- I'm using a DB
abstraction script that takes pretty standard SQL and parses it for
Oracle.*
So my question is a two-parter:
1) Can someone adequately explain the oracle CLOB field type to me
(Google was not my friend here), and
2) Assuming the SQL I'm using to access the data in the Oracle db looks
like MySQL SQL*, how would I access the CLOB data?
Thanks for the assist.
-Bob
* a typical Oracle query through the abstraction script looks like
this:
$foo = $db->get_row("select * from table_name where id = '$id'");
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
SPONSORED LINKS
| Php mysql | Job postings |
YAHOO! GROUPS LINKS
- Visit your group "php-list" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
