Here's a short test block for everyone to check:
declare
n number;
procedure f1(p1 in varchar2, p2 in varchar2, p31 out number) is
begin
dbms_output.put _line('A f1(p1 in varchar2, p2 in varchar2, p31 out varchar2)');
end;
procedure f1(p1 in varchar2, p2 in varchar2, p32 in pls_integer := -20001) is
begin
dbms_output.put _line('B f1(p1 in...
wernerf
Last Activity: Mar 14 '08, 04:16 PM
Joined: Oct 4 '07
Location:
-
OK, that's what I tried to outline, parameter mode cannot be a criterion - but how is it possible, that the invocation compiles and executes OK on hundreds of customer client/server combos (including our own), and only ONE is known to receive the error?...Leave a comment:
-
PLS-00307 - Function Overloading Problem
Hi all.
Here's my problem:
Consider a package MY_PKG with the following two functions
FUNCTION get_number_by_r owid(
p_table_name IN VARCHAR2,
p_column_name IN VARCHAR2,
p_rowid IN UROWID,
p_result OUT NUMBER
) RETURN PLS_INTEGER;
FUNCTION get_number_by_r owid(
...
No activity results to display
Leave a comment: