"Cindy Lee" <dangreece_at_hotmail.com> wrote in message
news:300f29b7e720eda779ca5a05b5256195_at_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?
>
>
no such type native. try 1 or 0 and convert that to true or false.
Jim
Received on Tue Apr 27 2004 - 22:03:02 CDT
