sql-plus variable error?

From: <gmei_at_my-deja.com>
Date: 2000/04/27
Message-ID: <8ea47f$kn7$1@nnrp1.deja.com>#1/1

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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 27 2000 - 00:00:00 CDT