Subversion Changing Oracle Variables to Uppercase

[lorenzo.ciolfi]

When undoing a checkout of a package body using Toad & Subversion with a package that contions ampersands and set define turned off the text after the ampersand is being changed to upper case.

For example:
cCCS_REQUEST := cCCS_REQUEST ||'&credit_exp=30&country=Canada&term='||TO_CHAR(nContract_Term);

is changed to :
cCCS_REQUEST := cCCS_REQUEST ||'&CREDIT_EXP=30&COUNTRY=Canada&TERM='||TO_CHAR(nContract_Term);

Anyone know how to get around this?

Thanx



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Norman Dunbar]

Post by lorenzo.ciolfi
When undoing a checkout of a package body using Toad & Subversion with a
package that contions ampersands and set define turned off the text
after the ampersand is being changed to upper case.
cCCS_REQUEST := cCCS_REQUEST
||'&credit_exp=30&country=Canada&term='||TO_CHAR(nContract_Term);
cCCS_REQUEST := cCCS_REQUEST
||'&CREDIT_EXP=30&COUNTRY=Canada&TERM='||TO_CHAR(nContract_Term);
Anyone know how to get around this?

Just a thought, does the same happen when you undo a change outside of
Toad? I'd have thought that Subversion would simply return the file to
the previous state and not mess about capitalising stuff.
--
Cheers,
Norm. [TeamT]


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[lorenzo.ciolfi]

Post by Norman Dunbar

Post by lorenzo.ciolfi
When undoing a checkout of a package body using Toad & Subversion with a
package that contions ampersands and set define turned off the text
after the ampersand is being changed to upper case.
cCCS_REQUEST := cCCS_REQUEST
||'&credit_exp=30&country=Canada&term='||TO_CHAR(nContract_Term);
cCCS_REQUEST := cCCS_REQUEST
||'&CREDIT_EXP=30&COUNTRY=Canada&TERM='||TO_CHAR(nContract_Term);
Anyone know how to get around this?

Just a thought, does the same happen when you undo a change outside of
Toad? I'd have thought that Subversion would simply return the file to
the previous state and not mess about capitalising stuff.
--
Cheers,
Norm. [TeamT]

Hi Norm,
No it doesn't happen outside of Toad




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Stephen Beausang]

I have tested this in 11.6 and can't seem to make it happen. I have tried both checkout/undo checkout and checkout, modify, compile, check in.

I'm not convinced it is a Team Coding issue, though open to suggestions.

I do not think it is coming from Subversion. As Norm says, SVN does not mess with capitalizing etc.
Team Coding uses a very basic parser to swap out Schema names and the like. This appears to totally ignore case. ..but it does appear to force the schema name to upper case if it is swapping schemas. As far I can tell , this is not what is happening here.

Stephen

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Norman Dunbar
Sent: Thursday, March 07, 2013 10:44 AM
To: ***@yahoogroups.com
Subject: Re: [toad] Subversion Changing Oracle Variables to Uppercase

Post by lorenzo.ciolfi
When undoing a checkout of a package body using Toad & Subversion with a
package that contions ampersands and set define turned off the text
after the ampersand is being changed to upper case.
cCCS_REQUEST := cCCS_REQUEST
||'&credit_exp=30&country=Canada&term='||TO_CHAR(nContract_Term);
cCCS_REQUEST := cCCS_REQUEST
||'&CREDIT_EXP=30&COUNTRY=Canada&TERM='||TO_CHAR(nContract_Term);
Anyone know how to get around this?

Just a thought, does the same happen when you undo a change outside of
Toad? I'd have thought that Subversion would simply return the file to
the previous state and not mess about capitalising stuff.

--
Cheers,
Norm. [TeamT]

[Stephen Beausang]

You might also check if editor option - Format Files when opened is turned on. This is outside my area of knowledge, but is there anything in the Formatter options that could cause this?

Stephen



From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Stephen Beausang
Sent: Thursday, March 07, 2013 11:11 AM
To: ***@yahoogroups.com
Subject: RE: [toad] Subversion Changing Oracle Variables to Uppercase


I have tested this in 11.6 and can't seem to make it happen. I have tried both checkout/undo checkout and checkout, modify, compile, check in.

I'm not convinced it is a Team Coding issue, though open to suggestions.

