Re: OPS$ in Oracle6

Henry Ford (ccshf_at_midge.bath.ac.uk) wrote:

> I have started to use the OPS$ technique to add users to the ORACLE6
> system and have run into a problem. Part of my forms system calls a
> .sql file to construct another sql file and run it. The username is
> selected from sys.dual for identification purposes and is passed to
> the file with the &1 parameter e.g.
 

> 'select '||'''&1'''||',
 

> etc.
 

> This was fine until I tried the OPS$username, when all that gets passed
> is OPS. So far I have failed to get the username passed, or even
> OPS$username, which would be sufficient for identification.
> Any help from out there would be gratefully acknowledged !

Is the string OPS$whatever going to the system command line at any point? I'd guess you're using UNIX, and the $whatever is seen as a non-existant environment varable.

--
 _________________________   __________________________________________
/  Tommy Wareing          \ /  I've been looking for an original sin,  \
|  p0070621_at_brookes.ac.uk  X   One with a twist and a bit of a spin    |
\  0865-483389            / \     -- Pandora's Box, Jim Steinman       /
 ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~