Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to pass a boolean parameter to an oracle PL/SQL procedure

How to pass a boolean parameter to an oracle PL/SQL procedure

From: Cindy Lee <dangreece_at_hotmail.com>
Date: Tue, 27 Apr 2004 19:33:47 GMT
Message-ID: <300f29b7e720eda779ca5a05b5256195@news.meganetnews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US