Menu

#4 How to insert more than 1 RAW Column

open
nobody
None
5
2005-02-28
2005-02-28
No

I am evaluating the OTL for a new application.
Many tables in our Oracle-DB are containing more than
one RAW column. (NOT LONG RAW)
Can you please give me a hint how to insert 2 or more
RAW-Columns.
I've tried the following code

>>>>>
otl_stream o( 1, "INSERT INTO PCCDBA.OTL_EVENT
(OID_KEY, OID, EVENT_OID, EVENT_PARAM ) VALUES( "
":oid_key<int> ,:oid< raw_long > ,
:event_oid< raw_long >, :event_paramm<char[128]> )", rDB );

const OID_t& guid( pDBSession->guid() );

otl_long_string guid_long( &guid[0],
guid.size(), guid.size() );
guid_long.set_len( 16 );
otl_long_string event_long( &eventID[0],
eventID.size(), eventID.size() );
event_long.set_len( 16 );

otl_value< std::string > param( rParam );

o << pDBSession->id()
<< guid_long
<< event_long
<< param;
<<<<<<<:
OTL throws an exception :
ORA-01461: Ein LONG-Wert kann nur zur Einfłgung in eine
LONG-Spalte gebunden werden

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.