Home » Developer & Programmer » JDeveloper, Java & XML » I Can't launch sqlplus from JDeveloper (JDeveloper, 10.1.3.2.0, Mac OS X 10.5.4)
- I Can't launch sqlplus from JDeveloper [message #348825] Thu, 18 September 2008 00:44 Go to next message
MSTRKRFT
Messages: 2
Registered: September 2008
Junior Member
In JDeveloper under tools -> preferences -> database connections and the SQL*PLUS setting I have the following:

/Applications/Utilities/Terminal.app/Contents/MacOS/Terminal & /opt/oracle/instantclient/sqlplus

If I control+click (right click) on an open sql file and choose Run in SQL*Plus it doesn't work even though I have the database connection set up. The exact same configuration works fine on windows.

sqlplus is installed correctly as I can start it in the terminal and run it just fine. This is what I have had to do thus far.

SQL*plus version is:
Version 10.2.0.4


[Updated on: Thu, 18 September 2008 00:46]

Report message to a moderator

- Re: I Can't launch sqlplus from JDeveloper [message #348844 is a reply to message #348825] Thu, 18 September 2008 01:53 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Define "it doesn't work".

Does Terminal open?
Does sqlplus open but not open the script?
- Re: I Can't launch sqlplus from JDeveloper [message #349006 is a reply to message #348844] Thu, 18 September 2008 09:41 Go to previous messageGo to next message
MSTRKRFT
Messages: 2
Registered: September 2008
Junior Member
"Doesn't work" as in the terminal pops up I enter my username and password then I receive the following message....

ORA-12545: Connect failed because target host or object does not exist

jdeveloper output window displays the following:

Invoking SQL*Plus...
/Applications/Utilities/Terminal.app/Contents/MacOS/Terminal /opt/oracle/instantclient/sqlplus MSTRKRFT@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle.cis.ksu.edu)(PORT=1521)))(CONNECT_DATA=(SID=ORACLE)))


[Updated on: Thu, 18 September 2008 14:30]

Report message to a moderator

- Re: I Can't launch sqlplus from JDeveloper [message #349063 is a reply to message #349006] Thu, 18 September 2008 15:11 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Does that tns connection info look ok to you? Can you compare it to the jdbc-url you use? (You _are_ able to connect through the Database Connection in JDev, right?)
Previous Topic: Help ! Extract data from XML result in PL/SQL
Next Topic: Call Stored Proc' with Array of Objects
Goto Forum:
  


Current Time: Wed Dec 18 06:48:47 CST 2024