Devart Forums

goethals.f wrote:

StanislavK wrote:Thank you for your report. We have fixed the problem, the fix will be included to one of the nearest builds.

The problem should not occur with newer Oracle clients. If possible, you may use Oracle client version 9 or higher as a temporary workaround.

Is the "fix" "new-build" already released.

Because I also have the same error message "Unable to find an entry point named 'OCIStmtPrepare2' in DLL 'C:\oracle\ora81\bin\oci.dll'." with version 5.60.124.0 en Oracle 8 client.

Sadly, I'm no able to upgrade my client, because I still need to be able to access the old oracle 7.3.4 with other progs (and as far iI know, oracle 8 client was one of the lasts which could connect to 7.3.4)


Thx
Fred[/b]

PS: I tried one of my older applications whichs works with 5.35.79 and where I reference explicit those dll's (not the one in programf-iles on my dev-box because that's version 5.60.120.0)

And also with those old dll's referenced and copied local=true --> my app does not run anymore and I get the above error.

So it seems the even I referenced old dll's, the app uses the new ones ? Is this the normal behaviour.

Hopefully I can uninstall the new version and revert back to the 5.35.79, so at least my old apps are running again...

StanislavK wrote:Thank you for your report. We have fixed the problem, the fix will be included to one of the nearest builds.

The problem should not occur with newer Oracle clients. If possible, you may use Oracle client version 9 or higher as a temporary workaround.

Is the "fix" "new-build" already released.

Because I also have the same error message "Unable to find an entry point named 'OCIStmtPrepare2' in DLL 'C:\oracle\ora81\bin\oci.dll'." with version 5.60.124.0 en Oracle 8 client.

Sadly, I'm no able to upgrade my client, because I still need to be able to access the old oracle 7.3.4 with other progs (and as far iI know, oracle 8 client was one of the lasts which could connect to 7.3.4)


Thx
Fred[/b]

Duke wrote:I assume you mean NO problem, if you will watch the news-sections.

Damn,

stupid typo of me !!!

Should have previewed and cheched my answer first..

But we both understand what we mean

Duke wrote:Right now VS 2010 in now supported by OraDeveloper Tools. We are planning to support it in the near future.

I assume you mean NOT supported, if you plan to do it in the future.

Ok, now problem. I'll will watch the news-sections for any news.

Hello,

Just a question. I was wondering if the "OraDeveloper Tools for VS.NET" is compatible in VS.NET 2010, because I really like the tool now in VS.NET 2008.

