Home » SQL & PL/SQL » Client Tools » Need help regarding notepad++ integration with plsql (oracle 11g, win 7-64 bit)
Need help regarding notepad++ integration with plsql [message #523884] Tue, 20 September 2011 23:06 Go to next message
sultan1205
Messages: 4
Registered: September 2011
Location: Bangladesh
Junior Member
Hi guys, i am trying to make notepad++ my default plsql editor.
that means when i double click plsql.exe then notepad++ should open up.
i am using oracle 11g.
I would be glad if some one could help me out.....
Re: Need help regarding notepad++ integration with plsql [message #523887 is a reply to message #523884] Wed, 21 September 2011 00:10 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
PLSQL.EXE? I don't think that you really want to use Notepad++ to open your EXE files.

Anyway: run Notepad++, go to Settings - Preferences - File Association tab. There's SQL in supported extensions, but you can add any other you want - Click "Customize", put (for example) .PKB, .PKS, ... into a field (one by one) and move them into the "Registered extensions".
Re: Need help regarding notepad++ integration with plsql [message #523946 is a reply to message #523887] Wed, 21 September 2011 04:23 Go to previous messageGo to next message
sultan1205
Messages: 4
Registered: September 2011
Location: Bangladesh
Junior Member
alright i tried that already. ok what i need is if there is any way to connect notepad++ with oracle database with login permission so that everytime i do not need to open plsql.exe(black screen cmd promt mode) ??? i don't know whether i was able to make it clear ? thanx...
Re: Need help regarding notepad++ integration with plsql [message #523962 is a reply to message #523946] Wed, 21 September 2011 05:27 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
What is plsql.exe?
Re: Need help regarding notepad++ integration with plsql [message #523963 is a reply to message #523962] Wed, 21 September 2011 05:31 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That would be SQL*Plus executable, I suppose.

If that's true, your request is still awkward, Sultan. Are you saying that you'd want to run your scripts directly from Notepad++ (instead of starting a tool that is used to connect to the database, such as SQL*Plus, and then running the script itself)? If so, I'm afraid that Notepad++'s capabilities are far from that.
Re: Need help regarding notepad++ integration with plsql [message #523998 is a reply to message #523963] Wed, 21 September 2011 06:24 Go to previous messageGo to next message
sultan1205
Messages: 4
Registered: September 2011
Location: Bangladesh
Junior Member
ok, actually when i worked in my previous office, i used to work on that environment. i mean i was able to run any queries or writing functions,procedures directly on notepad++ . i donno how to do that. but i worked with that . if u guyz know how to make that configuration please let me know...
thanks guyz ...
Re: Need help regarding notepad++ integration with plsql [message #524000 is a reply to message #523998] Wed, 21 September 2011 06:27 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Never heard of such an option, sorry. Perhaps you should ask people in your previous office. Don't forget to share the solution (once you find it).
Re: Need help regarding notepad++ integration with plsql [message #524019 is a reply to message #524000] Wed, 21 September 2011 07:01 Go to previous messageGo to next message
ThomasG
Messages: 3099
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
I'm sure it's actually the other way around. Have a file open in Notepad++ and execute that file with sqlplus.exe

That can be configured in Notepad++ in the Command configuration
Re: Need help regarding notepad++ integration with plsql [message #524026 is a reply to message #524019] Wed, 21 September 2011 07:35 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
*Maybe* I found the way:

  • Run Notepad++
  • Press F6 (executes NppExec plugin) or go to Plugins - NppExec - Execute ...
  • Into the Command(s) window, put the following lines:
    npp_save
    cd $(CURRENT_DIRECTORY)
    sqlplus scott/tiger@ora10

    It is supposed to
    - save the current file
    - go to current directory
    - start SQL*Plus
  • The Console window is opened, with you connected as Scott:
    ./fa/9384/0/
  • Now edit your SQL script, save it. Run it in the Console window using "@file_name" syntax:
    ./fa/9385/0/


I'm not that smart myself, great help was this walkthrough.

I don't know whether it is possible to run the current file using some keyboard shortcut (yes, I saved my NppExec plugin command script, created a shortcut (Ctrl + E), but this just opens a console, it doesn't run the SQL script itself).

Maybe someone else knows how to do that; for me, @file_name is good enough.
  • Attachment: npp_2.png
    (Size: 56.48KB, Downloaded 1971 times)
  • Attachment: npp_1.png
    (Size: 43.59KB, Downloaded 1943 times)
Re: Need help regarding notepad++ integration with plsql [message #524060 is a reply to message #524026] Wed, 21 September 2011 10:20 Go to previous messageGo to next message
sultan1205
Messages: 4
Registered: September 2011
Location: Bangladesh
Junior Member
1 question : just tell me any 1 using oracle database 10g enterprise edition that, does the sql*plus window look like this 1???

./fa/9388/0/

cause this is the thing i was looking for.
If it is included in oracle database 10g enterprise edition
then problem is solved.

just tell me someone whether it looks like it or not....
  • Attachment: Untitled.jpg
    (Size: 81.19KB, Downloaded 2003 times)
Re: Need help regarding notepad++ integration with plsql [message #524065 is a reply to message #524060] Wed, 21 September 2011 11:11 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
That's sqlplusw - the GUI version of sqlplus. It's included with the oracle client install.
Re: Need help regarding notepad++ integration with plsql [message #524067 is a reply to message #524065] Wed, 21 September 2011 11:26 Go to previous message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
V10 is no longer fully supported.
Does sqlplusw exist for any supported Oracle version?
Previous Topic: thirdparty for alert....any kind of alert
Next Topic: Generate Insert script for existing table data
Goto Forum:
  


Current Time: Fri Aug 29 09:59:17 CDT 2014

Total time taken to generate the page: 0.16378 seconds