Hi,
In a test procedure I'm using successfully the default
feature for a parameter :
create or replace procedure testp1 (p1 in varchar2 :=
null) is
begin
if (p1 is null) then
dbms_output.put_line('il est null');
else
dbms_output.put_line('il est pas null');
end if;
end;
/
The load_file is defined as
procedure load_file (p_file1 in varchar2 default null,
p_file2 in varchar2 default null, p_file3 in varchar2
default null) is
Now, I'm trying the same thing in a procedure that is
in a package and I kept getting PLS-00306: wrong
number or types of arguments in call to 'LOAD_FILE'
DHMS.WORLD:spaquette>exec
upkg_miner.load_file('dhms_log2a.dbf')
BEGIN upkg_miner.load_file('dhms_log2a.dbf'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call
to 'LOAD_FILE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
What am I missing ?
___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en fran�ais !
Yahoo! Mail : http://fr.mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
