SQL WorkSheet

Posted on 2003-03-19
Medium Priority
Last Modified: 2012-08-14

I used to have SQL Worksheet with Oracle 7.3.
When i wanted to start it, all I had to do is to click on a shortcut.  I didn't have to enter the username and password.  In the shortcut, the command was :
C:\orant\BIN\VAW.EXE username=myUserName password=myCurrentPwd service=MyDOMAINE

Now, i'm using SQL PLUS WorkSheet with Oracle 8.1.
The command that starts SqlPlus is :
D:\Ora81NT\bin\oemapp.bat WORKSHEET
I tried to add parameters (after 'WORKSHEET'), but it didn't work

How should i proceed to have the same result as I use to have ?

Thanks in advance
Question by:pchaloux
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 8170935
If you mean , you want to use sql worksheet with Oracle 8.1
server , you still be able to use your old SQL worksheet program.Just change your service to poin to tns of 8.1
C:\orant\BIN\VAW.EXE username=myUserName password=myCurrentPwd service=setvicefor8

I understand that in 8.1 client , they come with sqlPlus not Sql Worksheet.


LVL 21

Accepted Solution

oleggold earned 2000 total points
ID: 8172243
Yes,You can use Sql Worksheet in Oracle 8.1
and the command is
DRIVE:\oracle\ora81\bin\oemapp.bat worksheet
THE Problem is that there's no handling for parameters in oemapp.bat:
if not  "%1%" == "" goto startNT
@echo %USAGE%
goto end"

But Your parameters are passed rigth away to the Java Classpath - so Your parameter is actually ment to be a class existing in the previous classpath:
"-%CLASSPATH_QUAL% %CLASSPATHADD% oracle.sysman.vtx.vtxOemApp.OemApp %1 %2 %3 %4 %5 %6 %7 %8 %9":
what You need is to add smth like that in the start_nt
if %1=="worksheet" then
set  %CLASSPATH%="Your custom classpath"
and/or Your custom commands with
 Your custom arguments
Try this -must work
In 9.i there's also sqlscratchpad which is alot like Sql Worksheet .

Author Comment

ID: 8174189
It worked, thanks

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question