Imported java source is still invalid
Hi,
expdp/impdp from 11.2.0.4 to 19c.
Class looks like this:
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED ORD."DirList"
RESOLVER (( ))
as import java.io.*;
import java.sql.*;
public class DirList
{
public static void getList(String directory)
throws SQLException
{
File path = new File( directory );
String[] list = path.list();
String element;
for(int i = 0; i < list.length; i++)
{
element = list[i];
#sql { INSERT INTO OL_DOCS_LISTA_GT (FILNAMN)
VALUES (:element) };
}
}
Class is valid in 11g, but in 19c I get:
DirList:16: error: illegal character: '#'
#sql { INSERT INTO OL_DOCS_LISTA_GT (FILNAMN)
DirList:16: error: not a statement
#sql { INSERT INTO OL_DOCS_LISTA_GT (FILNAMN)