diff -rupN mantisbt-1.1.7/core/email_queue_api.php mantisbt-1.1.7_zce/core/email_queue_api.php
--- mantisbt-1.1.7/core/email_queue_api.php	2009-04-20 09:14:00.000000000 +0200
+++ mantisbt-1.1.7_zce/core/email_queue_api.php	2009-05-13 11:16:17.053875000 +0200
@@ -62,6 +62,7 @@
 
 	# --------------------
 	function email_queue_add( $p_email_data ) {
+		global $g_db;
 		$t_email_data = email_queue_prepare_db( $p_email_data );
 
 		# email cannot be blank
@@ -89,22 +90,44 @@
 		$c_body = $t_email_data->body;
 		$c_metadata = serialize( $t_email_data->metadata );
 
-		$query = "INSERT INTO $t_email_table
-				    ( email,
-				      subject,
-					  body,
-					  submitted,
-					  metadata)
-				  VALUES
-				    ( '$c_email',
-				      '$c_subject',
-				      '$c_body',
-					  " . db_now() . ",
-					  '$c_metadata'
-					)";
-		db_query( $query );
-
-		return db_insert_id( $t_email_table );
+		$t_db_type = config_get( 'db_type' );
+		if($t_db_type == 'oci8') {
+			$query = "INSERT INTO $t_email_table
+					    ( email,
+					      subject,
+						  body,
+						  submitted,
+						  metadata)
+					  VALUES
+					    ( '$c_email',
+					      '$c_subject',
+					      empty_clob(),
+						  " . db_now() . ",
+						  '$c_metadata'
+						)";
+			db_query( $query );
+
+			$id = db_insert_id($t_email_table);
+			$g_db->UpdateClob($t_email_table,'body', $c_body, "EMAIL_ID = $id");
+		} else {
+			$query = "INSERT INTO $t_email_table
+					    ( email,
+					      subject,
+						  body,
+						  submitted,
+						  metadata)
+					  VALUES
+					    ( '$c_email',
+					      '$c_subject',
+					      '$c_body',
+						  " . db_now() . ",
+						  '$c_metadata'
+						)";
+			db_query( $query );
+			$id = db_insert_id( $t_email_table );
+		}
+ 
+		return $id;
 	}
 
 	# --------------------
diff -rupN mantisbt-1.1.7/core/file_api.php mantisbt-1.1.7_zce/core/file_api.php
--- mantisbt-1.1.7/core/file_api.php	2009-04-20 09:14:00.000000000 +0200
+++ mantisbt-1.1.7_zce/core/file_api.php	2009-05-13 11:17:27.757000000 +0200
@@ -571,6 +571,7 @@ document.getElementById( span ).style.di
 
 	# --------------------
 	function file_add( $p_bug_id, $p_tmp_file, $p_file_name, $p_file_type='', $p_table = 'bug', $p_file_error = 0, $p_title = '', $p_desc = '' ) {
+		global $g_db;
 
 		if ( php_version_at_least( '4.2.0' ) ) {
 		    switch ( (int) $p_file_error ) {
@@ -678,11 +679,22 @@ document.getElementById( span ).style.di
 		$t_file_table	= config_get( 'mantis_' . $p_table . '_file_table' );
 		$c_id = ( 'bug' == $p_table ) ? $c_bug_id : $c_project_id;
 					
-		$query = "INSERT INTO $t_file_table
-						(" . $p_table . "_id, title, description, diskfile, filename, folder, filesize, file_type, date_added, content)
-					  VALUES
-						($c_id, '$c_title', '$c_desc', '$c_disk_file_name', '$c_new_file_name', '$c_file_path', $c_file_size, '$c_file_type', " . db_now() .", $c_content)";
-		db_query( $query );
+		$t_db_type = config_get( 'db_type' );
+		if($t_db_type == 'oci8') {
+			$query = "INSERT INTO $t_file_table
+							(" . $p_table . "_id, title, description, diskfile, filename, folder, filesize, file_type, date_added, content)
+						  VALUES
+							($c_id, '$c_title', '$c_desc', '$c_disk_file_name', '$c_new_file_name', '$c_file_path', $c_file_size, '$c_file_type', " . db_now() .", empty_blob())";
+			db_query( $query );
+			$id = db_insert_id($t_file_table);
+			$g_db->UpdateBlobFile($t_file_table,'content', $p_tmp_file, "ID = $id",'BLOB');
+		} else {
+			$query = "INSERT INTO $t_file_table
+							(" . $p_table . "_id, title, description, diskfile, filename, folder, filesize, file_type, date_added, content)
+						  VALUES
+							($c_id, '$c_title', '$c_desc', '$c_disk_file_name', '$c_new_file_name', '$c_file_path', $c_file_size, '$c_file_type', " . db_now() .", $c_content)";
+			db_query( $query );
+		}
 
 		if ( 'bug' == $p_table ) {
 			# updated the last_updated date