Re: SQLl _at_ command

Jack,

please download & use late
<https://www.oracle.com/tools/downloads/sqlcl-downloads.html#license-lightbox>st 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
> <https://linkprotect.cudasvc.com/url?a=https%3a%2f%2furldefense.com%2fv3%2f__https%3a%2ftwitter.com%2fmartinberx__%3b%21%21GqivPVa7Brio%21I-SDO1_GF_ewc9zuJDvm6QZLWxKG67V_pPren3w8nI3xegiy0X5Y-QP5f32GnOkvwQA%24&c=E,1,LdMdl5KnEq1_rAu_YNSUchYkDSkhM7ivXZDh-PwloVTtYUIWmJiU9qki3xj0UfG-_1FgUkTDskO6CgDpNgqfrAk7zPNbl1ZodZblv6xsd97z2C517M2m-CgM&typo=1>
> ^∆x http://berxblog.blogspot.com
> <https://linkprotect.cudasvc.com/url?a=https%3a%2f%2furldefense.com%2fv3%2f__https%3a%2flinkprotect.cudasvc.com%2furl%3fa%3dhttp%2a3a%2a2f%2a2fberxblog.blogspot.com%26c%3dE%2c1%2ccxgSkjNgBA1gIHAFZHIDBLYXPyQZAtwX3LEljGqqFG2ioOMWHGBPQWeL8d2Snw-W1k1yUTpOzlFK007z7L00CRP6ZBxVzjTSXtvXKUb8M3-ojEGWuxaxUpw%2c%26typo%3d1__%3bJSUl%21%21GqivPVa7Brio%21I-SDO1_GF_ewc9zuJDvm6QZLWxKG67V_pPren3w8nI3xegiy0X5Y-QP5f32GKfHsmB4%24&c=E,1,D4QJAOObQb82VC3jF_C_Ad9vzVx7-Snqc284P9zy9yOAy2CnmaP4vBco0L9iXPsVB5ygF4Y2BgoIzfm7tqxlU44TJpetBwYFu2vS4fLMSk6vTYFA26A,&typo=1>
>
> 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.
>

-- 
Martin Berger                Oracle ♠
martin.a.berger_at_gmail.com _at_martinberx <https://twitter.com/martinberx>
^∆x      http://berxblog.blogspot.com

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