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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Parameter substitution

Re: Parameter substitution

From: <mpir_at_compuserve.com>
Date: Thu, 06 Aug 1998 14:26:59 GMT
Message-ID: <6qcefi$igp$1@nnrp1.dejanews.com>


THere are two possibilities I can think of: 1- use double ambersand (&&)

2- use col fred newval var1 type statement of SQL*PLUS

In article <35C96034.77E63A85_at_exlibris.co.il>,   Ariel Kirson <arielk_at_exlibris.co.il> wrote:
> Hi John,
>
> I tried your solution, but when I run the "outer"
> script I am prompted for the values of var1
> and var2. This is not my intention.
> Var1 and var2 are declared in a block,
> and within the block I wish to pass their
> values to "inner" using a "@" call.
>
> Any further thoughts ?
>
> Thanks,
>
> Ariel Kirson
> Ex Libris.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 06 1998 - 09:26:59 CDT

Original text of this message

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