New to Firebird stored procedures - help needed

I am just starting to use stored procedures with VB.Net.

I have a SP that returns a value but I do not know how to retrieve it.

Here is the SP



This is the code I have so far...

myCommand = New FbCommand("PROCEDURE_02", myConnection)
myCommand.CommandType = CommandType.StoredProcedure

myCommand.Parameters.Add("@JOB_CLASS", "XY") ' Return comment for "XY"

How do I determine the value for my_comment?

Calling ExecuteScalar() on the myCommand may work, but I'm fairly certain the following will:

1. Add another parameter for "@my_comment".
2. Set that parameter's Direction property to ParameterDirection.Output.
3. Call ExecuteNonQuery() on myCommand.
4. Retrieve the Value that has now been put in that parameter.

Here's a good site.

Hi LyonHaert;

Thanks for getting me started but I really need lots of information or a good tutorial. I figured out how to get parameter information into a stored procedure. The site you suggested confirmd that I was doing it right.

Here are some comments/questions from your post. Perhaps you or others can share your knowledge.

1. Add another parameter for "@my_comment".

What is the syntax, this

myCommand.Parameters.Add("@my_comment")

or something else?


2. Set that parameter's Direction property to ParameterDirection.Output.

How exactly do you do this? I can find no information on this anywhere. I've searched high and low for information/tutorial on using the net porvider and have turned up next to nothing.

3. Call ExecuteNonQuery() on myCommand.

No problems here.

4. Retrieve the Value that has now been put in that parameter.

Once again, how do you do this?

Is there any information anywhere that explains how to do this stuff?


Thanks for the help.
Lin

See the sticky thread on top of this forum, lots of resources, even Firebird and .Net specific (but in this case any tutorial about .net and stored procs should do)

Hi pabloj

Thanks for taking the time to respond but I am beginning to feel like a sinking ship.

but in this case any tutorial about .net and stored procs should do

I've been following links for days and generally feeling overwhelmed by it all.

Is there a tutorial anywhere that you can name or point me to that shows in simple language how to use the Firebird net provider with VB.Net to.....

1) Send parameter values to a stored procedure. I mostly have this one figured out but additional information wouldn't hurt.

2) How to retrieve and use values returned as parameters from a stored procedure.

3) How to retrieve and use values where multiple rows are returned.

4) Anything else that I may have missed.


Thanks
Lin

Regarding your questions about the Direction property and retrieving the value, there is more code in the comments of the page I linked which show this.

LinXG, please consider that people here do take the time to think before posting and expect readers to do the same, in this case read the article(s) linked.
LyonHaert pointed you to a page which shows you how to solve your problems 1) and 2), then, the same site (or Google) have the answer for question 3), see here .
Of course 4) is a bit generic and unlikely to get a quick answer