Database Administration (MOSC)

MOSC Banner

Imported java source is still invalid

edited Jan 30, 2020 10:57AM in Database Administration (MOSC) 7 commentsAnswered ✓

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center