could not change from SQLPLUS to SQL*PLUS in Jdeveloper [message #265487] |
Thu, 06 September 2007 07:27 |
shersaha
Messages: 2 Registered: September 2006
|
Junior Member |
|
|
Hi,
I am new in Jdeveloper. I have create one project. Now in design view , I have made some change in table. and then generated DDL. when I run the sql file( generated by jdeveloper) it ask the path for sql. I have supplied the path for sqlplus.
Then subsequent it uses that sqlplus. But I want to change it to use sql*plus. How can I do this ?
Thank in advance.
|
|
|
|
|
Re: could not change from SQLPLUS to SQL*PLUS in Jdeveloper [message #265674 is a reply to message #265487] |
Thu, 06 September 2007 23:47 |
shersaha
Messages: 2 Registered: September 2006
|
Junior Member |
|
|
once its path is set for sqlplus I can't change it. Even I try to delete the sqlplus so that jdeveloper will ask for new path but it did not ask for new path but says that sqlplus not found. If it ask for new path then I can set it as sql*plus but it don't ask. but did not.. so How can I set for sql*plus path for Jdeveloper.
thanks..
|
|
|
Re: could not change from SQLPLUS to SQL*PLUS in Jdeveloper [message #266300 is a reply to message #265487] |
Mon, 10 September 2007 07:28 |
hobbes
Messages: 173 Registered: January 2006
|
Senior Member |
|
|
To change the SQL*Plus path in JDeveloper, go to Tools -> Preferences -> Database Connnections and set the path in "SQL*Plus Executable". If this is unspecified, JDeveloper will prompt for the path at the time of running the script.
Hope this answers your question. I don't get the part about wanting to change the path from "sqlplus" to "sql*plus"!
|
|
|