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: Terry Ball <terry_ball_at_csgsystems.com>
Date: Fri, 28 Apr 2000 07:09:25 -0500
Message-Id: <10481.104393@fatcity.com>


Try using two dots:
INSERT INTO &SCHEMAOWNERTO..HpxCatalog

Terry

Guang Mei 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
> also send the HELP command for other information (like subscribing).
Received on Fri Apr 28 2000 - 07:09:25 CDT

Original text of this message

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