troubleshooting Question

oracle anonymous block , unix shell script

Avatar of digs developer
digs developer asked on
Unix OSLinuxOracle Database
6 Comments1 Solution1971 ViewsLast Modified:
How to run oracle anonymous block  through unix shell script.

I have created one anonymous block i.e.
v number:=9;
insert into a values (v);
end ;

I have created one sql file blk.sql  for above statement.

then i hve created 1 shell script

sqlplus us/Pwd@abc  @blk.sql

I have excueted the above shell script but data is not inserted into table.

Is it right way to call the sql block using @
Please help.
Senior Oracle DBA

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros