Call Oracle Stored Proceedure VB.NET

Discussion in 'ASP .Net' started by Problematic coder, Mar 8, 2007.

  1. I have a form based application that inputs values into various oracle
    tables, after it has done this I want to call a stored proceedure in
    Oracle which is already written to do more work on this data, it does
    not return any values to vb nor does it expect any criteria or input.

    I already have a connection to Oracle open using the following code:

    Dim objcnn As New Data.OracleClient.OracleConnection(ConnectStr)
    Dim objcom As Data.OracleClient.OracleCommand
    objcnn.Open()
    objcom = New Data.OracleClient.OracleCommand(strSQLinsert, objcnn)
    objcom.ExecuteNonQuery()

    Assuming the stored proceedure is named "my_proc" could I use a
    similar command like:

    objcom = New Data.OracleClient.OracleCommand(strCallMyProc, objcnn)

    If so what would strCallMyProc = ?

    If not how else could I or should I call it?

    Thanks
    Problematic coder, Mar 8, 2007
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    0
    Views:
    302
  2. Problematic coder

    Call Oracle Stored Proceedure VB.NET

    Problematic coder, Mar 8, 2007, in forum: ASP .Net
    Replies:
    2
    Views:
    449
    Problematic coder
    Mar 9, 2007
  3. Problematic coder

    Erro calling stored proceedure

    Problematic coder, Mar 13, 2007, in forum: ASP .Net
    Replies:
    9
    Views:
    436
    Problematic coder
    Mar 13, 2007
  4. Mick Walker
    Replies:
    4
    Views:
    388
    Lloyd Sheen
    Jun 20, 2007
  5. Feyruz
    Replies:
    4
    Views:
    2,160
    Sherm Pendley
    Oct 14, 2005
Loading...

Share This Page