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

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

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…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

609 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