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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sql-plus variable error?

RE: sql-plus variable error?

From: Alldaffer, Ron <ralldaff_at_siemens-psc.com>
Date: Fri, 28 Apr 2000 07:30:15 -0500
Message-Id: <10481.104397@fatcity.com>


Guang,

You need to add another "." to the statement. The "." that you have after the SCHEMAOWNERTO tells SQL*Plus that this is the end of the replacement variable. So if you have "&SCHEMAOWNERTO..HpxCatalog"
it should work for you.

Ron

On Thursday, April 27, 2000 9:10 PM, Guang Mei [SMTP:zlmei_at_hotmail.com] wrote:
> I have the following script in a file:
>
> --
> set verify off
> set feedback off
>
> accept SCHEMAOWNERFROM char prompt 'Enter Owner of the Schema you wish to
> move data FROM:'
> accept SCHEMAOWNERTO char prompt 'Enter Owner of the Schema you wish to
move
> data TO:'
>
> select 'insert into HpxCatalog:' from dual;
>
> INSERT INTO &SCHEMAOWNERTO.HpxCatalog(
> CatalogID,
> CatalogName,
> Description,
> Active )
> Values (
> &SCHEMAOWNERTO.HPXSEQ_Catalog.nextval,
> 'Catalog_Name1', -- hardcoded
> '',
> 'T' );
> --
>
> When I run this file in sql-plus, and I enter the two variables (two
schema
> names)at prompt, say 'testfrom' and 'testto', I got the following error in

> sql-plus:
>
> 'INSERTINTOHPXCATALOG:'
> -----------------------
> insert into HpxCatalog:
> INSERT INTO testtoHpxCatalog(
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
>
>
> I thought I would get "INSERT INTO testto.HpxCatalog(" stuff with a dot
"."
> in it. Any idea what I did wrong?
>
> Thanks.
>
> Guang
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Guang Mei
> INET: zlmei_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Apr 28 2000 - 07:30:15 CDT

Original text of this message

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