Call Specification Example in Java Developers Guide Does Not Compile

From: Tim Romano <tim_at_ot.com>
Date: Mon, 3 Jan 2000 16:31:48 -0500
Message-ID: <s7256hb05k2166@corp.supernews.com>

In the 8i Java Developers Guide (p.44), there's a Call Specification for a java sample which does not compile. Here it is typed, just as it appears in the Guide:

SQL> create or replace function HELLOWORLD return VARCHAR2 as   2 language java name 'Hello.world () return java.lang.String';   3 myString varchar2();
  4 call HELLOWORLD() into :myString;
  5 print myString;
  6 /
Warning: Function created with compilation errors.

SQL> show errors;
Errors for FUNCTION HELLOWORLD:

LINE/COL ERROR

-------- -----------------------------------------------------------------
3/1      PLS-00103: Encountered the symbol "MYSTRING"

What should this call specification look like? Declaring myString with a size [varchar2(20)]does not help. Putting a slash after the semicolon ending line 2 does not help.

Thanks! Received on Mon Jan 03 2000 - 15:31:48 CST