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@xxxxxxxxxxxxx>:
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@falcon admin]$ echo $PWD
/u01/app/oracle/admin
oracle@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.
@ > show sqlpath
SQLPATH :
/u01/app/oracle/product/18.0.0.0/dbhome_1/sqldeveloper/sqldeveloper
/bin/:.
@ >
@ > exit
[oracle@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@xxxxxxxxxx>
Sent: Wednesday, August 26, 2020 14:51
To: Jack Applewhite <jack.applewhite@xxxxxxxxxxxxx>; Martin Berger
<martin.a.berger@xxxxxxxxx>; franck@xxxxxxxxxx <franck@xxxxxxxxxx>
Cc: Mladen Gogala <gogala.mladen@xxxxxxxxx>; Oracle-L oracle-l <
oracle-l@xxxxxxxxxxxxx>
Subject: RE: SQLl @ 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@xxxxxxxxxxxxx>
Sent: Wednesday, August 26, 2020 3:20 PM
To: Martin Berger <martin.a.berger@xxxxxxxxx>; franck@xxxxxxxxxx
Cc: Mladen Gogala <gogala.mladen@xxxxxxxxx>; Oracle-L oracle-l <
oracle-l@xxxxxxxxxxxxx>
Subject: Re: SQLl @ 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Franck Pachot <franck@xxxxxxxxxx>
Sent: Wednesday, August 26, 2020 11:26
To: Martin Berger <martin.a.berger@xxxxxxxxx>
Cc: Mladen Gogala <gogala.mladen@xxxxxxxxx>; Oracle-L oracle-l <
oracle-l@xxxxxxxxxxxxx>
Subject: Re: SQLl @ 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@xxxxxxxxx> 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@xxxxxxxxx>:
Hi!
I am having problems with the @ 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@xxxxxxxxx @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.