AW: sql-plus variable error?

Try the following, this should work.

INSERT INTO &SCHEMAOWNERTO||'.'||HpxCatalog(

       CatalogID,
	 CatalogName,
	 Description,
	 Active )
Values (
	 &SCHEMAOWNERTO||'.||HPXSEQ_Catalog.nextval,


	 'Catalog_Name1',     -- hardcoded

	 '',

	 'T' );

Regards

i. V. Volker Sch=F6n
INPLAN RUHR
Informationstechnik GmbH
Tel.: +49 208 / 65 91 - 950
Fax: +49 208 / 65 91 - 980
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de
=20

-----Urspr=FCngliche Nachricht-----
Von: Guang Mei [mailto:zlmei_at_hotmail.com] Gesendet am: Freitag, 28. April 2000 04:10 An: Multiple recipients of list ORACLE-L Betreff: sql-plus variable error?

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=20
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=20
names)at prompt, say 'testfrom' and 'testto', I got the following error =
in=20
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

--=20
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