Hello PL/SQL experts,
DB version: 19.11 (compatible set at 11.2.0.4)
I am new to PL/SQL and trying to build a stored proc. Can you please help me identify the issue in below proc. Is there anything wrong in the way I declared parameters ?
Procedure is created with compilation errors below:
Create or replace procedure TPN_QueryLoad
(TPN1 VARCHAR2(150), TPID VARCHAR2(150))
IS
BEGIN
select * from tpn_sni_ld_ovwr_dttm where TRDNG_PRTNR_NM = TPN1 and TND_PTY_ID = TPID;
END;
/
SQL> show err
Errors for PROCEDURE SNI_QUERYLOAD:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/15 PLS-00103: Encountered the symbol "(" when expecting one of the
following:
:= . ) , @ % default character
The symbol ":=" was substituted for "(" to continue.
2/35 PLS-00103: Encountered the symbol "(" when expecting one of the
following:
:= . ) , @ % default character
The symbol ":=" was substituted for "(" to continue.
4/1 PLS-00103: Encountered the symbol "BEGIN" when expecting one of
LINE/COL ERROR
-------- -----------------------------------------------------------------
the following:
not null of nan infinite dangling a empty json
5/15 PLS-00114: identifier 'SNI_LD_OVWR_DTTM????WH' too long
5/64 PLS-00103: Encountered the symbol "=" when expecting one of the
following:
, ; for group having intersect minus order start union where
connect
5/92 PLS-00103: Encountered the symbol ";" when expecting one of the
following:
LINE/COL ERROR
-------- -----------------------------------------------------------------
. ( ) , * @ % & - + / at mod remainder rem <an exponent (**)>
and or || multiset