Oracle ORA-06550, oracleora-06550
Declare
Cnt integer;
Begin
Select count (0)
Into cnt
From user_all_tables
Where table_name = upper ('dps _ BIZTYPES_MANAGE ');
If cnt = 0 then
Execute immediate 'create table DPS_BIZTYPES_MANAGE
(
Id Integer not null,
BIZTYPE VARCHAR2 (4) not null,
BIZNAME VARCHAR2 (30) not null,
DEPOSITTYPE VARCHAR2 (6) not null,
KMH VARCHAR2 (32) not null,
Depositterm integer not null,
Stdrate number (10, 6) not null,
Lowrate number (10, 6) not null,
Bottomamount number (15, 2 ),
Minwithdrawamount number (15, 2 ),
"COMMENT" VARCHAR2 (255 ),
Createtime date default SYSDATE not null,
Lastupdatetime date,
Drawamount number (15, 2 ),
COMMENTS VARCHAR2 (255 ),
BZ VARCHAR2 (3) default 'R ',
Ratefloatup number (8, 2 ),
Ratefloatdown number (8, 2 ),
State INTEGER default 0,
StateName VARCHAR2 (32 ),
Rejectreason VARCHAR2 (255)
)';
End if;
End;
ORA-06550: 28th rows, 44th columns:
PLS-00103: the sign "R" appears when you need the following:
* & Amp; =-+; </> at in is
Mod remainder not rem return returning <an exponent (**)>
<> Or! = Or ~ ==<=<> And or like LIKE2 _ LIKE4 _ LIKEC _
Between into using | multiset bulk member SUBMULTISET _
The symbol "* has been inserted before" R "continues.
Change to BZ VARCHAR2 (3) default ''r '',
The single quotes enclosed in single quotes must be escaped with single quotes, that is, two represents one.
ORACLE package call error ORA-06550: 1st rows, 7th Columns
ORA-06550: 1st rows, 7th columns:
PLS-00306: number of parameters or type error when calling 'rpt _ RATE_EVECTION'
ORA-06550: 1st rows, 7th columns:
PL/SQL: Statement ignored
Didn't you say that?
The number or type of the 'rpt _ RATE_EVECTION 'parameter is incorrect.
Check whether the parameter types in this package are consistent with those you have defined. In addition, whether the number of parameters you have defined is consistent with the number of parameters in the package
Oracle: ORA-06550 processing:
Paste the program