Shulou(Shulou.com)06/01 Report--

Both of these methods can be used in sqlplus:

Exec pro_name (parameter 1.)

Call pro_name (parameter 1.)

Difference:

1. But exec is a sqlplus command and can only be used in sqlplus; call is a SQL command with no restrictions.

two。 When a stored procedure has no parameters, exec can follow the procedure name directly (you can omit ()), but call must take ().

Sql code

SQL >-- insert data in the creation process

SQL > create or replace procedure pro1 is

2 begin-Executive part

3 insert into mytest values ('Zhang San', 'mm')

4 end

5 /

Procedure created

SQL > exec pro1

PL/SQL procedure successfully completed

SQL > call pro1

Call pro1

ORA-06576: not a valid function or procedure name

SQL > call pro1 ()

Method called

Summary: when calling a procedure, you should get into the habit of using call with ().

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.