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.
Error: Viewing XML schema via Oradeveloper in VS.NET 2008
-
- Posts: 60
- Joined: Mon 18 May 2009 13:17
-
- Posts: 60
- Joined: Mon 18 May 2009 13:17
Thx for info.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.
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.
The last build is 2.55.148, available for download from registered users area.goethals.f wrote: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.
Re: Error: Viewing XML schema via Oradeveloper in VS.NET 2008
During schema registing in OraDeveloper Studio and Tools, Oracle object types equal to elements of XML schema are generated. They are created in the same Oracle schema where you register the XML schema. You can view them in Database Explorer in Object Types folder.goethals.f wrote: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 ?)
There are 2 ways of XML schema usage:
1. You can create an XML table (a schema is specified there.) The table will be fully equal to the selected element in the selected schema. It is required to right-click "Tables" folder in the Database Explorer and select "New XML table".
2. You can create a column of a required data type. While creating a column in a usual table, in the new column dialog you should specify "Use ADT". Schema-drop-down list will appear. In this drop-down list select _schema_Oracle_ where xmltypes, generated during xml schema registration, exist.
Then in Data type drop-down list select a required type.