Create a Business Logic Layer, in visual basic.

See more:

VB

Oracle

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. :)