#副標= Visual Studio.Net與.NET Framework CLR 整合Oracle 10gR2資料庫 #大標=使用.NET CLR整合Oracle 10gR2資料庫 ========程式======= 程式1 Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types Public Class clsfnScalar Public Shared Function Add99(ByVal val As Integer) As String ' 處理純量函數 Return CStr(val + 99) End Function End Class ========程式======= ========程式======= 程式2 c:\>SQLPLUS hr/hr SQL> SELECT add99(1) FROM dual; ADD99(1) ------------------------------------ 100 SQL> ========程式======= ========程式======= 程式3 SQL>BEGIN 2 SENDDATAFILE(119); 3 END; 4 / PL/SQL procedure successfully ========程式=======