Skip to Main Content

Convert oracle.sql.NString to oracle.sql.NUMBER

user9322408Apr 9 2015 — edited Apr 9 2015

Hi,

How can one convert from oracle.sql.NString to oracle.sql.NUMBER?

I get following error:

  import oracle.sql.ORAData;

  import java.sql.SQLException; 

  public class MyTestKDB

    {

      static oracle.sql.NString tmpValue = new oracle.sql.NString("1");

      static oracle.sql.NUMBER  tmpNum;

   

      public static void doIt() {       

       

        try {

          tmpNum = new oracle.sql.NUMBER(tmpValue);

          System.out.println(tmpNum);

        }

        catch (Exception e){

          System.out.println(e.getMessage());

          e.printStackTrace();

        }       

      }     

    }

Initialization failed

java.sql.SQLException: Initialization failed

    at oracle.sql.NUMBER.<init>(NUMBER.java)

    at MyTestKDB.doIt(MYTESTKDB:12)

Comments
Post Details
Added on Apr 9 2015
0 comments
777 views