Re: SQLl _at_ command

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

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<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Franck Pachot <franck_at_pachot.net<mailto:franck_at_pachot.net>> Sent: Wednesday, August 26, 2020 11:26
To: Martin Berger <martin.a.berger_at_gmail.com<mailto:martin.a.berger_at_gmail.com>> Cc: Mladen Gogala <gogala.mladen_at_gmail.com<mailto:gogala.mladen_at_gmail.com>>; Oracle-L oracle-l <oracle-l_at_freelists.org<mailto: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<mailto: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<mailto: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<mailto: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.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 26 2020 - 22:05:39 CEST