Stored Procs still don't work
Stored Procs still don't work
I upgraded form 6.8 to 7.1 and now none of my stored proc calls work. I am completely stuck. I tried deleting the proc from the lqml and then re-dropping it from the db explorer, but when I do that there is no ProcNameResult type created. Nothing I do seems to work. What is the magic spell I need to cast to make this work!!!
Last edited by edstaffin on Sat 04 Aug 2012 10:50, edited 1 time in total.
Re: Stored Procs still don't work
More information. When I try to do for each on the returned query, I get an
"Index was outside the bounds of the array" exception. This happens regardless of what proc I call. BTW, this is using vb ... if that makes any difference.
Thanks ... Ed
"Index was outside the bounds of the array" exception. This happens regardless of what proc I call. BTW, this is using vb ... if that makes any difference.
Thanks ... Ed
Re: Stored Procs still don't work
The model objects are not always displayed on the diagram layout, most likely the complex type is available only in the Model Explorer. Please specify, does only the diagram layout not display the complex type, or it is also does not reside in the Model Explorer?
As for the "Index was outside the bounds of the array" exception, this issue has been fixed. It will be available in the next build of dotConnect for Oracle, which we plan to release this week.
As for the "Index was outside the bounds of the array" exception, this issue has been fixed. It will be available in the next build of dotConnect for Oracle, which we plan to release this week.
Re: Stored Procs still don't work
Hi,
Thanks for the response.
It appears that when I drag the proc from the db explorer under the packages branch, the proc is created in the model but the complex type is not created either in the diagram or the model explorer.
Thanks ... Ed
Thanks for the response.
It appears that when I drag the proc from the db explorer under the packages branch, the proc is created in the model but the complex type is not created either in the diagram or the model explorer.
Thanks ... Ed
Re: Stored Procs still don't work
The fix that refers to the "Index was outside the bounds of the array" exception is available in new build of dotConnect for Oracle 7.1.58.
We were unable to reproduce the issue related to creating complex types for the stored procedures. We have sent you the package with stored procedure to the e-mail address you have provided in your forum profile. Please make changes to it, so that the issue could be reproduced, and send it back to us.
As an option you can send us your test project with the DDL/DML script and model to enable us to reproduce this issue in our environment.
JIC: when you add a procedure/function from the database explorer, you should be prompted to execute this procedure or function to get the metadata of its resultsett. Please make sure that you select "YES" in the appeared dialog.
We were unable to reproduce the issue related to creating complex types for the stored procedures. We have sent you the package with stored procedure to the e-mail address you have provided in your forum profile. Please make changes to it, so that the issue could be reproduced, and send it back to us.
As an option you can send us your test project with the DDL/DML script and model to enable us to reproduce this issue in our environment.
JIC: when you add a procedure/function from the database explorer, you should be prompted to execute this procedure or function to get the metadata of its resultsett. Please make sure that you select "YES" in the appeared dialog.
Re: Stored Procs still don't work
I got the stuff you sent and will take a look at it. As an aside, it appears that the issue is with some procs and not others. I can't seem to nail down what the difference is. However, I am certain this is a bug because when I do this with the 6.8 version it works fine. It's only with the new 7.1+ versions that I have the problem. I will see if I can create a reproduceable case and send it to you.
Thanks ... Ed
Thanks ... Ed
Re: Stored Procs still don't work
Were you able to change the sample project and reproduce the issue with creating complex types for the stored procedures using it?
We look forward to your reply.
We look forward to your reply.