1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
-------------------------------------------------------------------------------
-- plsql_proc.sql (Section 5.2)
-------------------------------------------------------------------------------
/*-----------------------------------------------------------------------------
* Copyright (c) 2017, 2021, Oracle and/or its affiliates. All rights reserved.
*---------------------------------------------------------------------------*/
set echo off
@@db_config.sql
set echo on
connect &user/&pw@&connect_string
create or replace procedure myproc(v1_p in number, v2_p out number) as
begin
v2_p := v1_p * 2;
end;
/
show errors
exit
|
