Skip to Main Content

General Development Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OATS - Error when running application in Open Script

988362Feb 4 2013 — edited Feb 26 2013
Hi everyone,

I am new with OATS. I am trying to create a script for our application that is running on forms.

This is the error I get:

Java Plug-in 1.6.0_31
Using JRE version 1.6.0_31-b05 Java HotSpot(TM) Client VM
User home directory = C:\Users\a

----------------------------------------------------
c: clear console window
f: finalize objects on finalization queue
g: garbage collect
h: display this help message
l: dump classloader list
m: print memory usage
o: trigger logging
q: hide console
r: reload policy configuration
s: dump system and deployment properties
t: dump thread list
v: dump thread stack
x: clear classloader cache
0-5: set trace level to <n>
----------------------------------------------------

SSV dialog is suppressed
Loading Oracle ATS Forms Functional Testing Module[5.5] [Oracle JRE_1.6.0_31]
FormsFT Helper Temporary Directory: C:\Users\AGNES~1.ROX\AppData\Local\Temp\27\OpenScript_FormsFT
Loading cached Forms Jars ...
0...cached jar...file:/C:/Users/AGNES~1.ROX/AppData/Local/Temp/27/OpenScript_FormsFT/fnt1fmw101_9001/frmwebutil.jar
1...cached jar...file:/C:/Users/AGNES~1.ROX/AppData/Local/Temp/27/OpenScript_FormsFT/fnt1fmw101_9001/jacob.jar
Loading cached Forms Jars ...
2...cached jar...file:/C:/Users/AGNES~1.ROX/AppData/Local/Temp/27/OpenScript_FormsFT/fnt1fmw101_9001/frmall.jar
3...cached jar...file:/C:/Users/AGNES~1.ROX/AppData/Local/Temp/27/OpenScript_FormsFT/fnt1fmw101_9001/aoscbram.jar
4...cached jar...file:/C:/Users/AGNES~1.ROX/AppData/Local/Temp/27/OpenScript_FormsFT/fnt1fmw101_9001/myKeys.jar
5...http://fnt1fmw101:9001/forms/BramptonJava/GetDefaultPrinter.jar
6...cached jar...file:/C:/Users/AGNES~1.ROX/AppData/Local/Temp/27/OpenScript_FormsFT/fnt1fmw101_9001/timeout.jar
cracked oracle.forms.engine.Main
Forms Version: 11.1.1.6
RegisterWebUtil - Loading WebUtil Version 11.1.1.6
cracked oracle.forms.engine.Runform
cracked oracle.ewt.lwAWT.LWScrollbar
cracked oracle.forms.net.SocketConnection
servarg:escapeParams=true module=pdmain6.fmx userid= debug=no host= port= obr=no record=names tracegroup= log= term= ssoProxyConnect=no
Forms Session ID is formsapp.243
cracked oracle.forms.net.HTTPConnection
The proxy host is null, and the proxy port is 0.
Native HTTP implementation is being used for the connection.
The connection mode is HTTP.
Forms Applet version is 11.1.1.6
Initialize logging by default options
******Applet Initiator starting from Forms Engine now.
[INFO] Applet Initiator starts
[INFO] Applet [Ewt Addon] Activated
setProperty: 7777
ini file : C:\Users\AGNES~1.ROX\AppData\Local\Temp\27\OpenScript_Applet
cracked oracle.ewt.lwAWT.lwText.LWTextComponent
2013-02-04 12:06:46 456 INFO [oracle.oats.scripting.modules.formsFT.helper.helperService.HelperServiceConnection] Send Message: <Message name="RegisterHelper" browserId="4212" moduleId="oracle.oats.scripting.modules.formsFT" />
2013-02-04 12:06:46 456 INFO [oracle.oats.scripting.modules.formsFT.helper.helperService.HelperServiceConnection] Receive message :<Message name = "StartConnection" port="7778"/>
Helper Service Message :<Message name = "StartConnection" port="7778"/>
cracked oracle.forms.handler.LogonDialog
cracked oracle.forms.handler.TextFieldItem
cracked oracle.forms.handler.ListValuesDialog
cracked oracle.forms.handler.EditorDialog
cracked oracle.forms.handler.HelpDialog
cracked oracle.forms.handler.AlertDialog
******new forms Client
****** set a new recorder:oracle.oats.scripting.modules.formsFT.common.api.internal.automation.FormsClientOpenScript server port is 7778
****** Connect to applet using CommunicationLayer
******CMD_REQUEST_RECORDING_IDENTITY received
2013-Feb-04 12:06:47.49 WUI[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2013-Feb-04 12:06:47.95 WUF[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2013-Feb-04 12:06:47.95 WUH[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2013-Feb-04 12:06:47.95 WUS[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2013-Feb-04 12:06:47.111 WUT[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2013-Feb-04 12:06:47.142 WUO[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2013-Feb-04 12:06:47.142 WUL[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2013-Feb-04 12:06:47.142 WUB[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
cracked oracle.ewt.alert.AlertPane
2013-02-04 12:06:47 392 INFO [oracle.oats.scripting.modules.applet.helper.communication.CommunicationLayer] Start ComunnicationLayer with process id:5632 Server Port :7777
Window created = sun.plugin2.main.client.PluginEmbeddedFrame[frame0,0,0,1280x1024,invalid,layout=java.awt.BorderLayout,title=,resizable,normal]
2013-02-04 12:06:47 407 INFO [oracle.oats.scripting.modules.applet.helper.communication.CommunicationLayer] Message Received: oracle.oats.scripting.modules.applet.common.api.internal.event.AgentAcknowledgeEvent
2013-02-04 12:06:47 407 INFO [oracle.oats.scripting.modules.applet.helper.communication.CommunicationLayer] Start Recording
2013-Feb-04 12:06:47.579 WUI[setProperty()] Setting property WUC_SYSLIB_DIR to :FNT1FMW101:brampton_aosc
2013-Feb-04 12:06:47.579 WUI[getProperty()] Getting property WUC_BEAN_VERSION
2013-Feb-04 12:06:47.595 WUT[setProperty()] Setting property WUC_BLOCK_ALLOW_HEART_BEAT to 0
2013-Feb-04 12:06:47.595 WUT[setProperty()] Setting property WUC_SRV_LOGGING to 0
2013-Feb-04 12:06:47.595 WUT[setProperty()] Setting property WUC_GET_LOCAL_PROPERTY to syslib.jacob.dll
2013-Feb-04 12:06:47.595 WUT[getProperty()] Getting property WUC_GET_LOCAL_PROPERTY
2013-Feb-04 12:06:47.595 WUT[loadSettings()] Local properties file loaded
2013-Feb-04 12:06:47.595 WUT[setProperty()] Setting property WUC_GET_LOCAL_PROPERTY to syslib.JNIsharedstubs.dll
2013-Feb-04 12:06:47.595 WUT[getProperty()] Getting property WUC_GET_LOCAL_PROPERTY
2013-Feb-04 12:06:47.595 WUT[setProperty()] Setting property WUC_GET_LOCAL_PROPERTY to syslib.d2kwut60.dll
2013-Feb-04 12:06:47.595 WUT[getProperty()] Getting property WUC_GET_LOCAL_PROPERTY
2013-Feb-04 12:06:47.610 WUB[setProperty()] Setting property WUC_BLOCK_ALLOW_HEART_BEAT to 0
2013-Feb-04 12:06:47.610 WUB[setProperty()] Setting property WUC_SRV_LOGGING to 0
2013-Feb-04 12:06:47.610 WUL[setProperty()] Setting property WUC_BLOCK_ALLOW_HEART_BEAT to 0
2013-Feb-04 12:06:47.610 WUL[setProperty()] Setting property WUC_SRV_LOGGING to 0
2013-Feb-04 12:06:47.610 WUO[setProperty()] Setting property WUC_BLOCK_ALLOW_HEART_BEAT to 0
2013-Feb-04 12:06:47.610 WUO[setProperty()] Setting property WUC_SRV_LOGGING to 0
2013-Feb-04 12:06:47.610 WUS[setProperty()] Setting property WUC_BLOCK_ALLOW_HEART_BEAT to 0
2013-Feb-04 12:06:47.610 WUS[setProperty()] Setting property WUC_SRV_LOGGING to 0
2013-Feb-04 12:06:47.610 WUH[setProperty()] Setting property WUC_BLOCK_ALLOW_HEART_BEAT to 0
2013-Feb-04 12:06:47.610 WUH[setProperty()] Setting property WUC_SRV_LOGGING to 0
2013-Feb-04 12:06:47.610 WUF[setProperty()] Setting property WUC_BLOCK_ALLOW_HEART_BEAT to 0
2013-Feb-04 12:06:47.610 WUF[setProperty()] Setting property WUC_SRV_LOGGING to 0
2013-Feb-04 12:06:47.610 WUI[setProperty()] Setting property WUC_SRV_LOGGING to 0
2013-Feb-04 12:06:47.610 WUI[setProperty()] Setting property WUC_BLOCK_ALLOW_HEART_BEAT to 0
2013-Feb-04 12:06:47.610 WUI[setProperty()] Setting property WUC_SRV_LOGGING to 0
2013-Feb-04 12:06:48.31 WUB[setProperty()] Setting property WUB_SEPARATEFRAME_ICON to Pd.gif
2013-Feb-04 12:06:48.31 WUB[BrowserFunctions.setSeparateFrameIcon()] Not running in separateFrame - Icon not set
cannot determine src CompInfo topNode = TJavaWindow bottom parent node=TJavaCombobox
cannot determine src CompInfo topNode = TJavaWindow bottom parent node=TJavaCombobox
***** create DelayRecorderThread
****** DelayRecorderThread started...
****** DelayRecorderThread run now ...
......Forms Recording: OracleForms.windowChange(" Logon to TDS/OS%screenshot=C:\Users\AGNES~1.ROX\AppData\Local\Temp\27\OSFFSS\screen1359997613382.jpg");
......Forms Recording: OracleForms.list("//forms:list[(@name='LOGON_CNT_STR_0')]").selectItem("BRPQA");
......Forms Recording: OracleForms.textField("//forms:textField[(@name='LOGON_UN_0')]").click();
......Forms Recording: OracleForms.textField("//forms:textField[(@name='LOGON_UN_0')]").setText("PDMAIN");
......Forms Recording: OracleForms.textField("//forms:textField[(@name='LOGON_PW_0')]").click();
......Forms Recording: OracleForms.textField("//forms:textField[(@name='LOGON_PW_0')]").setText("pdmain");
......Forms Recording: OracleForms.button("//forms:button[(@name='LOGON_LOGON_0')]").click();
FRM-92091: unexpected fatal error in client-side Java code
Java Exception:
java.lang.NullPointerException
at oracle.ewt.scrolling.arrowBox.ArrowBox.removeAdjustmentListener(Unknown Source)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener$4.run(CompositeAwtEventListener.java:260)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener.installListeners(CompositeAwtEventListener.java:390)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.superInstallListeners(SwingListenerMgr.java:1791)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.access$100(SwingListenerMgr.java:315)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener$2.run(SwingListenerMgr.java:537)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.installListeners(SwingListenerMgr.java:970)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener$4.run(CompositeAwtEventListener.java:380)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener.installListeners(CompositeAwtEventListener.java:390)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.superInstallListeners(SwingListenerMgr.java:1791)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.access$100(SwingListenerMgr.java:315)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener$2.run(SwingListenerMgr.java:537)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.installListeners(SwingListenerMgr.java:970)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener$4.run(CompositeAwtEventListener.java:380)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener.installListeners(CompositeAwtEventListener.java:390)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.superInstallListeners(SwingListenerMgr.java:1791)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.access$100(SwingListenerMgr.java:315)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener$2.run(SwingListenerMgr.java:537)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.installListeners(SwingListenerMgr.java:970)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener$4.run(CompositeAwtEventListener.java:380)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener.installListeners(CompositeAwtEventListener.java:390)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.superInstallListeners(SwingListenerMgr.java:1791)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.access$100(SwingListenerMgr.java:315)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener$2.run(SwingListenerMgr.java:537)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.installListeners(SwingListenerMgr.java:970)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener$3.run(CompositeAwtEventListener.java:179)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener.installListeners(CompositeAwtEventListener.java:194)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.superInstallListeners(SwingListenerMgr.java:1786)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.access$000(SwingListenerMgr.java:315)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener$1.run(SwingListenerMgr.java:506)
at oracle.oats.scripting.modules.applet.helper.observer.SwingListenerMgr$CompositeSwingEventListener.installListeners(SwingListenerMgr.java:515)
at oracle.oats.scripting.modules.applet.helper.observer.CompositeAwtEventListener.componentAdded(CompositeAwtEventListener.java:730)
at java.awt.AWTEventMulticaster.componentAdded(Unknown Source)
at java.awt.Container.processContainerEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.processEventImpl(Unknown Source)
at oracle.ewt.lwAWT.lwWindow.DesktopContainer.processEventImpl(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.Container.addImpl(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.addImpl(Unknown Source)
at java.awt.Container.add(Unknown Source)
at oracle.ewt.lwAWT.lwWindow.DesktopContainer.setWindowPosition(Unknown Source)
at oracle.ewt.lwAWT.lwWindow.LWWindow._moveToFront(Unknown Source)
at oracle.ewt.lwAWT.lwWindow.LWWindow.setActive(Unknown Source)
at oracle.ewt.lwAWT.lwWindow.LWWindow.setVisible(Unknown Source)
at oracle.forms.ui.ExtendedFrame.setVisible(Unknown Source)
at oracle.ewt.lwAWT.lwWindow.LWWindow.setVisible(Unknown Source)
at oracle.forms.handler.FormWindow.doShowComponent(Unknown Source)
at oracle.forms.handler.UICommon.onComponentUpdate(Unknown Source)
at oracle.forms.handler.UICommon.onUpdate(Unknown Source)
at oracle.forms.handler.FormWindow.onUpdate(Unknown Source)
at oracle.forms.handler.UICommon.onUpdate(Unknown Source)
at oracle.forms.engine.Runform.onUpdateHandler(Unknown Source)
at oracle.forms.engine.Runform.processMessage_C(Unknown Source)
at oracle.forms.engine.Runform.processMessage(Unknown Source)
at oracle.forms.engine.Runform.processSet(Unknown Source)
at oracle.forms.engine.Runform.onMessageReal(Unknown Source)
at oracle.forms.engine.Runform.onMessage_C(Unknown Source)
at oracle.forms.engine.Runform.onMessage(Unknown Source)
at oracle.forms.engine.Runform.processEventEnd(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at oracle.forms.engine.Main.dispatchEvents(Unknown Source)
at oracle.forms.engine.Main.tryDispatching(Unknown Source)
at oracle.forms.engine.Main.componentResized(Unknown Source)
at java.awt.Component.processComponentEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at oracle.ewt.lwAWT.BufferedApplet.processEventImpl(Unknown Source)
at oracle.ewt.lwAWT.BufferedApplet.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

2013-02-04 12:07:13 548 INFO [oracle.oats.scripting.modules.formsFT.helper.Engine] Destory runform: oracle.forms.engine.Runform@5976c2
......Forms Recording: OracleForms.dispose();
2013-02-04 12:07:13 595 INFO [oracle.oats.scripting.modules.formsFT.helper.Engine] Forms FT helper stopping message is sent out
2013-Feb-04 12:07:19.804 WUB[VBeanCommon.destroy()] WebUtil Browser Functions being removed..
2013-Feb-04 12:07:19.804 WUL[VBeanCommon.destroy()] WebUtil C API Functions being removed..
2013-Feb-04 12:07:20.38 WUO[VBeanCommon.destroy()] WebUtil Client Side Ole Functions being removed..
2013-Feb-04 12:07:20.53 WUT[VBeanCommon.destroy()] WebUtil File Transfer Bean being removed..
2013-Feb-04 12:07:20.53 WUS[VBeanCommon.destroy()] WebUtil Session Monitoring Facilities being removed..
2013-Feb-04 12:07:20.69 WUH[VBeanCommon.destroy()] WebUtil Client Side Host Commands being removed..
2013-Feb-04 12:07:20.69 WUF[VBeanCommon.destroy()] WebUtil Client Side File Functions being removed..
2013-Feb-04 12:07:20.85 WUI[VBeanCommon.destroy()] WebUtil GetClientInfo Utility being removed..

Comments

/nolog - there's no connection, so how could module be set?

On connect, SQLcl is set as module for the session.

Kris Rice-Oracle

I'm confused why you run sqlplus at all  anymore

Craig Elliott

For myself, I am using SQLcl, but sometimes I have to use SQL*Plus to connect using external authentication(RADIUS), since I have not figured out how to get SQLcl to work with RADIUS.  Maybe once InstantClient 12 is released this will work?

Macbook ENV vars used:

SQLPATH=/oracle/common_sql

SQLCL=/oracle/instantclient_11_2/sqlcl/bin

TNS_ADMIN=/oracle/instantclient_11_2/network/admin

ORACLE_HOME=/oracle/instantclient_11_2

JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home

In my $SQLPATH/login.sql file, I have:

--********************

--  COMMON CALLS

--   Add any SQL*Plus commands here that are to be executed when a

--   user starts SQL*Plus, or uses the SQL*Plus CONNECT command

-- Used by Trusted Oracle

COLUMN ROWLABEL FORMAT A15

-- Used for the SHOW ERRORS command

COLUMN LINE/COL FORMAT A8

COLUMN ERROR    FORMAT A65  WORD_WRAPPED

-- Used for the SHOW SGA command

COLUMN name_col_plus_show_sga FORMAT a24

COLUMN units_col_plus_show_sga FORMAT a15

-- Defaults for SHOW PARAMETERS

COLUMN name_col_plus_show_param FORMAT a36 HEADING NAME

COLUMN value_col_plus_show_param FORMAT a30 HEADING VALUE

-- Defaults for SHOW RECYCLEBIN

COLUMN origname_plus_show_recyc   FORMAT a16 HEADING 'ORIGINAL NAME'

COLUMN objectname_plus_show_recyc FORMAT a30 HEADING 'RECYCLEBIN NAME'

COLUMN objtype_plus_show_recyc    FORMAT a12 HEADING 'OBJECT TYPE'

COLUMN droptime_plus_show_recyc   FORMAT a19 HEADING 'DROP TIME'

-- Defaults for SET AUTOTRACE EXPLAIN report

-- These column definitions are only used when SQL*Plus

-- is connected to Oracle 9.2 or earlier.

COLUMN id_plus_exp FORMAT 990 HEADING i

COLUMN parent_id_plus_exp FORMAT 990 HEADING p

COLUMN plan_plus_exp FORMAT a60

COLUMN object_node_plus_exp FORMAT a8

COLUMN other_tag_plus_exp FORMAT a29

COLUMN other_plus_exp FORMAT a44

-- Default for XQUERY

COLUMN result_plus_xquery HEADING 'Result Sequence'

--

--********************

--CUSTOM from here

--

column bytes format 999,999,999,999

column total_bytes format 999,999,999,999

col segment_name format a30

col table_name format a30

col segment_type format a20

col tablespace_name format a20

col file_name format a60

col db_link format a40

col host format a30

--********************

--SQL*Plus OR SQLcl determination from here

SET VERIFY OFF DEFINE ON ECHO OFF

COL SQLFILE FORMAT a200

COL SQLFILE NEW_VALUE sqllogin;

select decode (sys_context ('USERENV', 'MODULE'), 'SQLcl', 'sqlcl_login.sql', 'sqlplus_login.sql') sqlfile from dual

/

@/oracle/common_sql/&sqllogin

--********************

--  COMMON CALLS

--  spool file and prompts from here

COL SPOOLFILE FORMAT a200

COL SPOOLFILE NEW_VALUE SPOOL;

COL SYSTIMESTAMP FORMAT a38

SELECT '/oracle/spoolfiles/'||USER||'_'||GLOBAL_NAME||'_'||TO_CHAR(SYSDATE,'DD_MON_YYYY_HH24MISS')||'.lst' spoolfile FROM GLOBAL_NAME;

spool &spool

PROMPT ---*************************-------------------

PROMPT -- Note: SQLBLANKLINES is ON

PROMPT -- Note: ECHO is ON

PROMPT -- Note: DEFINE is OFF

PROMPT ---*************************-------------------

COL "TAKE NOTE" FORMAT a80

Select 'Scripts will run on ' || GLOBAL_NAME || ' as ' || USER "TAKE NOTE" FROM GLOBAL_NAME;

SELECT SYSTIMESTAMP "DATE/TIME" FROM DUAL;

PROMPT -----------------------------------------------

SET VERIFY ON DEFINE OFF ECHO ON

---

In my sqlcl_login.sql OR sqlplus_login.sql files, I have the SET commands that are specific to that application.

thatJeffSmith-Oracle

Ahhh, you're on a Mac...This should work on Windows at least.

Brad_the_Dazed

Maybe I'm resurrecting the dead, but SYS_CONTEXT('USERENV','MODULE') doesn't seem to get set for SQLcl initially ... only after set appinfo on

$ $HOME/sqlcl/bin/sql

SQLcl: Release 17.3.0 Production on Thu Oct 19 11:16:48 2017

Copyright (c) 1982, 2017, Oracle.  All rights reserved.

...  user and password connection info ...

SQL> select sys_context ('USERENV', 'MODULE') from dual;

SYS_CONTEXT('USERENV','MODULE')

---------------------------------------------------------------------------------------------------------------------------

java@myhostname (TNS V1-V3)

SQL> show java

Java Detail

-----------

java.home= /usr/java/jdk1.8.0_92/jre

java.vendor= Oracle Corporation

java.vendor.url= http://java.oracle.com/

java.version= 1.8.0_92

---------------------------------------------------------------------------------------------------------------------------

os.arch= amd64

os.name= Linux

SQL> set appinfo on

SQL> select sys_context ('USERENV', 'MODULE') from dual;

SYS_CONTEXT('USERENV','MODULE')

---------------------------------------------------------------------------------------------------------------------------

SQLcl

(oh, while researching, another site copied this forum ...

SQLcl -  login.sql  - dedect if login.sql is called from SQLcL or from SQL*Plus - SQLcl )

Gary Graham-Oracle

This works on Windows...

C:\Tools\sqlcl\r17_3_1\sqlcl\bin>sql scott/tiger@xe

SQLcl: Release 17.3.0 Production on Thu Oct 19 11:31:51 2017

Copyright (c) 1982, 2017, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> show version

Oracle SQLDeveloper Command-Line (SQLcl) version: 17.3.0.256.1818

SQL> select sys_context('USERENV','MODULE') from dual;

SYS_CONTEXT('USERENV','MODULE')

--------------------------------------------------------------------------------

SQLcl

SQL>

And...

SQL> show appinfo

appinfo is OFF and set to "SQLcl"

SQL>

Brad_the_Dazed

Such sweet o/s love ... or lack thereof ... the unix version needs to be burped ...  :-)

SQL> show appinfo

appinfo is OFF and set to "SQLcl"

SQL> select sys_context('USERENV','MODULE') from dual;

SYS_CONTEXT('USERENV','MODULE')

----------------------------------------------------------------------------------------------------------------------------------------------

java@oquin2 (TNS V1-V3)

SQL> set appinfo on

SQL> set appinfo off

SQL> select sys_context('USERENV','MODULE') from dual;

SYS_CONTEXT('USERENV','MODULE')

----------------------------------------------------------------------------------------------------------------------------------------------

SQLcl

SQL> show version

Oracle SQLDeveloper Command-Line (SQLcl) version: 17.3.0.256.1818

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 26 2013
Added on Feb 4 2013
5 comments
2,123 views