Program Window (compilation window) new session open?

[zoffob]

Hello I would like to use GitOra, but problem is that only way how to use it and log to it is using Single Session mode (but there are a lot of restrictions like NO debugging option)
Is there a way how to open SQL window (in dual or multi session mode) with the same session like Program window (procedure or package)? And run there some queries (co connect to the GitOra)?
Because how ever I try it is not possible. And I need to login to gitora in the same session.

Thank You
JZ

 

[Marco Kalter]

The SQL Window and Program Window will only use the same session in "Single Session" mode. In "Dual Session" mode the Program Window will use the main session, and the SQL Window will use the secondary session.

 

[zoffob]

. Are you planning to add ption that you can open SQL window with the same session like program (compiler) window later ?
Thank You

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Michiel.A]

Hi JZ,

I use Gitora myself and there are several ways to use Gitora with PL/SQL developer in dual or multi-session mode.

1) In the PLSQL Developer nstallation directory there is a AfterConnect.sql script that is executed for every connection you make to the database.
Put something like this in it:
begin
api_gitora.login(,);
end;

2) create a menu button that executes a script with api_gitora.login.
This will execute the script in the current session/window.
You can create a menu item like this:
- Go to menu Tools - Configure tools
- in the dialog click on the right side button 'New tool'
- On tab Genera:
-- Give it a name
-- choose 'session'
-- link it to a little script on disk that contains api_gitora.login
- on tab 'Options' select the 'active connection' and the windows you want the tool to work in
Close the dialog.

Add the tool to the menu (the tab 'Menu' in the tools dialog i did not get to work):
- right click somewhere in the menu gray area, and select 'Customize'
- on second tab 'Command' the last in the list (scrll down to see it) is 'User defined tools'
- click on your tool name and you can drag and drop the tool somewhere in a menu.

Now if you have an SQL window open, you can just click your tool button and it will log you into Gitora in the same session as the window..

3) create an on-logon trigger in the database that connects you to Gitora automatically once you make a connection to the db

Either of these should do the trick

You like Gitora?