Forum Stats

  • 3,852,379 Users
  • 2,264,100 Discussions
  • 7,905,056 Comments

Discussions

Execute Stored Procedure from C#

737934
737934 Member Posts: 7
edited Dec 1, 2009 4:25AM in General Database Discussions
Hi, im new to using stored procedures and i have the following stored procedure...

CREATE OR REPLACE PROCEDURE DRL_PROCEDURE2(var_SOURCE_OBJECTID IN varchar2, var_NEW_OBJECTID OUT varchar2)
AS
BEGIN
SELECT MAX(NEW_OBJECTID)
INTO var_NEW_OBJECTID
FROM DRL_CONVERSION
WHERE SOURCE_OBJECTID = var_SOURCE_OBJECTID;
END;

I want to be able to call this procedure from my windows form application and display the result of the stored procedure into a label...could someone please help me! Thanks in advance!
Tagged:

Best Answer

  • Girish Sharma
    Girish Sharma Member Posts: 4,980 Bronze Crown
    Answer ✓
    http://www.csharpfriends.com/articles/getarticle.aspx?articleid=78
    You can find how to call stored procedure (in the above link you will find an example of SQL Server 2005 which also work for you as of your oracle stored procedure) in C#.

    HTH
    Girish Sharma

Answers

This discussion has been closed.