I'm just wondering if anyone knows of a way to detect a if a field selected
from an Oracle database is a BLOB? (using CFMX 6.1) My problem is that we are
trying to migrate a database over to MySQL from Oracle and due to a lack of
inexpensive migration tools (I'd be perfectly happy to be proven
Oracle BLOBS are binary, not text - they are going to break if you put
them in a text field. Are you sure you don't mean CLOBs?
On 8/11/06, Lars Gronholt [EMAIL PROTECTED] wrote:
I'm just wondering if anyone knows of a way to detect a if a field selected
from an Oracle database is a BLOB?
How'd I make that mistake?? you're right of course - they are indeed CLOBs.
Oracle BLOBS are binary, not text - they are going to break if you put
them in a text field. Are you sure you don't mean CLOBs?
On 8/11/06, Lars Gronholt [EMAIL PROTECTED] wrote:
For the clobs, your best bet is to use a cfqueryparam on the insert.
Of course, that screws up the idea of using cfinsert. You can figure
out what the fields were though with a little data dictionary query.
cfquery name=gettabs
select table_name, column_name, data_type, data_length,
This looks cool too (for oracle):
select dbms_metadata.get_ddl('TABLE','THE_TABLE_NAME') from dual
:D
On 8/11/06, Deanna Schneider [EMAIL PROTECTED] wrote:
For the clobs, your best bet is to use a cfqueryparam on the insert.
Of course, that screws up the idea of using cfinsert. You can figure
Thanks all :)
think either of those will sort my problem - will confirm on Monday!
This looks cool too (for oracle):
select dbms_metadata.get_ddl('TABLE','THE_TABLE_NAME') from dual
:D
On 8/11/06, Deanna Schneider [EMAIL PROTECTED] wrote:
Just FYI - what Denny's solution is going to give you is the create
table statement for a specific table. What my solution is going to
give you is all the tables, columns and column types for all the
tables in your Oracle schema. With Denny's solution you'd have to
parse through the text to get
On 8/11/06, Deanna Schneider [EMAIL PROTECTED] wrote:
Just FYI - what Denny's solution is going to give you is the create
table statement for a specific table. What my solution is going to
give you is all the tables, columns and column types for all the
tables in your Oracle schema. With
8 matches
Mail list logo