Trying to execute sql script using sqlplus from powershell commandline

Question

I'm trying to execute a sql script from powershell using the following command:

sqlplus username/password@tnsnamesalias 'path to my sql file.sql'

If I run the command without the script path, I can connect to the database and execute commands. If I include the script path (which includes spaces) then I just get the sqlplus help text and no changes are made to the database. My sql script is finished with END; and /

What am I doing wrong?

Tony Andrews · Accepted Answer · 2021-09-06 09:21:21Z

2

I believe you need to add the @ sign before the path:

sqlplus username/password@tnsnamesalias @'path to my sql file.sql'

answered Sep 6, 2021 at 9:21

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

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

2 Comments

majjam Over a year ago

So, I tried that and I get the following error: No characters are allowed after a here-string header but before the end of the line. + CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException + FullyQualifiedErrorId : UnexpectedCharactersAfterHereStringHeader

majjam Over a year ago

I needed to escape it with ` thats got it, thank you! So sqlplus username/password@tnsnamesalias `@'path to my sql file.sql'

ekochergin · Accepted Answer · 2021-09-06 09:24:27Z

2

You have forgotten "@" symbol and the apostrophes are wrong here.

This works for me for executing a "test script.sql" file

sqlplus .... "@test script.sql"

answered Sep 6, 2021 at 9:24

ekochergin

4,1592 gold badges14 silver badges20 bronze badges

Collectives™ on Stack Overflow

Trying to execute sql script using sqlplus from powershell commandline

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related