Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to pass a boolean parameter to an oracle PL/SQL procedure
I have the following code:
create or replace java source named "Sql" as
public class Sql {
static public void hiThere(String head, boolean tail) { System.out.println(head + " " + tail); } } / create or replace procedure bounce (head varchar,tail boolean) as language java name 'Sql.hiThere(java.lang.String,boolean)';
/
call bounce('egor.elagin_at_umusic.com', 'true');
The last line has a problem:
call bounce('egor.elagin_at_umusic.com', 'true')
*
ERROR at line 1:
ORA-06553: PLS-306: wrong number or types of arguments in call to 'BOUNCE'
How do I pass the second parameter as a boolean? Received on Tue Apr 27 2004 - 14:33:47 CDT