Devart Forums

Hello,

There are two properties which can be used in a connectionstring: MaxPoolSize, OciSessionPoolMaxSize. What is the difference between them? What is the difference between a connection and a session?

Thank you for your information in advance.

Istvan Hegyes
(L-Soft Kft.)

Hello

Sorry, when I created the sample project I got in the swing of I was made a mistake and the process of the creating a dataset is good.
So after I set the dataset, connect the datatabel to the stored procedure it created a commandtype = text, commandtext = begin sampleproce(:cursor) end; command. I made a mistake after that because I change it in the properties menu to commandtype = stored procedure, commandtext = stored procedure name. But when I changed the type of the command, the textbox next to the commandtext changed to a combobox. This combobox was filled up with names of the stored procedures of the database in the format of schemaname.stored_procedure.
So if I would left as default the commandtype and commandtext I hadn't run into this problem.
Maybe there is a bug because the combobox filled up with the names of the stored procedure in a wrong format, but it can be avoidable.

Thanks for your time and your help StanislavK

Istvan

Hello,

Is it possible to add a devart dataset to the project, set it to an oracle stored procedure which has an out refcursor parameter and NOT save the name of the schema of the developer database.

When I browse for the stored procedure in the list it is listed as database_schema_name.stored_procedure_name. So when I found my sp it saves it with the schema name and If i change the connectionstring (dinamically) it throws an exception because it would like to call the sp in the other schema.

Is it a bug? Are there any workaround to solve this problem?

Thanks
Istvan

Hello

It seems the problem is solved. I forget to use Original_ pretag in the where clause.

Hello Devart Team,

I have got the same problem.

When you said this:
This error was generated because only one parameter is set in your code but our provider generates the whole set of parameters if at least one parameter is set.

The whole set of parameters is the hole fields of the record, or the hole fields of the table? In my case selects only select some fields from the table without parameters.

When I see what sent to the database with the dbmonitor I see that the params are sent like strings and not like values.

Prepare: update iban_felhaszn_jog_fej set C_ELONEV = :C_ELONEV , C_NEV1 = :C_NEV1 where C_OPERNEV = :C_OPERNEV
It means that the parameters are handled like strings or just hide the values and change the parameter names with their value in the background?

Hi

I use Oracle 10g database and VS2008 with devart Linq To Sql technology. I have a Stored Function with 3 varchar2 params and a varchar2 return value. After I generated the mapping classes I get this code:
When I try to run the function I get an exception:
Error on reading data from IDataReader.
This exception has a message:
Ora-14551 Cannot perform DML operation inside a query.

But this function works right when I call it from PL/SQL Developer.

Why do I get this exception? Did I forgot something?

Thanks for your help in advance

Istvan Hegyes

My basic problem is that I can’t understand how to show data in a gridview returned with a ref cursor from a stored procedure. I found some solutions that use programmatic ways, but it is more safer and maybe quicker if I can bind the grid to the cursor with the designer. Is there any way to solve this issue?
If the above problem can only be solved in only programmatic way, if there any way to give back query data from a stored procedure to a grid, and bind it with the designer?

Thanks in advance