XMLType unsupported

[jgebal]

Hi.
I'd like to user ruby-plsql-spec on a database where XMType is hevily used (all API is bazsed on XMLType).
Unfortunatelly the type is unsupported right now.

Here is a test to do the check (used OCI8 dirver).

require_relative 'spec_helper'
describe "XMLType" do
before(:all) do
plsql.execute <<-SQL
CREATE OR REPLACE PACKAGE test_package IS
xml_variable XMLType;
END;
SQL
plsql.execute <<-SQL
CREATE OR REPLACE PACKAGE BODY test_package IS
END;
SQL
end
after(:all) do
plsql.execute "DROP PACKAGE test_package"
end
it "should set and get XMLType variable" do
plsql.test_package.xml_variable = 'abc<'
plsql.test_package.xml_variable.should == 'abc'
end

end

And here are some resources i've found about XMLType.
http://www.ruby-forum.com/topic/56982
I'm not sure if it should be vixible in Ruby as plain String or maybe an XML Docukment like here:
http://www.tutorialspoint.com/ruby/ruby_xml_xslt.htm
Do you plan to add a support for XMLType?

Regards
Jacek

[rsim]

Will have a look at XMLType next time when will do ruby-plsql improvements but currently not planning to do it in nearest weeks. So if you can investigate it and try to submit pull request then I would appreciate it :)

I would suggest that just XML string representation would be used - there are many Ruby XML libraries (I use Nokogiri in my projects) and therefore it probably wouldn't be good to support just one specific library in ruby-plsql.

[jgebal]

Hi.
I'll try to work it out.
I need to get with some guys knowing how to submit pull request.
Probably will get on it next week.

[yahonda]

You can find how to pull request here .

[theidlemonk]

Is there any update on the XMLTYPE ..we could really use this one.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.