title: Calling a Stored Procedure Using Oracle SQL Developer
body: <p>I am not able to set the server output to <code>ON</code>, while running the Java code. But I am able to connect to Oracle SQL database.</p>
  
  <p>Getting below error:</p>
  
  <blockquote>
    <p>****java.lang.NullPointerException DB Connected successfully java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid
    option****</p>
  </blockquote>
  
  <p>Please suggest me a solution.</p>
  
  <p>Code:</p>
  
  <pre><code>ResultSet rs= DS_DB.getResultSet("set serveroutput on");
  DS_DB.connectDatabase();
  
  String command = "{call sfmd.getNativeIdsForXID('EDDAC')}";
  CallableStatement cstmt = connection.prepareCall(command);
  cstmt.execute();
  System.out.println("Cstmt :"+command);'
  </code></pre>
  
  <p>Thanks</p>