Windows Oracle Data Access Components (MOSC)

MOSC Banner

Querying a Table in Visual Basic 2010 from the organization

edited Mar 23, 2012 12:49AM in Windows Oracle Data Access Components (MOSC) 1 commentAnswered
Hello, I am making a query to a table and did not return information, instruction before you step as the number of the organization, could help solve the Why?
Thanks!


Schedule the code



        Dim oCon As OracleConnection = New OracleConnection(sCadenaConexion)
        oCon.Open()

        Dim command As OracleCommand =  New OracleCommand("begin apps.fnd_client_info.set_org_context(102); end;", oCon)
        command.ExecuteNonQuery()
  Dim reader As OracleDataReader


        Dim sql As String = "SELECT COUNT(trx.trx_number) facturas" & _
                              "  FROM ra_customer_trx_all trx," & _
                              "       ar_customers cu," & _
                              "       fnd_lookup_values lkv," & _
                              "       hr_organization_units_v org," & _
                              "       ra_cust_trx_types_all trt," & _
                              "       ra_salesreps_all sr" & _

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center