Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 820DB200BD3 for ; Tue, 6 Dec 2016 23:56:11 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 8099B160B29; Tue, 6 Dec 2016 22:56:11 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id C9802160B17 for ; Tue, 6 Dec 2016 23:56:10 +0100 (CET) Received: (qmail 203 invoked by uid 500); 6 Dec 2016 22:56:09 -0000 Mailing-List: contact user-help@jmeter.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "JMeter Users List" Delivered-To: mailing list user@jmeter.apache.org Received: (qmail 192 invoked by uid 99); 6 Dec 2016 22:56:09 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Dec 2016 22:56:09 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 58B72D3A48 for ; Tue, 6 Dec 2016 22:56:09 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -2.601 X-Spam-Level: X-Spam-Status: No, score=-2.601 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, RCVD_IN_SORBS_SPAM=0.5, RP_MATCHES_RCVD=-2.999, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=yahoo.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id T-lo17p-KmRj for ; Tue, 6 Dec 2016 22:56:08 +0000 (UTC) Received: from nm9-vm0.bullet.mail.bf1.yahoo.com (nm9-vm0.bullet.mail.bf1.yahoo.com [98.139.213.154]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id BACE25F2EF for ; Tue, 6 Dec 2016 22:56:07 +0000 (UTC) Received: from [98.139.215.140] by nm9.bullet.mail.bf1.yahoo.com with NNFMP; 06 Dec 2016 22:55:29 -0000 Received: from [98.139.212.211] by tm11.bullet.mail.bf1.yahoo.com with NNFMP; 06 Dec 2016 22:55:29 -0000 Received: from [127.0.0.1] by omp1020.mail.bf1.yahoo.com with NNFMP; 06 Dec 2016 22:55:29 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 649591.62399.bm@omp1020.mail.bf1.yahoo.com X-YMail-OSG: w9L7huYVM1nAfXr_D4L.C7p7GIGOauGddsXKCE9PWxwjiRYIwn6vv.ViXr2qkM3 byczz3kH8HAXz3KSA08.1WqQrn0bE_d9TbKaRoMZkNS6lofSHWkGMUZfq7q14w_RJ6RwEWW5Zy3C yzKrBkg1_ps7Ku8d_4kcuvdOapidwI45i42uLz1CxAp6zUdBPzeZKMAdGy7DjXgSJfNj.teFsmMP IYMYYqUNf1gf.n6JpFEhq3_nfnFXavPqiHwFuja5DZMwTyaHPXxfewhg6KPx5oEWiPeCS2J.KdsJ 6UhzT0ZyiXOVT2Z_Bh_84wutFO_tlOD.ZZHucJ2d33P3w31Nj2EeS84kPlLpF8mS6BLdgBEH7EO4 bSxh88Q6pzrjOHred3gdFDR7JkKDe7mhIpA_ZLe0u9mvkfyZg9ZlpIDXbZZ4zqrql9zaG.mbVYma yR1tNhbOwW6I7Syxiri1pVhk8.d9BuDhwuaa10GimYs1qJJ3xYxsAFz5fCO9rCzsNDzuP9D1Fapg DohTcDxeWOxc9YnM- Received: from jws400028.mail.bf2.yahoo.com by sendmailws125.mail.bf1.yahoo.com; Tue, 06 Dec 2016 22:55:29 +0000; 1481064929.223 Date: Tue, 6 Dec 2016 22:55:28 +0000 (UTC) From: o haya Reply-To: o haya To: Cc: Message-ID: <333750557.1002889.1481064928590@mail.yahoo.com> Subject: How to do this Oracle database test plan with sequential statements? MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit References: <333750557.1002889.1481064928590.ref@mail.yahoo.com> archived-at: Tue, 06 Dec 2016 22:56:11 -0000 Hi, I have some very old notes from doing something similar a long time ago, but I can't seem to get it working now. Basically, I need to run these two SQL commands: {CALL DBMS_SESSION.set_identifier(:username)} then: select count(*) from employees Where the username is a value that is from a CSV file that has a bunch of different usernames. I'm pretty sure I got this working before by using two JDBC Requests but I can't even get that part right. I am getting "Missing IN or OUT parameter at index:: 1" for the first request." Can anyone tell me why? Thanks, Jim --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org For additional commands, e-mail: user-help@jmeter.apache.org