Kinook Software Forums

Kinook Software Forums (http://www.kinook.com/Forum/index.php)
-   [VBP] Third Party Tools (http://www.kinook.com/Forum/forumdisplay.php?f=3)
-   -   How do you run script using Oracle SQL Develloper silently? (http://www.kinook.com/Forum/showthread.php?t=3131)

ambalboa 10-16-2007 06:18 PM

How do you run script using Oracle SQL Develloper silently?
 
I am having trouble running Oracle SQL Developer silently. I am trying to run a sql script file using the 'Run Program' action step and I entered the following on the Command field:

"C:\SQL Developer\sqldeveloper-1.1.2.2579\sqldeveloper\sqldeveloper.exe" sqlplus "username/password@oracleserver"

Note, the username, password and oracleserver are the values I enter accordingly (no spaces, no quotes). On the Input tab, I enter the .sql file name. I also entered it as a string, as in @C:\FILEPATH\FILENAME.sql and the oracle program just opens up, it doesn't even run the script file. I have been unsuccessful in running the script file every time. I am able to do this by calling the command prompt (cmd.exe, by using the %DOSCMD% system macro) but not this way. Any help would be greatly appreciated. Thanks.

ambalboa 10-16-2007 06:35 PM

Also, I have the "Hide application window" option checked. It doesn't seem to work.

kinook 10-16-2007 09:01 PM

Oracle SQL Developer is a graphical tool. Use the SQL*Plus command-line tool for automating Oracle tasks.
http://www.orafaq.com/faq/sqlplus
http://www.visualbuild.com/Manual/oracle.htm

ambalboa 10-17-2007 10:09 AM

Am I right in doing it with %DOSCMD%? I suppose doing it with Oracle SQL Developer is not possible? Thanks for your response.

kinook 10-17-2007 11:53 AM

I don't know exactly what you're doing with %DOSCMD%, but as they say, "if it ain't broke, don't fix it."

ambalboa 10-17-2007 12:45 PM

Yes, I agree with that and it seems to be working fine with the command-prompt. Basically, I am calling SQLPlus from the command-prompt, and it runs the script file but my co-workers are telling me that Oracle SQL Developer's output is easier to understand for debugging purposes. They tell me that the reason for not being able to automate the script run is because some sqlplus statements are incompatible with sql worksheet in Oracle SQL Developer. They suggest I modify the .sql file by replacing certain syntax with PL/SQL syntax. You say this is a graphical tool, so even if the modifications are made, can it be automated and included in the build process I created?

kinook 10-17-2007 12:58 PM

I downloaded Oracle SQL Developer v1.2.1. When launched without parameters, a GUI app opened, and when launched with sqldeveloper -?, it displayed this message box

---------------------------
Oracle SQL Developer
---------------------------
Commands:

-verbose Show JNI options
-client Use Client as the Java VM
-server Use Hotspot Server as the Java VM
--= Override a directive from the configuration file
-J Pass directly to the runtime system
-conf[igure] Use the specified configuration file
-multi Start a new instance
-migrate Migrate user settings from a previous installation

---------------------------
OK
---------------------------

I didn't see much more in the help regarding calling it from the command-line, so my guess is that it's not amenable to performing automated SQL statements and is meant to be an interactive tool. At any rate, you should contact Oracle for further information about it.


All times are GMT -5. The time now is 12:18 AM.


Copyright 1999-2019 Kinook Software, Inc.