How to compile a single form from command-line Oracle Forms 11g

Create a batch file and enter the following:

[bash]@echo off
echo.
echo. [ Forms Compiler ]
echo.
:: set varables
set FRMCMP=c:\Oracle\Middleware\as_1\bin\frmcmp.exe
set FORMS_DIR=c:\Users\Administrator\java\projects\DOMAIN_NAME\FormsReportsSystem\Forms
set USER_PATH=c:\Users\Administrator
set DEST=c:\FORM_EXECUTABLES
:: get input from console
set /p choice=  Type the form name (w/o extension):
set FORM_NAME=%choice%.fmb
echo.
cd %FORMS_DIR%\tmp
echo. Compiling…
:: command line execution
frmcmp.exe module=%FORMS_DIR%\tmp\%FORM_NAME% userid=user/pass@dbname module_type=form batch=yes compile_all=yes window_state=minimize
set FORM_FMX=%choice%.fmx
echo.        %choice%.fmx created.
echo.
echo. Copy to server…
copy /y %choice%.fmx %DEST%
echo. Done.
echo.
echo. Press any key to re-run…
pause > nul
cls
cd c:\Users\Administrator[/bash]

 

How to automate a commit/update with Tortoise SVN using a batch file

Your SVN project should already be checked out. Enter the following in a batch file (.bat):

[bash]@echo off
echo.
echo. [ SVN Committer ]
:: The two lines below should be changed to suit your system.
set SOURCE=C:\projects\my_svn_project\
set SVN=C:\Program Files\TortoiseSVN\bin
echo.
echo. Committing %SOURCE% to SVN…
“%SVN%\TortoiseProc.exe” /command:commit /path:”%SOURCE%” /closeonend:0
echo. done.
echo.
echo. Operation complete.[/bash]

[bash]@echo off
echo.
echo. [ SVN Updater ]
:: The SOURCEj below should be already set to fit your system.
echo. Updating %SOURCE%\ from SVN…
“%SVN%\TortoiseProc.exe” /command:update /path:”%SOURCE%\” /closeonend:2
echo.        done.
[/bash]

Note:
/closeonend:0 = bring up the dialog so you can select what files to commit
/closeonend:2 = omit the dialog and proceed with the operation

 

How to login with Windows Telnet automatically using vbs

Enter the following script and save it as a .vbs file:

[vb]Set obj = CreateObject(“WScript.Shell”)
obj.run”cmd”
WScript.Sleep 500

obj.SendKeys”telnet your.ip.add.ress”
obj.SendKeys(“{Enter}”)
WScript.Sleep 500

obj.SendKeys”username”  ‘telnet username
obj.SendKeys(“{Enter}”)
WScript.Sleep 500

obj.SendKeys”password”  ‘telnet password
obj.SendKeys(“{Enter}”)
WScript.Sleep 500

[/vb]