| SQLJ Iterator ??? [message #10018] |
Mon, 22 December 2003 06:17 |
n00b
Messages: 3
Registered: December 2003
|
Junior Member |
|
|
</pre>
Why wont sqlj iterator work ???
Im trying to write a simple java "stored procedure" in the db server (oracle9i).
import java.sql.*;
public class Test
{
public testIt()
{
try
{
#sql iterator TestIter (long);
TestIter testIter;
#sql testIter = { SELECT testId FROM testtbl};
while( testIter.next() )
;
testIter.close();
}
catch(Exception e)
{
}
}
}
It always fails with:
#sql iterator TestIter (long);
With a message as:
ORA-29536: badly formed source: Encountered "iterator" at line 8, column 31.
Was expecting one of:
"#sql" ...
"{" ...
"boolean" ...
"byte" ...
"char" ...
"double" ...
"false" ...
"float" ...
"int" ...
"long" ...
"new" ...
"null" ...
"short" ...
"super" ...
"this" ...
"true" ...
"void" ...
<INTEGER_LITERAL> ...
<FLOATING_POINT_LITERAL> ...
<CHARACTER_LITERAL> ...
<STRING_LITERAL> ...
<IDENTIFIER> ...
"(" ...
"[[" ...
"!" ...
"~" ...
"++" ...
"--" ...
"+" ...
"-" ...
please what am I doing wrong ??
</pre>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
