CODEWITHSUNDEEP
oracle-databaseshellplsql
Kheira boukhalfa
Kheira boukhalfa

Reputation: 1

How to call pl/sql procedure from shell

I have created a simple procedure with date as parameter in oracle. I need to call this procedure from shell, how do I call the procedure ? pseudo code is 

CREATE OR REPLACE
 procedure  my_procedure (date1 IN date )
 begin
  delete from Result_table;
  make different calculations from different tables, insert values row by row in 
  Result_table;
 end;

Upvotes: 0

Views: 2074

Answers (1)

Wernfried Domscheit
Wernfried Domscheit

Reputation: 59436

In one line you can run

sqlplus user/password@db <<< "exec my_procedure(SYSDATE);"

Upvotes: 1

Related Questions