pl/slq procedures – POSITIVE and POSITIVEN as IN OUT parameters
Hi, I have a simple PL/SQL procedure with IN and OUT parameter of type POSITIVEN. CREATE or REPLACE PROCEDURE PROC ( inval IN POSITIVEN, outval OUT POSITIVEN ) AS BEGIN outval := inval; END; I pass the value 1 for the IN value using the sql type INTEGER in a jdbc application. But oracle throws a exception ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1 This works fine if I have a POSITIVE type as parameter. Not sure what the problem might be. Is POSITIVEN allowed as an parameter types for a procedure?
Software/Hardware used:
Software/Hardware used:
ASKED:
November 12, 2009 7:49 PM
UPDATED:
November 12, 2009 10:14 PM
RELATED QUESTIONS
- ORA-06550 error: the function is undefined or not a procedure, yet I have defined the function
- Copy a SQL Binary Large Object (BLOB) from one database to another
- oracle internet directory application developer's guide -- dbms_ldap_utl sample code doesn't work
- Oracle stored procedure error with PL/SQL
- pl/sql code for email id validations
Answer Wiki:
The POSITIVEN type is allowed for IN paramaters only, as the initial value of an OUT parameter is NULL by definition.
You should use POSITIVE for the out paramter instead.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
