From 667420c66b32e2200fd15c57e108a35d40499d48 Mon Sep 17 00:00:00 2001
From: Bernard Normier <bernard@zeroc.com>
Date: Thu, 10 Aug 2006 18:36:30 +0000
Subject: Oracle Pro*C demo

---
 cpp/demo/Database/Oracle/proc/Util.pc | 59 +++++++++++++++++++++++++++++++++++
 1 file changed, 59 insertions(+)
 create mode 100644 cpp/demo/Database/Oracle/proc/Util.pc

(limited to 'cpp/demo/Database/Oracle/proc/Util.pc')

diff --git a/cpp/demo/Database/Oracle/proc/Util.pc b/cpp/demo/Database/Oracle/proc/Util.pc
new file mode 100644
index 00000000000..2c30064995c
--- /dev/null
+++ b/cpp/demo/Database/Oracle/proc/Util.pc
@@ -0,0 +1,59 @@
+// **********************************************************************
+//
+// Copyright (c) 2003-2006 ZeroC, Inc. All rights reserved.
+//
+// This copy of Ice is licensed to you under the terms described in the
+// ICE_LICENSE file included in this distribution.
+//
+// **********************************************************************
+
+#include <Ice/Ice.h>
+#include <HR.h>
+#include <Util.h>
+#include <sstream>
+
+using namespace std;
+
+void handleSqlError(const struct sqlca& badca, sql_context sc)
+{
+    //
+    // First rollback transaction
+    //
+    EXEC SQL BEGIN DECLARE SECTION;
+    sql_context ctx = sc;
+    EXEC SQL END DECLARE SECTION;
+    
+    struct sqlca sqlca;
+    EXEC SQL CONTEXT USE :ctx;
+    EXEC SQL ROLLBACK;
+
+    if(badca.sqlcode > 0)
+    {
+	throw Ice::ObjectNotExistException(__FILE__, __LINE__);
+    }
+    else
+    {
+	string msg(badca.sqlerrm.sqlerrmc, badca.sqlerrm.sqlerrml);
+	throw HR::SqlException(msg);
+    }
+}
+
+int decodeName(const string& name)
+{
+    int result = 0;
+    istringstream is(name);
+    is >> result;
+    if(!is || !is.eof())
+    {
+	cerr << "Unable to decode " << name << endl;
+	throw Ice::ObjectNotExistException(__FILE__, __LINE__);
+    }
+    return result;
+}
+
+string encodeName(int n)
+{
+    ostringstream os;
+    os << n;
+    return os.str();
+}
-- 
cgit v1.2.3