Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Call PL/SQL procedure from sqlplus on HP Unix

Re: Call PL/SQL procedure from sqlplus on HP Unix

From: Galen Boyer <galenboyer_at_yahoo.com>
Date: 15 May 2001 21:52:08 -0500
Message-ID: <upudaqa8p.fsf@primix.com>

On Tue, 15 May 2001, dghatit_at_nortelnetworks.com wrote:

> echo 'id' >> file

This is a unix command, not an Oracle command. You need to be able to select the value of id to standard output and redirect the output to a file

sqlplus << EOF > file
pl/sql command
EOF should do the trick.

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.
Received on Tue May 15 2001 - 21:52:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US