Skip to main content

Using Stored Procedure with ADO.net

  • August 23, 2013
  • 1 reply
  • 6 views

Sushanth_B
Iam using ADO.net driver for vertica and working in asp.net I need to create a graph and for this i need to execute a stored procedure. Got to know that vertica doesnt support stored procedure .please specify a step by step instruction for creating external procedure in vertica and use through ado.net

1 reply

Prasanta_Pal
Forum|alt.badge.img
  • Participating Frequently
  • August 28, 2013
Refer to the below link how to create external Stored Proc https://my.vertica.com/docs/6.1.x/HTML/index.htm#13587.htm Call the stored proc similar to a SELECT statement from .Net code.