?
Solved

SQL WorkSheet

Posted on 2003-03-19
4
Medium Priority
?
1,678 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
[X]
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
4 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

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