Red Gate forums :: View topic - Case sensitivity between machines
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Source Control for Oracle
Source Control for Oracle forum

Case sensitivity between machines

Search in Source Control for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 09 Jan 2014
Posts: 3

PostPosted: Thu Jan 09, 2014 4:42 pm    Post subject: Case sensitivity between machines Reply with quote

I've just spoken to Ben on the phone and he said that I should raise this bug report in the forum.

We have an Oracle 10g database with a number of schemas where development is shared between more than one developer .

On my machine (Win 7, 64-bit) yesterday I performed an initial check in of the relevant schemas from this database into our Subversion repository using Source Control for Oracle. My copy of the application now reports that the repository is now up to date with the live database.

A colleague has started using the application on his machine (Win XP, 32-bit) today and created a project for the same database pointing to the same path in Subversion. His copy is reporting that he has a change to check in.

The change his client is reporting is relating to a difference in the case of a schema name within a procedure within a PL/SQL package (though this isn't clear in the application as the comparison pane at the bottom of the screen does not highlight differences in case!).

No changes were made to this package between the point I checked it into the database and the time he created his own project for the same database in SCO.

So a couple of issues here:-

* My initial check in using the application appears to have altered the case used within a PL/SQL procedure contained within a package
* My copy of the application now doesn't recognise that this difference now exists between the database and repository, but my colleagues application does

I am confused as to whether the SCO application is meant to be case-sensitive or not, due to the differing behaviour of our two client applications.

Back to top
View user's profile Send private message
Chris Auckland

Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Jan 13, 2014 11:55 am    Post subject: Reply with quote

Thanks for your post.

I'm not really sure why this would be happening. There aren't any case sensitivity options that I'm aware of that would affect this.

Would you be able to send me an example script for an object that causes this?

What happens if you unlink your project and then relink? Does your client then report the case difference similar to your colleague?
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group