[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
[eclipselink-users] ORA-06550 PLS-00114 occers at PLSQLStoredProcedureCall
|
Hi,
I face a problem when I use PLSQLStoredProcedureCall.
The procedure which I try to call as follow,
PROCEDURE test_argument(
abcdefghijklmnopqrstuvwxyz IN NUMBER
);
I can not call this procedure , because of such error
Error Code: 6550
Call:
DECLARE
abcdefghijklmnopqrstuvwxyz_TARGET VARCHAR(255) := :1;
BEGIN
XXZ_TEST_PKG.TEST_ARGUMENTS(abcdefghijklmnopqrstuvwxyz=>abcdefghijklmnopqrstuvwxyz_TARGET);
END;
bind => [:1 => test]
Query: ValueReadQuery()
oracle.oc4j.rmi.OracleRemoteException: Exception [EclipseLink-4002]
(Eclipse Persistence Services - 1.2.0.v20091016-r5565):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-06550: 行3、列3:
PLS-00114: 識別子ABCDEFGHIJKLMNOPQRSTUVWXYZ_TARが長すぎます。
ORA-06550: 行5、列59:
PLS-00114: 識別子ABCDEFGHIJKLMNOPQRSTUVWXYZ_TARが長すぎます。
PL/SQL block which PLSQLStoredProcedureCall creats contains variable
"bcdefghijklmnopqrstuvwxyz_TARGET".
Its length is over 30 , because of "_TARGET".
How can I avoid this problem?
thanks.
--
View this message in context: http://old.nabble.com/ORA-06550-PLS-00114-occers-at-PLSQLStoredProcedureCall-tp28287784p28287784.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.