From oracle-l-bounce@freelists.org Fri Jun 4 15:02:58 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i54K2hH24661 for ; Fri, 4 Jun 2004 15:02:53 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i54K2R624608 for ; Fri, 4 Jun 2004 15:02:37 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A5A5472C485; Fri, 4 Jun 2004 14:47:30 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14354-31; Fri, 4 Jun 2004 14:47:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EFEC372C483; Fri, 4 Jun 2004 14:47:29 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 04 Jun 2004 14:46:05 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 77E4072C1AC for ; Fri, 4 Jun 2004 14:46:05 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14354-09 for ; Fri, 4 Jun 2004 14:46:05 -0500 (EST) Received: from enhbgsmtp04.state.pa.us (ENHBGSMTP04.state.pa.us [206.224.21.18]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CE5FC72C36C for ; Fri, 4 Jun 2004 14:46:04 -0500 (EST) Received: from ENHBGPRI11.PA.LCL ([206.224.21.35]) by enhbgsmtp04.state.pa.us with Microsoft SMTPSVC(5.0.2195.6713); Fri, 4 Jun 2004 16:04:40 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6524.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Execute Store Procedure in Oracle Date: Fri, 4 Jun 2004 16:04:40 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Execute Store Procedure in Oracle Thread-Index: AcRKaYoAl0qhoV/eS26clLrpuqBrlQABS5aA From: "Freeman, Donald" To: X-OriginalArrivalTime: 04 Jun 2004 20:04:40.0284 (UTC) FILETIME=[2B6151C0:01C44A6F] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2059 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dofreeman@state.pa.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I think I follow what you want. Here is a little example I copied from somewhere. VARIABLE P_SER_NO NUMBER; EXEC :P_SER_NO:=0; PRINT p_ser_no CREATE OR REPLACE PROCEDURE cf_ser_noformula (P_SER_NO IN OUT NUMBER) IS BEGIN P_SER_NO := NVL(P_SER_NO,0) + 1; END; / EXEC cf_ser_noformula (:p_ser_no) PRINT p_ser_no > -----Original Message----- > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org]On Behalf Of Hamid Alavi > Sent: Friday, June 04, 2004 3:32 PM > To: 'Oracle-L (E-mail) > Subject: Execute Store Procedure in Oracle > > > List, > > Is any body know how you can execute an store procedure from > SQLPLUS and get > the output parameter from store procedure. > I did EXECUTE sp_name(par1); from sqlplus and get error > even call is the > same, do I have to define any Variable or what? > I can see the output thru the dbms_output but I need to see > the output from > SQLPLUS > > Thanks, > > Hamid Alavi > > Office : 818-737-0526 > Cell phone : 818-416-5095 > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------