Calling a Stored Proc in SQL*Plus

From: <Markjo_at_my-dejanews.com>
Date: Tue, 07 Jul 1998 19:00:50 GMT
Message-ID: <6ntr92$t13$1_at_nnrp1.dejanews.com>

[Quoted] I have the following stored procedure in the database:

PROCEDURE Get_Account_Address(p_AccountDivision in customer.account_division% TYPE, p_AccountNumber in customer.account_number%TYPE, CustCursor in out c_CustomerInfo) is
  BEGIN
    OPEN CustCursor FOR

      SELECT *
        FROM Bill_To_Address
        WHERE account_division = p_AccountDivision and account_number =

p_AccountNumber;
  END Get_Account_Address;

Where c_CustomerInfo is a REF CURSOR.

What is the syntax for calling this procedure in SQL*Plus so that I can check the results?

[Quoted] Thanks for any help.

Mark

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 07 1998 - 21:00:50 CEST