I apologize for typing too fast. This
was not meant for the whole list, just
Terry.
> -----Original Message-----
> From: Adams, Matthew (GEA, 088130)
> Sent: Friday, April 28, 2000 11:03 AM
> To: 'ORACLE-L_at_fatcity.com'
> Subject: RE: sql-plus variable error?
>
>
> 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:04:14 CDT
