RE: sql-plus variable error?

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Fri, 28 Apr 2000 11:02:50 -0400
Message-Id: <10481.104433@fatcity.com>

Terry,

  Anyone from CSG going to be at IOUG-A conference week after next?

Matt Adams
(CSG Transplanted ex-dba)

> -----Original Message-----
> From: Terry Ball [mailto:terry_ball_at_csgsystems.com]
> Sent: Friday, April 28, 2000 9:19 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: sql-plus variable error?
>
>
> 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).

-- 
Author: Terry Ball
  INET: terry_ball_at_csgsystems.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 - 10:02:50 CDT