I do not think it is coming from Subversion. As Norm says, SVN does not mess with capitalizing etc.
Team Coding uses a very basic parser to swap out Schema names and the like. This appears to totally ignore case. ..but it does appear to force the schema name to upper case if it is swapping schemas. As far I can tell , this is not what is happening here.

Stephen

From: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Norman Dunbar
Sent: Thursday, March 07, 2013 10:44 AM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
Subject: Re: [toad] Subversion Changing Oracle Variables to Uppercase

Post by lorenzo.ciolfi
When undoing a checkout of a package body using Toad & Subversion with a
package that contions ampersands and set define turned off the text
after the ampersand is being changed to upper case.
cCCS_REQUEST := cCCS_REQUEST
||'&credit_exp=30&country=Canada&term='||TO_CHAR(nContract_Term);
cCCS_REQUEST := cCCS_REQUEST
||'&CREDIT_EXP=30&COUNTRY=Canada&TERM='||TO_CHAR(nContract_Term);
Anyone know how to get around this?

Just a thought, does the same happen when you undo a change outside of
Toad? I'd have thought that Subversion would simply return the file to
the previous state and not mess about capitalising stuff.

--
Cheers,
Norm. [TeamT]

[Norman Dunbar]

Post by Stephen Beausang
You might also check if editor option - Format Files when opened is
turned on. This is outside my area of knowledge, but is there anything
in the Formatter options that could cause this?

Good catch Stephen, I used to have that turned on, but when we switched
to using a source control system, I had to turn it off as it caused too
many "differences" when checked back in.
--
Cheers,
Norm. [TeamT]


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[lorenzo.ciolfi]

Post by Norman Dunbar

Post by Stephen Beausang
You might also check if editor option - Format Files when opened is
turned on. This is outside my area of knowledge, but is there anything
in the Formatter options that could cause this?

Good catch Stephen, I used to have that turned on, but when we switched
to using a source control system, I had to turn it off as it caused too
many "differences" when checked back in.
--
Cheers,
Norm. [TeamT]

All of the case options are set to "no change"




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Stephen Beausang]

Lorenzo,
I don't know much about how formatting options work, so I am probably missing something blatantly obvious :) I have turned on / off the available options and can't recreate this. Tested in Toad 10.6/ 11.6 and 12 beta and can't recreate.

Where is the option you turned off in Toad?

Stephen



From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of lorenzo.ciolfi
Sent: Thursday, March 07, 2013 11:44 AM
To: ***@yahoogroups.com
Subject: [toad] Re: Subversion Changing Oracle Variables to Uppercase

Post by Norman Dunbar

You might also check if editor option - Format Files when opened is
turned on. This is outside my area of knowledge, but is there anything
in the Formatter options that could cause this?

Good catch Stephen, I used to have that turned on, but when we switched
to using a source control system, I had to turn it off as it caused too
many "differences" when checked back in.
--
Cheers,
Norm. [TeamT]

All of the case options are set to "no change"

[lorenzo.ciolfi]

Post by Stephen Beausang
Lorenzo,
I don't know much about how formatting options work, so I am probably missing something blatantly obvious :) I have turned on / off the available options and can't recreate this. Tested in Toad 10.6/ 11.6 and 12 beta and can't recreate.
Where is the option you turned off in Toad?
Stephen
Sent: Thursday, March 07, 2013 11:44 AM
Subject: [toad] Re: Subversion Changing Oracle Variables to Uppercase

Post by Norman Dunbar

You might also check if editor option - Format Files when opened is
turned on. This is outside my area of knowledge, but is there anything
in the Formatter options that could cause this?

Good catch Stephen, I used to have that turned on, but when we switched
to using a source control system, I had to turn it off as it caused too
many "differences" when checked back in.
--
Cheers,
Norm. [TeamT]

All of the case options are set to "no change"

Select this from the Menu: View --> Options then select Formatter, open the Oracle Formatter Options then Case



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Stephen Beausang]

I have tried setting the various formatter options for this and still cannot recreate.
One last thing I suggest trying (actually Michael suggested). Check out the object. Open the object work file in the SVN working directory in any text editor to confirm that it is the correct formatting before checking back in. Copy the file and open that file in the editor. See if the editor tries to reformat it



From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of lorenzo.ciolfi
Sent: Thursday, March 07, 2013 12:29 PM
To: ***@yahoogroups.com
Subject: [toad] Re: Subversion Changing Oracle Variables to Uppercase

