Re: isqlplus
Date: Mon, 31 Mar 2003 13:55:34 +1000
Message-ID: <3E87BC36.4020507_at_oracle.comX>
iSQL*Plus has the ability to load or execute scripts through a URL. You can create an HTML form that includes optional login information, script to load/execute, the URL for the iSQL*Plus server, etc. This is actually a very good use of this feature.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch8.htm#1006243
and
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch4.htm#1006462
You can set it up so that a user automatically logs in, executes a script, logs out and displays the script. The user doesn't even really know they've been logged into iSQL*Plus. It's much easier to deploy than asking someone to log into SQL*Plus command line. You just supply a web page with the form, or a URL and they're away.
Alison
Chuck wrote:
> DA Morgan <damorgan_at_exxesolutions.com> wrote in > news:3E84AC84.660C2E5E_at_exxesolutions.com: > >
>>What you are missing, at least from my perspective, is that you have
>>taken a simple task Oracle DBAs and SysAdmins have been doing for more
>>than 15+ years and tried to turn it into a goat rope.
>>
>>There is an interface that has worked perfectly well for as far back
>>as I can remember called the SQL*Plus command line. Rather than using
>>it you are trying to kludge a new tool into doing a job for which it
>>was not intended.
>>
>>If you succeed go for it. I've no doubt I could write a Java Applet or
>>something to do the job. But what a load of work for something I could
>>set up and do the traditional way in less time than you have devoted
>>to posting to the usenet.
> > > I did get it to work. It's just a simple one line sql script and a url > that runs it. The user gets his data with a single mouse click and I > don't have to set up a dbms job, create any tables, install crystal, > access, EM clients or anything else. >Received on Mon Mar 31 2003 - 05:55:34 CEST