![]() |
|
|
|
#1 |
|
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;po rt=5444") Dim cmd As New EDBCommand cn.Open() cmd.Connection = cn query = "public.class_admin4.add_student( 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 |
|
|
|
|
![]() |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Complete package of DVD solutions | mikeriv | Software | 0 | 03-28-2007 02:33 PM |
| Complete package of DVD solutions | abcz_video@yahoo.com | DVD Video | 0 | 12-08-2006 03:36 PM |
| The Practice Test Package Development: A New Service on the Certification Market | David Johnson | A+ Certification | 0 | 01-19-2005 10:52 AM |
| HellBoy package not Widescreen???? | Chris | DVD Video | 2 | 11-03-2004 07:59 PM |
| PC Package deals? | jkl | A+ Certification | 0 | 10-28-2004 05:12 PM |