Re: Why can't I access package data from sqlplus?

From: Michiel Rens <Michiel.Rens_at_nedlloyd.nl>
Date: 1997/06/18
Message-ID: <33A7A0EE.5A83@nedlloyd.nl>#1/1

Create an SQL*Plus script like below:

   VARIABLE name VARCHAR2(16);
   BEGIN
      :name := constants.audit_name;
   END;
   /
   PRINT name

Check the SQL*Plus and/or PL/SQL guide for detailed usage of bind variables.

Good luck!
Michiel Rens

-- 


------------------------------------------------------------------------

Electronic Data Systems (EDS)               _/_/_/_/  _/_/_/_   _/_/_/_/
P.O. Box 2454                              _/        _/    _/  _/
3000 CL  Rotterdam (The Netherlands)      _/_/_/    _/    _/  _/_/_/_/
E-Mail: Michiel.Rens_at_nedlloyd.nl         _/        _/    _/        _/
Phone: +31 10 400.5937                  _/_/_/_/  _/_/_/_/  _/_/_/_/


------------------------------------------------------------------------

Received on Wed Jun 18 1997 - 00:00:00 CDT