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

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: 8i java sample function would not compile ?

Re: Q: 8i java sample function would not compile ?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 29 Dec 1999 10:13:24 -0500
Message-ID: <a59k6sgan5navovgfb003c8jdcoesr4n8f@4ax.com>


A copy of this was sent to tedchyn_at_yahoo.com (if that email address didn't require changing) On Wed, 29 Dec 1999 14:51:19 GMT, you wrote:

>Sir, following helloword java function from 8i documentation would not
>compile in sqlplus:
>
>1>create or replace function HELLOWORLD return varchar2 as
>2>language java name 'Hello.world() return java.lang.string';
/

put a SLASH after line 2 to tell SQLPlus that the function you are creating/replacing is at the end. since functions can contain ";" -- sqlplus cannot auto run your command when it finds a semi colon (else it would prematurely submit the sql statements to the database in most cases)...

>3>myString varchar2;

that is not a valid sqlplus command -- you probable mean:

variable myString varchar2(N)

where N is some integer size...

>4>call HELLOWORLD() into :myString;
>5>print myString;
>
>
>LINE/COL ERROR
>-------- --------------------------------------------
>3/1 PLS-00103: Encountered the symbol "MYSTRING"
>any clues
>thanx
>Ted Chyn
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Dec 29 1999 - 09:13:24 CST

Original text of this message

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