Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Parameter substitution
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