关于建立java存储过程的错误。

[liting78hello]

CREATE OR REPLACE AND COMPILE JAVA source named "demo"
AS
import JAVA.SQL.SQLException;
PUBLIC CLASS demo EXTENDS OBJECT
{
static INT counter=0;
PUBLIC static INT IncrementCounter() throws SQLException
{
SYSTEM.OUT.println("Enter IncrementCounter,counter="+counter);
IF (++counter>=3)
{SYSTEM.OUT.println("Error!counter="+counter);
#SQL{
BEGIN RAISE_APPLICATION_ERROR(-20001,'Too many calls');END;
};
}
SYSTEM.OUT.println("Exit IncrementCounter,counter="+counter);
RETURN counter;
}
}
/
显示错误：ORA-29536: badly formed source: Encountered "PUBLIC" at line 2, column 1.
Was expecting one of:
<EOF>
"#sql" ...
"abstract" ...
"final" ...
"public" ...
"class" ...
"import" ...
"interface" ...
";" ...
"\\u001a" ...

请问：应该怎么修改？

[caral525]

呼呼，大小写的问题罗，JAVA里面PUBLIC大写可不是关键字哦，当然，你这里面好多该小写的都写了，改吧

[liting78hello]

楼上的没有做实验，没有权利发言

[himacs]

关注

[qlm_1982]

顶，，期待中。

[zw_yu]

先将你的java程序在外面编译通过再往里面导！

你的java程序好像错误多多，如果仅仅从java的角度看

[liting78hello]

java source named "demo"
*
ERROR 位于第2行：
ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler
要先编译啊？晕，等会试验