\ud604\ub300\uc758 \ub370\uc774\ud130 \ucc98\ub9ac \ubc0f \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c\uc740 \ub2e4\uc591\ud55c \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc640 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\uc220\uc744 \uacb0\ud569\ud558\uc5ec \ub192\uc740 \ud6a8\uc728\uc131\uc744 \uc694\uad6c\ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 Oracle Pro*C<\/strong>\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2e4\uc2dc\uac04 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\uace0, C#<\/strong> \uc5b8\uc5b4\ub97c \ud65c\uc6a9\ud558\uc5ec \uc774\ud6c4 \ub370\uc774\ud130 \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \ub2e4\ub8f0 \uac83\uc785\ub2c8\ub2e4. Pro*C\ub294 C \uc5b8\uc5b4\uc640 Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud1b5\ud569\ud558\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub85c, SQL \ubb38\uc744 C \ucf54\ub4dc \ub0b4\uc5d0\uc11c \uc9c1\uc811 \uc2e4\ud589\ud560 \uc218 \uc788\ub294 \uc7a5\uc810\uc744 \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc2dc\uc2a4\ud15c\uc740 \ub370\uc774\ud130 \uc218\uc9d1 \ubc0f \ubaa8\ub2c8\ud130\ub9c1 \uadc0\ud558\uc758 \ube44\uc988\ub2c8\uc2a4 \uacb0\uc815\uc5d0 \uadc0\uc911\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n \uc2dc\uc2a4\ud15c \uad6c\ucd95\uc740 \uba3c\uc800 \uc804\uccb4\uc801\uc778 \uc544\ud0a4\ud14d\ucc98\ub97c \uc124\uacc4\ud558\ub294 \uac83\uc73c\ub85c \uc2dc\uc791\ud569\ub2c8\ub2e4. \ubcf8 \uc2dc\uc2a4\ud15c\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \uc8fc\uc694 \uad6c\uc131 \uc694\uc18c\ub85c \uc774\ub8e8\uc5b4\uc9d1\ub2c8\ub2e4:<\/p>\n \ub370\uc774\ud130 \uc218\uc9d1 \ubaa8\ub4c8\uc740 Oracle Pro*C\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc2e4\uc2dc\uac04\uc73c\ub85c \uc218\uc9d1\ud558\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. Pro*C\ub294 SQL \ucf54\ub4dc\uc640 C \ucf54\ub4dc\uac00 \ud63c\ud569\ub41c \ud615\ud0dc\ub85c \uc791\uc131\ub418\uba70, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \ud1b5\uc2e0\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ubaa8\ub4c8\uc740 \uc8fc\uae30\uc801\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc9c8\uc758\ud558\uc5ec \uc0c8\ub85c \ub4e4\uc5b4\uc628 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uace0, \uc774\ub97c \uc9c0\ud45c\ud654\ud558\uc5ec \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c\uc5d0 \uc804\ub2ec\ud569\ub2c8\ub2e4.<\/p>\n \uc218\uc9d1\ub41c \ub370\uc774\ud130\ub294 Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub370\uc774\ud130\uc758 \ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud558\uace0, \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uba70, \ucffc\ub9ac\ub97c \ud1b5\ud55c \ub370\uc774\ud130 \uc811\uadfc\uc131\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8\ub294 \uc218\uc9d1\ud560 \ub370\uc774\ud130\uc758 \uc885\ub958\uc5d0 \ub530\ub77c \uc124\uacc4\ub418\uba70, \ub370\uc774\ud130\uc758 \ud615\ud0dc\uc5d0 \ub530\ub77c \ud14c\uc774\ube14\uc744 \uc815\uc758\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n \uc2e4\uc2dc\uac04 \ubaa8\ub2c8\ud130\ub9c1 \uc778\ud130\ud398\uc774\uc2a4\ub294 C#\uc744 \uc774\uc6a9\ud558\uc5ec GUI \ud615\ud0dc\ub85c \uad6c\ud604\ub429\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\ub294 \uc774 \uc778\ud130\ud398\uc774\uc2a4\ub97c \ud1b5\ud574 \uc218\uc9d1\ub41c \ub370\uc774\ud130\ub97c \uc2e4\uc2dc\uac04\uc73c\ub85c \ud655\uc778\ud558\uace0, \ud544\uc694\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1 \ubc0f \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc778\ud130\ud398\uc774\uc2a4\ub294 \uc0ac\uc6a9\uc790 \uce5c\ud654\uc801\uc774\uba70, \uc9c1\uad00\uc801\uc778 \ub514\uc790\uc778\uc744 \uc911\uc694\uc2dc\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n Pro*C\ub97c \uc774\uc6a9\ud55c \ub370\uc774\ud130 \uc218\uc9d1 \ubaa8\ub4c8\uc744 \ub9cc\ub4e4\uae30 \uc704\ud574\uc11c\ub294 \uba3c\uc800 Pro*C \ud658\uacbd\uc744 \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4. \uc544\ub798\uc758 \uc808\ucc28\ub97c \ub530\ub77c Pro*C\ub97c \uc124\uc815\ud558\uace0 \uccab \ubc88\uc9f8 \ubaa8\ub4c8\uc744 \uac1c\ubc1c\ud569\ub2c8\ub2e4.<\/p>\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc2e4\uc2dc\uac04 \ub370\uc774\ud130\ub97c \uc218\uc9d1\ud558\uae30 \uc704\ud55c Pro*C \ucf54\ub4dc \uc0d8\ud50c\uc744 \uc544\ub798\uc5d0 \uc81c\uacf5\ud569\ub2c8\ub2e4:<\/p>\n \uc704\uc758 \uc608\uc81c\uc5d0\uc11c\ub294 \uc7ac\uace0 \ud14c\uc774\ube14\uc5d0\uc11c \uc0c1\ud0dc\uac00 ‘available’\uc778 \ud56d\ubaa9\uc758 \uc218\ub7c9\uc744 \uc870\ud68c\ud558\ub294 SQL \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ub97c \uc8fc\uae30\uc801\uc73c\ub85c \uac00\uc838\uc640\uc11c \uc2dc\uc2a4\ud15c\uc5d0 \uc804\uc1a1\ud558\ub294 \ubd80\ubd84\uc740 \uc2e4\uc81c \uad6c\ud604 \uc2dc \ud544\uc694\ud55c \ubd80\ubd84\uc5d0 \ub9de\uac8c \uc218\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n \uc774\uc81c C#\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubaa8\ub2c8\ud130\ub9c1 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uac1c\ubc1c\ud560 \ucc28\ub840\uc785\ub2c8\ub2e4. C#\uc740 \ub2e4\uc591\ud55c GUI \ud504\ub808\uc784\uc6cc\ud06c\ub97c \uc9c0\uc6d0\ud558\uba70, \uc5ec\uae30\uc11c\ub294 WinForms\ub97c \uc774\uc6a9\ud558\uc5ec UI\ub97c \uc791\uc131\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n \uc544\ub798\ub294 \uae30\ubcf8\uc801\uc778 \ub370\uc774\ud130 \ubaa8\ub2c8\ud130\ub9c1 \uc778\ud130\ud398\uc774\uc2a4\uc758 \ucf54\ub4dc \uc608\uc81c\uc785\ub2c8\ub2e4:<\/p>\n \uc704 \ucf54\ub4dc\ub294 \ub9e4\uc6b0 \uac04\ub2e8\ud55c \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c\uc758 GUI\ub97c \uc0dd\uc131\ud558\uba70, \ubc84\ud2bc \ud074\ub9ad \uc2dc \ub370\uc774\ud130\ub97c \uc0c8\ub85c \uace0\uccd0\uc11c \ud14d\uc2a4\ud2b8 \ubc15\uc2a4\uc5d0 \ud45c\uc2dc\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \uc870\ud68c \ud568\uc218\ub294 \uc2e4\uc81c \uc218\uc9d1\ud55c \ub370\uc774\ud130\ub97c \ud3ec\ud568\ud558\ub3c4\ub85d \uad6c\ud604\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n \uc774\uc81c Pro*C\uc640 C# \ubaa8\ub4c8\uc774 \uc900\ube44\ub418\uc5c8\uc73c\ubbc0\ub85c, \ub450 \uc2dc\uc2a4\ud15c \uac04\uc758 \uc5f0\ub3d9\uc744 \ud14c\uc2a4\ud2b8\ud574\uc57c \ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \uc218\uc9d1 \ubaa8\ub4c8\uc740 \uc8fc\uae30\uc801\uc73c\ub85c \uc218\uc9d1\ub41c \ub370\uc774\ud130\ub97c \ud30c\uc77c\uc774\ub098 \uc18c\ucf13 \ub4f1\uc744 \ud1b5\ud574 C# \ubaa8\ub4c8\uc5d0 \uc804\uc1a1\ud558\uac8c \ub429\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574 IPC(Inter-Process Communication) \ub610\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc774\uc6a9\ud55c \ud1b5\uc2e0\uc744 \uace0\ub824\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n \uc774\ubc88 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 Oracle Pro*C\uc640 C#\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uc600\uc2b5\ub2c8\ub2e4. Pro*C\ub294 \uac15\ub825\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uae30\ub2a5\uc744 \uc81c\uacf5\ud558\uba70, C#\uc740 \uc0ac\uc6a9\uc790 \uce5c\ud654\uc801\uc778 \uc778\ud130\ud398\uc774\uc2a4\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ub97c \uc2dc\uac01\uc801\uc73c\ub85c \ud45c\ud604\ud558\ub294 \ub370 \ub6f0\uc5b4\ub09c \uc720\uc6a9\uc131\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub450 \uae30\uc220\uc758 \uc870\ud569\uc740 \ud6a8\uc728\uc801\uc774\uace0 \uc2e4\uc2dc\uac04\uc73c\ub85c \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\uba70, \ube44\uc988\ub2c8\uc2a4 \uacb0\uc815\uc744 \uc9c0\uc6d0\ud558\ub294 \uc720\uc6a9\ud55c \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud5a5\ud6c4 \uc2dc\uc2a4\ud15c\uc758 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c \ub354\uc6b1 \ubc1c\uc804\ub41c \uae30\ub2a5\uc744 \ucd94\uac00\ud558\uc5ec \ud65c\uc6a9\ud560 \uc218 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4.<\/p>\n \uc774\uc640 \uac19\uc740 \uc2dc\uc2a4\ud15c \uad6c\ucd95\uc744 \ud1b5\ud574 \uadc0\ud558\ub294 \ubcf4\ub2e4 \ud6a8\uc728\uc801\uc774\uace0 \uc2e4\uc2dc\uac04\uc73c\ub85c \ubc18\uc751\ud558\ub294 \ub370\uc774\ud130 \uad00\ub9ac \uc194\ub8e8\uc158\uc744 \uc190\uc5d0 \ub123\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uae30\uc220\uc758 \uc9c4\ud654\ub97c \ud1b5\ud574 \uac01\uc885 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \ud1b5\ucc30\uc744 \uc5bb\uace0, \uc774\ub7ec\ud55c \ub370\uc774\ud130\ub294 \uadc0\ud558\uc758 \ube44\uc988\ub2c8\uc2a4 \uacb0\uc815 \uacfc\uc815\uc5d0\uc11c \ub354\uc6b1 \uac00\uce58 \uc788\ub294 \uc790\uc0b0\uc774 \ub420 \uac83\uc785\ub2c8\ub2e4.<\/p>\n <\/body><\/p>\n","protected":false},"excerpt":{"rendered":"1. \uc2dc\uc2a4\ud15c \uc124\uacc4<\/h2>\n
\n
1.1 \ub370\uc774\ud130 \uc218\uc9d1 \ubaa8\ub4c8 (Pro*C)<\/h3>\n
1.2 \ub370\uc774\ud130 \uc800\uc7a5\uc18c (Oracle DB)<\/h3>\n
1.3 \uc2e4\uc2dc\uac04 \ubaa8\ub2c8\ud130\ub9c1 \uc778\ud130\ud398\uc774\uc2a4 (C#)<\/h3>\n
2. Pro*C\ub97c \uc774\uc6a9\ud55c \ub370\uc774\ud130 \uc218\uc9d1 \ubaa8\ub4c8 \uac1c\ubc1c<\/h2>\n
2.1 Pro*C \uac1c\ubc1c \ud658\uacbd \uc124\uc815<\/h3>\n
\n
2.2 Pro*C \uc0d8\ud50c \ucf54\ub4dc<\/h3>\n
\n#include <stdio.h>\n#include <sqlca.h>\n#include <sqlcpr.h>\n\nEXEC SQL BEGIN DECLARE SECTION;\n char username[30];\n char password[30];\n char query[100];\n int quantity;\nEXEC SQL END DECLARE SECTION;\n\nint main() {\n \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0\n EXEC SQL CONNECT :username IDENTIFIED BY :password;\n\n \/\/ SQL \ucffc\ub9ac \uc900\ube44\n snprintf(query, sizeof(query), \"SELECT quantity FROM inventory WHERE status = 'available'\");\n\n \/\/ SQL \uc2e4\ud589\n EXEC SQL DECLARE c1 CURSOR FOR SELECT quantity FROM inventory WHERE status = 'available';\n EXEC SQL OPEN c1;\n\n \/\/ \ub370\uc774\ud130 \uac00\uc838\uc624\uae30\n while (1) {\n EXEC SQL FETCH c1 INTO :quantity;\n if (sqlca.sqlcode == 100) break; \/\/ \ub354 \uc774\uc0c1 \ub370\uc774\ud130 \uc5c6\uc74c\n printf(\"Available Quantity: %d\\n\", quantity);\n \n \/\/ \uc5ec\uae30\uc11c \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c\uc73c\ub85c \ub370\uc774\ud130 \uc804\uc1a1\n \/\/ send_to_monitoring_system(quantity);\n }\n\n \/\/ \ucee4\uc11c \ub2eb\uae30\n EXEC SQL CLOSE c1;\n\n \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uc885\ub8cc\n EXEC SQL COMMIT WORK;\n EXEC SQL DISCONNECT;\n\n return 0;\n}\n<\/code><\/pre>\n3. C# \uc2e4\uc2dc\uac04 \ubaa8\ub2c8\ud130\ub9c1 \uc778\ud130\ud398\uc774\uc2a4 \uac1c\ubc1c<\/h2>\n
3.1 C# \uac1c\ubc1c \ud658\uacbd \uc124\uc815<\/h3>\n
\n
3.2 C# \uc0d8\ud50c \uc778\ud130\ud398\uc774\uc2a4 \ucf54\ub4dc<\/h3>\n
\nusing System;\nusing System.Windows.Forms;\n\npublic class MonitoringForm : Form\n{\n private TextBox dataTextBox;\n private Button refreshButton;\n\n public MonitoringForm()\n {\n dataTextBox = new TextBox() { Multiline = true, Dock = DockStyle.Fill };\n refreshButton = new Button() { Text = \"Refresh Data\", Dock = DockStyle.Bottom };\n\n refreshButton.Click += new EventHandler(RefreshButton_Click);\n this.Controls.Add(dataTextBox);\n this.Controls.Add(refreshButton);\n this.Text = \"Real-time Data Monitoring\";\n }\n\n private void RefreshButton_Click(object sender, EventArgs e)\n {\n \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ucd5c\uc2e0 \ub370\uc774\ud130 \uac00\uc838\uc624\uae30\n \/\/ var data = GetDataFromDatabase();\n \/\/ dataTextBox.Text = string.Join(Environment.NewLine, data);\n }\n\n [STAThread]\n public static void Main()\n {\n Application.EnableVisualStyles();\n Application.Run(new MonitoringForm());\n }\n}\n<\/code><\/pre>\n4. \uc2dc\uc2a4\ud15c \ud1b5\ud569\uacfc \ud14c\uc2a4\ud2b8<\/h2>\n
4.1 \uc2dc\uc2a4\ud15c \ud1b5\ud569 \ubc29\ubc95<\/h3>\n
\n
5. \uacb0\ub860<\/h2>\n