title: Unable to Call Oracle Stored Procedure from Sqoop
body: <p>I want to call an Oracle stored procedure from Sqoop but I'm getting an error. I have to call a function of stored procedure and need to pass the parameter.</p>
  
  <pre><code>$: sqoop import --connect jdbc:oracle:thin:@localhost:1512/db --username userA --password password --call Oracle_Schema.pkg_table_maintenance.sf_drop_index('TBL_A_%','Group_id')
  
  -bash: syntax error near unexpected token `('
  
  $: sqoop import --connect jdbc:oracle:thin:@localhost:1512/db --username userA --password password --call "Oracle_Schema.pkg_table_maintenance.sf_drop_index('TBL_A_%','Group_id')"
  
  Warning: /opt/cloudera/parcels/CDH-5.4.7-1.cdh5.4.7.p1246.1021/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
  Please set $ACCUMULO_HOME to the root of your Accumulo installation.
  17/11/27 10:31:31 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.4.7
  17/11/27 10:31:32 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
  17/11/27 10:31:32 ERROR tool.BaseSqoopTool: Error parsing arguments for import:
  17/11/27 10:31:32 ERROR tool.BaseSqoopTool: Unrecognized argument: --call
  17/11/27 10:31:32 ERROR tool.BaseSqoopTool: Unrecognized argument: Oracle_Schema.pkg_table_maintenance.sf_drop_index('TBL_A_%','Group_id')
  </code></pre>
  
  <p>Can someone please help!</p>