Elsasoft Forums
Elsasoft Forums
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SqlSpec
 Support questions
 View code truncated in Oracle
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pgeo2000
Starting Member

16 Posts

Posted - Dec 07 2007 :  02:48:13 AM  Show Profile  Reply with Quote
In Oracle, the view code is truncated to 4000 characters; also on "Views" page the "code length" column shows a maximum of 4000
Is there any option to enlarge it ?
Thanks

Jesse
Forum Admin

729 Posts

Posted - Dec 07 2007 :  7:58:30 PM  Show Profile  Reply with Quote
Thanks for pointing this out. I can change it so it works as long as you don't use the msdaora OLEDB provider. Why? Because for some versions of the msdaora oledb provider I found that this query failed:

select dbms_metadata.get_ddl('VIEW','MyView','MySchema') from dual

but this one does not:

select cast(dbms_metadata.get_ddl('VIEW','MyView','MySchema') as varchar2(4000)) from dual

I believe the first query fails because msdaora does not handle CLOB data correctly, which is what get_ddl() returns.

I'll post back here when I have a fix for this.
Go to Top of Page

Jesse
Forum Admin

729 Posts

Posted - Dec 07 2007 :  9:47:14 PM  Show Profile  Reply with Quote
ok, this should be fixed now. Try this build: http://www.elsasoft.org/sqlspec.zip

Go to Top of Page

pgeo2000
Starting Member

16 Posts

Posted - Dec 10 2007 :  12:48:03 AM  Show Profile  Reply with Quote
It works perfectly now, thank you.
George
Go to Top of Page

Jesse
Forum Admin

729 Posts

Posted - Dec 10 2007 :  05:39:42 AM  Show Profile  Reply with Quote
great!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Elsasoft Forums © Elsasoft LLC Go To Top Of Page
Snitz Forums 2000