enterprisedb package execution

Discussion in 'Software' started by kanchuparthi.rams, May 22, 2008.

  1. kanchuparthi.rams

    kanchuparthi.rams

    Joined:
    May 22, 2008
    Messages:
    2
    hi to all this is rams i am using enterprisedb as back end here i found a problem

    with package execution that is package stored procedures having output parameters r not executed through the vb dotnet application It does not recogize the output parameters

    i submit my code and error below
    Imports EnterpriseDB.EDBClient

    Dim cn As New EDBConnection("server=192.168.10.129;user id=enterprisedb;password=spsoft;database=spruce;port=5444")
    Dim cmd As New EDBCommand
    cn.Open()
    cmd.Connection = cn
    query = "public.class_admin4.add_student:)p_sno,:p_sname,:p_class,:p_city)"
    cmd.CommandText = query
    cmd.CommandType = CommandType.StoredProcedure
    cmd.Parameters.Add(New EDBParameter("p_sno", EDBTypes.EDBDbType.Integer)).Value = 1
    cmd.Parameters.Add(New EDBParameter("p_sname", EDBTypes.EDBDbType.Varchar)).Value = "rams"
    cmd.Parameters.Add(New EDBParameter("p_class", EDBTypes.EDBDbType.Varchar)).Value = "xxx"
    cmd.Parameters.Add(New EDBParameter("p_city", EDBTypes.EDBDbType.Varchar)).Value = "hyd"
    cmd.Prepare()
    cmd.ExecuteNonQuery()
    MessageBox.Show("stored procedure is executed")
    cn.Close()

    error is

    public.class_admin4.add_student(Integer) does not exists

    regards

    rams
     
    kanchuparthi.rams, May 22, 2008
    #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. Al. C
    Replies:
    3
    Views:
    635
    Moz Champion
    Jan 19, 2005
  2. Dan Kohn
    Replies:
    0
    Views:
    825
    Dan Kohn
    Apr 4, 2005
  3. Lukagain
    Replies:
    0
    Views:
    441
    Lukagain
    Sep 16, 2004
  4. vinayrh

    Execution problem in Compaq Visual Studio 6.0

    vinayrh, Oct 1, 2004, in forum: Computer Support
    Replies:
    0
    Views:
    640
    vinayrh
    Oct 1, 2004
  5. kanchuparthi.rams

    database access(enterprisedb)

    kanchuparthi.rams, May 30, 2008, in forum: Software
    Replies:
    0
    Views:
    633
    kanchuparthi.rams
    May 30, 2008
Loading...

Share This Page