Cannot commit changes in PL/SQL Code / Navigation to Body

[joste]

Hey there,

I'm currently evaluating the Trial Version to decide if we can use the product (if that matters).

I have the following problem:
When I edit a PL/SQL procedure (by choosing Edit in the menu) I can change the code within the window. However I cannot commit the changes to the database. The commit/rollback icons on the taskbar remain inactive.
Do you have any hints as to what I'm doing wrong? Do I have to start a transaction manually and how do I do this? It should not be an issue with the version being a Trial as it should be unrestricted, shouldn't it?
I can commit changes made to data within tables though.

Also is there a way when you navigate to an procedure contained in a package (via CTRL+click) that the body is opened instead of the declaration? Also it would be great if you can open the body or procedure automatically in Edit mode instead of View mode.

Thanks very much for your support and suggestions.

 

[Theod]

Hi joste,

you are right here ;-)

1) to compile an edited procedure you can only use the 'execute-button' or the Shortcut F9 (the default, witch you can change also)
2) CTRL+rigth-click opens the declaration instead of body
3) at Tools/Preferences/User Interface/Object Browser you change change some actions.

HTH

 

[William Robertson]

As Theod mentioned, you need to compile the code, not commit changes - it has nothing to do with transactions.

While hacking database source on the fly is occasionally handy in a development or test environment when you know that nobody else is likely to edit the same code, it's not a good idea as default behaviour. Normally you would work from version-controlled source files. I have it disabled in my preferences and use the Toggle Read-Only plug-in to switch to edit mode when I need it.

 

[joste]

Thanks Theod, that really helped a lot

As for the on-they-fly editing, yeah I know it is far away from the right thing, however it's not within my powers to establish a proper VCS for the database development...