title: Running Stored Procedure From JMeter
body: <p>I have a stored procedure as below which I run to create some test data automatically using PL/SQL Developer. It just runs fine.</p>
  
  <pre><code>begin
    create_test_data('000000316F1422C8','N',1,'2016-01-26');
  end;
  /
  </code></pre>
  
  <p>I was automating some project in JMETER and there as part of setup I need to create this data. I tried to connect to Oracle DB using JDBC Request Sampler can fire Select Queries which are working fine. </p>
  
  <p>Now I want to run this Stored Procedure to Generate the data from JMETER: I tried to use JDBC Request sampler and copied the above code but it doesn't work.</p>
  
  <p>Can somebody please help?</p>
  
  <ol>
  <li>Is JDBC Request Sampler Correct way to run this Stored procedure</li>
  <li>While I am running it from JDBC Request Sampler I am getting below Errors:</li>
  </ol>
  
  <p>a. Error 1</p>
  
  <pre><code>ORA-06550: line 4, column 1:
  PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.
  </code></pre>
  
  <p>b. Error 2 If I remove slash from the last line</p>
  
  <pre><code>ORA-06550: line 2, column 3:
  PLS-00201: identifier 'CREATE_NEXNET_TEST_DATA' must be declared
  ORA-06550: line 2, column 3:
  PL/SQL: Statement ignored
  </code></pre>
  
  <ol start="3">
  <li>How can we verify in the end if stored procedure can run successfully</li>
  </ol>
  
  <p>Many Thanks!!</p>