Post by Stephen Beausang
Lorenzo,
I don't know much about how formatting options work, so I am probably missing something blatantly obvious :) I have turned on / off the available options and can't recreate this. Tested in Toad 10.6/ 11.6 and 12 beta and can't recreate.
Where is the option you turned off in Toad?
Stephen
Sent: Thursday, March 07, 2013 11:44 AM
Subject: [toad] Re: Subversion Changing Oracle Variables to Uppercase

Post by Norman Dunbar

You might also check if editor option - Format Files when opened is
turned on. This is outside my area of knowledge, but is there anything
in the Formatter options that could cause this?

Good catch Stephen, I used to have that turned on, but when we switched
to using a source control system, I had to turn it off as it caused too
many "differences" when checked back in.
--
Cheers,
Norm. [TeamT]

All of the case options are set to "no change"

Select this from the Menu: View --> Options then select Formatter, open the Oracle Formatter Options then Case

[Michael Staszewski]

For a relatively quick way to rule out any Toad options...

1. Locate your "Application data directory" (appdata) by going to View|Options|General
2. Close Toad
3. Navigate to your appdata directory and rename it
4. Start Toad
5. Reproduce your scenario

If the case change goes away then it's an option setting and you can zip your appdata\User Files folder and send it to us offline. If the case change is still present then something else is going on and I'd start verifying that the case is as you expect on disk or in your source control provider.

Michael

-----Original Message-----
From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of lorenzo.ciolfi
Sent: Thursday, March 07, 2013 12:29 PM
To: ***@yahoogroups.com
Subject: [toad] Re: Subversion Changing Oracle Variables to Uppercase

Post by Stephen Beausang
Lorenzo,
I don't know much about how formatting options work, so I am probably missing something blatantly obvious :) I have turned on / off the available options and can't recreate this. Tested in Toad 10.6/ 11.6 and 12 beta and can't recreate.
Where is the option you turned off in Toad?
Stephen
Sent: Thursday, March 07, 2013 11:44 AM
Subject: [toad] Re: Subversion Changing Oracle Variables to Uppercase

Post by Norman Dunbar

You might also check if editor option - Format Files when opened
is turned on. This is outside my area of knowledge, but is there
anything in the Formatter options that could cause this?

Good catch Stephen, I used to have that turned on, but when we
switched to using a source control system, I had to turn it off as
it caused too many "differences" when checked back in.
--
Cheers,
Norm. [TeamT]

All of the case options are set to "no change"

Select this from the Menu: View --> Options then select Formatter, open the Oracle Formatter Options then Case



------------------------------------

Yahoo! Groups Links





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[Michael Staszewski]

I left out an important step below...

6. To revert to your previous settings, close Toad and delete the newly created appdata directory and restore your old one.

Recently Toad was modified to automatically bring settings over from older versions so the rename appdata directory trick may be get a little more involved if you've had older versions of Toad on this machine.

Michael

-----Original Message-----
From: Michael Staszewski
Sent: Thursday, March 07, 2013 2:17 PM
To: ***@yahoogroups.com
Subject: RE: [toad] Re: Subversion Changing Oracle Variables to Uppercase

For a relatively quick way to rule out any Toad options...

1. Locate your "Application data directory" (appdata) by going to View|Options|General 2. Close Toad 3. Navigate to your appdata directory and rename it 4. Start Toad 5. Reproduce your scenario

If the case change goes away then it's an option setting and you can zip your appdata\User Files folder and send it to us offline. If the case change is still present then something else is going on and I'd start verifying that the case is as you expect on disk or in your source control provider.

Michael

-----Original Message-----
From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of lorenzo.ciolfi
Sent: Thursday, March 07, 2013 12:29 PM
To: ***@yahoogroups.com
Subject: [toad] Re: Subversion Changing Oracle Variables to Uppercase

Post by Stephen Beausang
Lorenzo,
I don't know much about how formatting options work, so I am probably missing something blatantly obvious :) I have turned on / off the available options and can't recreate this. Tested in Toad 10.6/ 11.6 and 12 beta and can't recreate.
Where is the option you turned off in Toad?
Stephen
Sent: Thursday, March 07, 2013 11:44 AM
Subject: [toad] Re: Subversion Changing Oracle Variables to Uppercase

Post by Norman Dunbar

You might also check if editor option - Format Files when opened
is turned on. This is outside my area of knowledge, but is there
anything in the Formatter options that could cause this?

