enterprisedb package execution

Author Topic
rama krishna
Member

Joined: 22 May 2008
Country:
Posts: 2

Posted: 22 May 2008 15:50:49

hi to all this is rams
i am usin enterprisedb as back end I found a problem with packages execution having output parameters
i am submiting my code


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(<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>_sno,<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>_sname,<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>_class,<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>_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.Integer)).Direction = ParameterDirection.Output
cmd.Parameters.Add(New EDBParameter("p_class", EDBTypes.EDBDbType.RefCursor)).Direction = ParameterDirection.Output
cmd.Prepare()
cmd.ExecuteNonQuery()
MessageBox.Show("stored procedure is executed"
cn.Close()


error


public.class_admin4.add_student(Integer) does not exists

regards

rams

hi to all this is rams
i am usin enterprisedb as back end I found a problem with packages execution having output parameters
i am submiting my code


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(<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>_sno,<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>_sname,<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>_class,<img src=../images/dnzone/forum/icon_smile_tongue.gif border=0 align=middle>_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.Integer)).Direction = ParameterDirection.Output
cmd.Parameters.Add(New EDBParameter("p_class", EDBTypes.EDBDbType.RefCursor)).Direction = ParameterDirection.Output
cmd.Prepare()
cmd.ExecuteNonQuery()
MessageBox.Show("stored procedure is executed"
cn.Close()


error


public.class_admin4.add_student(Integer) does not exists

regards

rams

Main Sponsor

Visit All Zones

The Dreamweaver ZoneThe Flash ZoneThe .NET ZoneThe Fireworks Zone

Latest Components

Our Sponsors

Featured Article

Beyond Graphing

When a graph is drawn, the focus is kept on the actual underlying competing figures that constitute the graph. Sometimes it is difficult to make assumptions just by looking at these graphs. When looking at a geographical map of data you immediately see exactly where things are happening. This article presents a .NET geographical mapping solution that will illustrate a fairly simple way of implementing these maps.

Featured E-Book

Design & Accessibility

Have you, as a web developer or designer ever been on sites where the site seems more of a puzzle then a tool to find the information you where looking for? Or are you looking to improve your web design skills? Then read on!

Design & Accessibility

This e-Book will teach you how to become a truly professional developer or designer. By taking usability and accessibility issues in account when designing your websites or applications you can make the difference and avoid a lot of (user) frustration.

Featured Component

3D Gal Slideshow Bndl

Get our best gallery and slideshow components in one bundle and save money! Our most popular components combined to form an amazing presentation team.

Featured Book

Inside ASP.NET


Inside ASP.NET is a comprehensive guide to ASP.NET development using Microsoft's .NET development framework. This book presents information on the .NET framework that is of specific interest to Internet and intranet developers, and is split into the following sections: Introducing ASP.NET, Core ASP.NET, ASP.NET and Data Access, Advanced Technologies, Advanced Web Forms, and Putting It All Together

Each chapter tackles a specific area of ASP.NET development, first by giving a detailed overview, then presenting a series of code examples and walk-throughs that illustrate various applications of ASP.NET

Follow us on twitter Subscribe to our RSS feed
Activate your free membership today | Login | Currency