Re: SQLl _at_ command

I agree. I misreported the problem. I am using Oracle 12.2 and have downloaded SQLCl 20.2 but forgot to put $HOME/sqlcl/bin into the PATH. The problem was with Oracle 12.2 version of SQLCl, not with 20.2. I humbly apologize for the confusion.
On Wed, 2020-08-26 at 22:11 +0200, Martin Berger wrote:
> Jack,
>
> please download & use latest 20.x SQLcl.
>
> I saw similar issues with pre 20.x Versions, but my observation with
> 20.x is fine.
>
> hth,
> Martin
>
> Am Mi., 26. Aug. 2020 um 22:05 Uhr schrieb Jack Applewhite <
> jack.applewhite_at_austinisd.org>:
> >
> >
> >
> >
> >
> > This is on an X8-M ODA at 18.8 with 18c DBs. Not sure why 18c
> > shipped with SQLDev and sql 17.3.
> >
> >
> >
> >
> >
> > [oracle_at_falcon admin]$ echo $PWD
> > /u01/app/oracle/admin
> >
> > oracle_at_falcon admin]$ sql /nolog
> >
> >
> >
> > SQLcl: Release 17.3.0 Production on Wed Aug 26 15:03:08 2020
> >
> >
> >
> > Copyright (c) 1982, 2020, Oracle. All rights reserved.
> >
> >
> >
> > _at_ > show sqlpath
> > SQLPATH :
> > /u01/app/oracle/product/18.0.0.0/dbhome_1/sqldeveloper/sqldeveloper
> > /bin/:.
> > _at_ >
> > _at_ > exit
> > [oracle_at_falcon admin]$
> >
> >
> >
> >
> >
> > What's it supposed to be?
> >
> > Thanks.
> >
> >
> >
> >
> >
> >
> > --
> >
> > Jack C. Applewhite - Database Administrator
> >
> > Austin I.S.D. - MIS Department
> >
> > 512.414.9250 (wk)
> >
> >
> >
> >
> >
> >
> >
> >
> > I cannot help but notice that there is no problem between us that
> > cannot be solved by your departure. -- Mark Twain
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > From: Jeff Smith <jeff.d.smith_at_oracle.com>
> >
> > Sent: Wednesday, August 26, 2020 14:51
> >
> > To: Jack Applewhite <jack.applewhite_at_austinisd.org>; Martin Berger
> > <martin.a.berger_at_gmail.com>; franck_at_pachot.net <franck_at_pachot.net>
> >
> > Cc: Mladen Gogala <gogala.mladen_at_gmail.com>; Oracle-L oracle-l <
> > oracle-l_at_freelists.org>
> >
> > Subject: RE: SQLl _at_ command
> >
> >
> >
> >
> >
> > Jumping in late, so apologies
> >
> > But if I echo $PWD
> >
> > And then start sqlcl
> >
> > And show sqlpath…
> >
> > I see $PWD
> >
> > So can someone explain to me what we’re doing wrong? Happy to file
> > a bug and drive to get it fixed for you.
> >
> > Jeff
> >
> >
> >
> > From: Jack Applewhite <jack.applewhite_at_austinisd.org>
> >
> >
> > Sent: Wednesday, August 26, 2020 3:20 PM
> >
> > To: Martin Berger <martin.a.berger_at_gmail.com>; franck_at_pachot.net
> >
> > Cc: Mladen Gogala <gogala.mladen_at_gmail.com>; Oracle-L oracle-l <
> > oracle-l_at_freelists.org>
> >
> > Subject: Re: SQLl _at_ command
> >
> >
> >
> >
> > Yes, this has been bugging us since we migrated to 18c. I LOVE sql
> > or sqlcl, but having it not respect $PWD is Very annoying.
> >
> >
> > I just execute sql, which launches the sql script in
> > $ORACLE_HOME/bin, which executes the line below
> >
> >
> >
> >
> >
> > cd "`dirname $0`"/../sqldeveloper/sqldeveloper/bin && bash sql
> > $*
> >
> >
> >
> >
> >
> > So, not being an ace shell scripter, is there a straightforward way
> > to get this to inherit the $PWD of the original invocation of sql?
> > Or to edit the .../sqldeveloper/bin/sql big ol' script
> > to inherit $PWD?
> >
> >
> >
> >
> >
> >
> > Thanks.
> >
> >
> >
> >
> >
> >
> > --
> >
> > Jack C. Applewhite - Database Administrator
> >
> > Austin I.S.D. - MIS Department
> >
> > 512.414.9250 (wk)
> > I cannot help but notice that there is no problem between us that
> > cannot be solved by your departure. -- Mark Twain
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > From:
> > oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> > behalf of Franck Pachot <franck_at_pachot.net>
> >
> > Sent: Wednesday, August 26, 2020 11:26
> >
> > To: Martin Berger <martin.a.berger_at_gmail.com>
> >
> > Cc: Mladen Gogala <gogala.mladen_at_gmail.com>; Oracle-L oracle-l <
> > oracle-l_at_freelists.org>
> >
> > Subject: Re: SQLl _at_ command
> >
> >
> >
> >
> >
> >
> > Hi all,
> >
> > It is not SQLcl that changes the directory but the wrapping script
> > that you find in $ORACLE_HOME/bin/sql
> >
> >
> > Franck.
> >
> >
> >
> >
> >
> > On Wed, Aug 26, 2020 at 5:02 PM Martin Berger <
> > martin.a.berger_at_gmail.com> wrote:
> >
> > >
> > > Hi Mladen,
> > >
> > >
> > >
> > > I had similar issues with versions prior to 20.2: SQLcl changed
> > > it's working directory.
> > >
> > > can you please do a
> > >
> > > !pwd
> > >
> > >
> > > (or !cd )
> > >
> > > to see in which directory your SQLcl really is?
> > >
> > >
> > >
> > >
> > >
> > > hth
> > >
> > >
> > > berx
> > >
> > >
> > >
> > >
> > >
> > > Am Mi., 26. Aug. 2020 um 16:40 Uhr schrieb Mladen Gogala <
> > > gogala.mladen_at_gmail.com>:
> > >
> > > > Hi!
> > > >
> > > >
> > > > I am having problems with the _at_ command from SQLCl. For some
> > > > reason, SQLCl 20.2 doesn't find the file, even if it is in the
> > > > current directory. Does anyone have the same experience?
> > > >
> > > >
> > > > Regards
> > > >
> > > >
> > > > --
> > > > Mladen Gogala
> > > >
> > > > Database Consultant
> > > >
> > > > Tel: (347) 321-1217
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > >
> > >
> > >
> > > Martin Berger Oracle ♠
> > >
> > >
> > > martin.a.berger_at_gmail.com _at_martinberx
> > >
> > > ^∆x http://berxblog.blogspot.com
> > >
> > >
> > >
> > >
> >
> >
> > Confidentiality Notice: This email message, including all
> > attachments, is for the sole use of the intended recipient(s) and
> > may contain confidential student and/or employee information.
> > Unauthorized use of disclosure is prohibited under
> > the federal Family Educational Rights & Privacy Act (20 U.S.C.
> > §1232g, 34 CFR Part 99, 19 TAC 247.2, Gov’t Code 552.023, Educ.
> > Code 21.355, 29 CFR 1630.14(b)(c)). If you are not the intended
> > recipient, you may not use, disclose, copy or disseminate this
> > information.
> > Please call the sender immediately or reply by email and destroy
> > all copies of the original message, including attachments.
> >
> >
> >
> > Confidentiality Notice: This email message, including all
> > attachments, is for the sole use of the intended recipient(s) and
> > may contain confidential student and/or employee information.
> > Unauthorized use of disclosure is prohibited under the federal
> > Family Educational
> > Rights & Privacy Act (20 U.S.C. §1232g, 34 CFR Part 99, 19 TAC
> > 247.2, Gov’t Code 552.023, Educ. Code 21.355, 29 CFR
> > 1630.14(b)(c)). If you are not the intended recipient, you may not
> > use, disclose, copy or disseminate this information. Please call
> > the sender
> > immediately or reply by email and destroy all copies of the
> > original message, including attachments.
> >
> >
>
>

-- 
Mladen Gogala

Database Consultant

Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l