Hello every one!
I want to create a BLL(Business Logic Layer) in my project, but i need some help.
I search here
http://msdn.microsoft.com/en-us/library/aa581780.aspx[
^]
for same information, and i get it.
My big problem, is that my database is in Oracle, and i need to use(PL/SQL)
I study Pl/Sql, but is tonally different do declaire things in VB.
example: VB.BLL (DTBase Local)
Public Class Client
Public Function ME()
Return DAL.ExecuteScalar("SELECT a.name, a.id FROM user a where name = 'S000'", Nothing)
End Function
End Class
example: VB.Oracle.BLL (DTbase Server)
Declare Function vbdf Lib "" Alias "" (ByVal a As Integer) As Boolean
...
in pl/sql exemple:
DECLARE
CURSOR c_empl IS
SELECT pd.emplid
, pd.empl_rcd#
, ba.acct_cd
FROM ps_personal_data pd
, ps_budget_actuals ba
...
END;
Can anyone explain me or suggest something..how to do it or an advice.
I will appreciate, thanks. :)