The latest version is "v2.55.168", is this compatible and if so, do we need to re-installe (re-register) so that the tool is included in VS.NET 2010 (which has been installed after installation of "OraDeveloper Tools for VS.NET".

I have installed VS.NEt premium, and the Tools --> "Oracle" submenu was available (automatically ), but the Tools --> "Devart OraDeveloper Tools" submenu was not available....

Is there anyone who has some hints....

StanislavK wrote:Please try Typed Oracle Objects Wizard: Tools -> Oracle -> Oracle Objects Wizard. It allows generating C# classes representing user-defined types. Please specify whether this is the functionality you need.

AHA,

very interesting features.

Didn't noticed yet that they exists. Seems there is also a full package code-generator...


I tried the wizard, but the wizard finds only my custom object-type, and NOT my custom table-type. Or is this the normal behaviour ?


Nevetheless,
great thank for the wizard-tips !

StanislavK wrote:This is the expected behaviour.

In the Direct mode, you get an exception as Oracle objects are not supported.

In the OCI mode, the problem is that the type defined inside the package cannot be used outside. In particular, this means that you can use the table returned by SELECT_DETAILS inside PCK_XXX only.

To resolve the situation, you may define the custom type globally.

OK,

thx for the info.

I modified the type-declarations to public/global types. And indeed everything is working. (tables as input and output parameters)

Just one other question.
When working with those plsql-tables in dotconnect (by way of oracleTable / OracleObject) --> there is no type-checking at development for attributes/fields...

Is there a way to "generate" some c# class which is strong-typed based an can be used for the DB-type.

Just like some proxy class which is generated specially by a dotconnect wizard when choosing the Db-type. This could make development and using the pl-sqltables a lot easier + bullet-proof if we can use some type-based objects...

Maybe a possibility for future releases if not yet available.

thx
Fred

Hello,

I have a question concerning using plsql-tables in stored procedures as output-paremeters in my oracle packages

When executing with dotconnect 5.35.79.0 (non-direct mode) I got the message:

OCI-22303: type "user_test"."PCK_XXX.P_XXX_TABLE" not found

When executing with dotconnect 5.35.79.0 (direct mode) I got the message about unsupported network datatype (which I believe is indeed a remark on the direct-mode). So this is normal ?


When executing my stored procedure in Oracle SQL Developer, it's is working. So my procedure/package is OK.


Does anyone know what I do wrong, or why it is not working. Why do I get the type-not-found error (I'm connecting with the owner-account). Is there some example-code available which works with plsql-tables with multicolumns and as output-parameter.

PS: I got the same errors when trying to execute the procedure directly from with vs.net 2008 with OraDeveloperTools 2.55.148


Maybe some extra info

My oracle server is 10.2.0.4 64bit
My local client is version 8 --> this because we need acces also to older 7.3.4. Could the problem be solved with a oracle 10 client (which cannnot sdaly be installed next to oracle8 client)



Fred







This is my package code (simplified, and only relevant code, so not 100% complete)


PACKAGE user_test.PCK_XXX AS

TYPE P_XXX_TABLE IS TABLE OF user_test.XXX%ROWTYPE;

PROCEDURE SELECT_DETAILS (
p_Thickness OUT NUMBER,
p_ResultSet OUT user_test.PCK_XXX.P_XXX_TABLE
);

END PCK_XXX;


PACKAGE BODY user_test.PCK_XXX AS

PROCEDURE SELECT_DETAILS (
p_Thickness OUT NUMBER,
p_ResultSet OUT user_test.PCK_XXX.P_XXX_TABLE
)
AS
BEGIN

-- Normal PL-SQL code to create cursor: tmp_p_ResultSet
-- tmp_P_rec is record of rowtype of table to fetch

LOOP
FETCH tmp_p_ResultSet INTO tmp_P_rec;
EXIT WHEN tmp_p_ResultSet%NOTFOUND OR tmp_p_ResultSet%NOTFOUND IS NULL;

-- Add to table
tmp_Total := tmp_Total + 1;
p_ResultSet.EXTEND;

p_ResultSet(tmp_Total).FIELD1 := tmp_P_rec.FIELD1;
p_ResultSet(tmp_Total).FIELD2 := tmp_P_rec.FIELD2;

-- MORE different FIELDs

END LOOP;
CLOSE tmp_p_ResultSet;


END SELECT_DETAILS;

END PCK_XXX;

Shalex wrote:Please don't add out parameters to the collection - out parameters will be initialized after stored procedure execution:

• you can get the result set as data reader in the following way:

  Code: Select all

          Dim _oracleCommand As Devart.Data.Oracle.OracleCommand = tmpDatabase.GetStoredProcCommand("SADERP_ADMIN.PCK_PG_SECTION.SELECT_SECTION_BY_ID")
          tmpDatabase.AddInParameter(_oracleCommand, "p_Section_ID", System.Data.DbType.Int32, 100)
  
          tmpDatabase.ExecuteNonQuery(_oracleCommand)
          Dim reader As OracleDataReader = DirectCast(tmpDatabase.GetParameterValue(_oracleCommand, "p_ResultSet"), OracleCursor).GetDataReader

• if your stored procedure contains 2 out cursor parameters, and you execute the ExecuteDataSet method, the result DataSet will contain two tables (Table and Table1) corresponding to your two result sets.

OK

thx for the info. But now I have a small extra questions.
When I was doing some more test and had the DBMonitor running in the background.

I saw that by each execution of 'GetStoredProcCommand' there was a new connection made, openend, fetched the results and closed (close statement info was logged in the list). Even when I had my OracleDatabase and OracleConnection as global variables.
In the left tree I sas multiple connection-objects (which have each unique nr's and each have one executed command)

Is this the normal behaviour that after each execution the connection to the oracle DB is closed. Is there a setting to keep the connection really open and close it manually when I want. Or is the connection not really closed (but why it is then eacht time listed in the DBMonitor)

thx again

Fred

Alexz wrote:Yes, if the schema size is about 4000 bytes, an error occurs when performing the "View Xml Schema" operation. This problem will be fixed in the next build.

Yes, XMLTYPE field editing currently is not available due to technical reasons.

Thx for info.

Fred


Do you have any idea why I cannot download the latest versions anymore from the user-download-area. Last version available for download for me is "2.55.148" --> and no answer yet to my e-mail sended to the sales dept.

when I leave the out-parameter out, (so just 1 input-param) and use the method "ExecuteDataSet" then I got an dataset back wich has the results in it.

But,

*) is there a simple way by using in-out params, and just a simple dataReader to get the ref-cursor back
*) can you specify in an oracle proc 2 out-parameters as cursor --> and how do you do that via dotconnect (if ExecuteDataSet only returns 1 datatset)


thx
Fred

Hello,

I have a question about the dotconnect/devart Enterprise Library concerning accessing/executing a stored procedure where one of the parmeter is an out-parameter of sys_refcursor --> see oracle procedure header below


In my first app I used the direct dotconnect objects (connection, parameter, OracleCursor, OracleReader) which works fine.

But how do you do the same with the Enterprise Library

I now have
How do you have to specify the last parameter, so that it is of the specific cursor-type ?

and how te retrieve the cursor afterwards (via ExecuteNonQuery -> parameters -> GetDataReader)

thx
Fred

Hello,

Today I was doing some test concerning XML-types/schema's in our Oracle 10g DB.

Most of my daily-access happens via the Oradeveloper tools in VS.NET 2008.

When I try to view the content in the XML-schema treenode --> I see the name of my simple-test-XSD schema.
Bu when try to view "View XML Schema" I got the error:

"ORA-19011: Character string buffer too small"

The XSD-schema itself is very small, only 1707 chars (including spaces), 1310 excluding spaces.

My schema-namespace is "http://localhost:8080/public/XSD/TEST/TEST_Section"


Is there a reason why I get this error ?


PS: When I create a new table via the Oradeveloper, I can specify for a column it type as "XMLTYPE", but I can not access and not see anything in the schema-dropdownlist. (I think this is were I can specify which XML-schema has to be applied to this XMLTYPe column ?)


thx

Fred


ps2: I have currently version 2.55.148, because I can not see the updated version in the download arear --> e-mail has been send to sales dpt.

AndreyR wrote:Thank you for the report, we have reproduced this problem.
I will let you know about the results of our investigation.

Hello,

Is there already some progress concerning the topics / problems ? Do you have an idea of a possible solution-release-day (or some temporary workarounds.)

Thx.

Hello,

I have a small question concerning the "ASP.NET Dynamic Data Entity Website Technology". Can we use this in combination with an Devart Entity model (and developer)

--> Because I tried it with a simple model and got when trying to open the website the following message.


The specified metadata path is not valid. A valid path must be either an existing directory, an existing file with extension '.csdl', '.ssdl', or '.msl', or a URI that identifies an embedded resource

In the Global.asax file I wrote this line:
Doing the same with the default builtin Entity model works.

Is the dynamic-data-website-technology supported by Devart ?