?
Solved

SQL WorkSheet

Posted on 2003-03-19
4
Medium Priority
?
1,700 Views
Last Modified: 2012-08-14
Hi,

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
0
Comment
Question by:pchaloux
3 Comments
 

Expert Comment

by:Printaporn
ID: 8170935
Hi,
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.

HTH

0
 
LVL 21

Accepted Solution

by:
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:
"
:ntCheckAppName
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 .
0
 

Author Comment

by:pchaloux
ID: 8174189
It worked, thanks
0

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