- 论坛徽章:
- 0
|
SQL> create or replace procedure SP_TS_IO(arg in out timestamp( 8 ) ) as
2 begin
3 update sp set ts=arg where param='I';
4 select ts into arg from sp where param='O';
5 commit;
6 end;
7 /
Warning: Procedure created with compilation errors.
SQL> show errors;
Errors for PROCEDURE SP_TS_IO:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/40 PLS-00103: Encountered the symbol "(" when expecting one of the
following:
:= . ) , @ % with default character
The symbol ":=" was substituted for "(" to continue. |
|