Good catch Stephen, I used to have that turned on, but when we
switched to using a source control system, I had to turn it off as
it caused too many "differences" when checked back in.
--
Cheers,
Norm. [TeamT]

All of the case options are set to "no change"

Select this from the Menu: View --> Options then select Formatter, open the Oracle Formatter Options then Case



------------------------------------

Yahoo! Groups Links





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[lorenzo.ciolfi]

Post by Michael Staszewski
I left out an important step below...
6. To revert to your previous settings, close Toad and delete the newly created appdata directory and restore your old one.
Recently Toad was modified to automatically bring settings over from older versions so the rename appdata directory trick may be get a little more involved if you've had older versions of Toad on this machine.
Michael
-----Original Message-----
From: Michael Staszewski
Sent: Thursday, March 07, 2013 2:17 PM
Subject: RE: [toad] Re: Subversion Changing Oracle Variables to Uppercase
For a relatively quick way to rule out any Toad options...
1. Locate your "Application data directory" (appdata) by going to View|Options|General 2. Close Toad 3. Navigate to your appdata directory and rename it 4. Start Toad 5. Reproduce your scenario
If the case change goes away then it's an option setting and you can zip your appdata\User Files folder and send it to us offline. If the case change is still present then something else is going on and I'd start verifying that the case is as you expect on disk or in your source control provider.
Michael
-----Original Message-----
Sent: Thursday, March 07, 2013 12:29 PM
Subject: [toad] Re: Subversion Changing Oracle Variables to Uppercase

Post by Stephen Beausang
Lorenzo,
I don't know much about how formatting options work, so I am probably missing something blatantly obvious :) I have turned on / off the available options and can't recreate this. Tested in Toad 10.6/ 11.6 and 12 beta and can't recreate.
Where is the option you turned off in Toad?
Stephen
Sent: Thursday, March 07, 2013 11:44 AM
Subject: [toad] Re: Subversion Changing Oracle Variables to Uppercase

Post by Norman Dunbar

You might also check if editor option - Format Files when opened
is turned on. This is outside my area of knowledge, but is there
anything in the Formatter options that could cause this?

Good catch Stephen, I used to have that turned on, but when we
switched to using a source control system, I had to turn it off as
it caused too many "differences" when checked back in.
--
Cheers,
Norm. [TeamT]

All of the case options are set to "no change"

Select this from the Menu: View --> Options then select Formatter, open the Oracle Formatter Options then Case
------------------------------------
Yahoo! Groups Links

Hi Michael,

I did what you suggested. The text after the & is still changed to uppercase but the text in the newly created appdata directory file is not. Doesn't that mean something in Toad is changing them to uppercase?




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[lorenzo.ciolfi]

Post by Stephen Beausang
I have tested this in 11.6 and can't seem to make it happen. I have tried both checkout/undo checkout and checkout, modify, compile, check in.
I'm not convinced it is a Team Coding issue, though open to suggestions.
I do not think it is coming from Subversion. As Norm says, SVN does not mess with capitalizing etc.
Team Coding uses a very basic parser to swap out Schema names and the like. This appears to totally ignore case. ..but it does appear to force the schema name to upper case if it is swapping schemas. As far I can tell , this is not what is happening here.
Stephen
Sent: Thursday, March 07, 2013 10:44 AM
Subject: Re: [toad] Subversion Changing Oracle Variables to Uppercase

Post by lorenzo.ciolfi
When undoing a checkout of a package body using Toad & Subversion with a
package that contions ampersands and set define turned off the text
after the ampersand is being changed to upper case.
cCCS_REQUEST := cCCS_REQUEST
||'&credit_exp=30&country=Canada&term='||TO_CHAR(nContract_Term);
cCCS_REQUEST := cCCS_REQUEST
||'&CREDIT_EXP=30&COUNTRY=Canada&TERM='||TO_CHAR(nContract_Term);
Anyone know how to get around this?

Just a thought, does the same happen when you undo a change outside of
Toad? I'd have thought that Subversion would simply return the file to
the previous state and not mess about capitalising stuff.
--
Cheers,
Norm. [TeamT]

Here are the exact steps:
1. Turn off variable substitution in Toad
2. Checkout a package body that has & in front of a literal string that is in lowercase (for example &country)
3. Make a change and save it to the database
4. Undo the checkout

After I do this the literal string with the & in front of it has been changed to uppercase



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/