Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Executing Procedure that returns values. [DNET364] #369

Closed
firebird-automations opened this issue Feb 13, 2011 · 5 comments
Closed

Executing Procedure that returns values. [DNET364] #369

firebird-automations opened this issue Feb 13, 2011 · 5 comments

Comments

@firebird-automations
Copy link

Submitted by: Victor Israel Herrera Coronado (ppman5k)

The problem or issue that I've with the new version of http://Firebird.Net 2.6. library it's that I can't execute store procedures as I'd usually do with the previous version (2.5). Not produces any kind of error, only the procedure that would output information returns nothing.

For example: With C#⁠, Getting a DataSet
// Supposed m_fb_cnn as a valid FirebirdConnection
FbAdapter m_fb_ad = new FbAdapter("GET_INFO", m_fb_cnn);
m_fb_ad.SelectCommand.CommandType = CommandType.StoreProcedure;
m_fb_ad.SelectCommand.Params.Add("V_PARAM","VALUE");

// new dataset
DataSet m_dst = new DataSet();

// fill dataset
m_fb_ad.Fill(m_dst);

It supposed that the dataset wouldn't be empty. With the library 2.5 that not occurs, this functioned very good but in this one (2.6) doesn't function.
What I do wrong??

Best regards

@firebird-automations
Copy link
Author

Commented by: @cincuranet

How the code of SP looks like?

@firebird-automations
Copy link
Author

Commented by: Victor Israel Herrera Coronado (ppman5k)

Well, the code of this procedure has the SUSPEND part at the end of its structure and it supposed to return some row but it doesn't return anything.

best regards.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Author

Commented by: @cincuranet

I created simple SP "create procedure get_info(v_param varchar(20)) returns (i int, j int) as begin suspend; suspend; end" and tested your code (in 2.7.7) and it works correctly. Can you check version 2.7.7 and/or provide the code for SP (and related objects if needed) for me to check the behavior?

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: In Progress [ 3 ] => Closed [ 6 ]

resolution: Cannot Reproduce [ 5 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants