How to call nested script in sqlplus

Question

I have following script hierarchy.

Scripts/master.sql
Scripts/GB/gb.sql
Scripts/GB/user1/insert.sql

master.sql contains simple @script to call gb.sql e.g.

@GB/gb.sql

gb.sql contains below

@user1/insert.sql

The problem is that if i run master.sql from Scripts directory, i get below error:

unable to find insert.sql

Whereas if I execute gb.sql from GB directory, ir run successfully. Can you please help me?

Jon Heller · Accepted Answer · 2022-02-09 21:10:06Z

3

SQL*Plus directories are always reletive to the original working directory. Your scripts will need to repeat the full path from the working directory each time.

Change gb.sql to:

@GB/user1/insert.sql

The @@ can be used to reference files in the same directory as the running file, but @@ does not work with sub directories.

edited Feb 9, 2022 at 21:10

answered Jul 19, 2017 at 5:20

Jon Heller

37.1k6 gold badges84 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to call nested script in sqlplus

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related