Skip to Content
0
Jul 06 at 02:46 AM

The reference has to be schema-local in "PROCEDURE"

140 Views

Hi,

I am new to XSA and trying to create a procedure in XSA and getting an error message "The reference has to be schema-local in "PROCEDURE".

My procedure looks like this.

PROCEDURE "DataIntegration.db.exchangerates::prc_acq_exchange_rates"( )

LANGUAGE SQLSCRIPT

-- SQL SECURITY INVOKER --

--DEFAULT SCHEMA <default_schema_name>

- -READS SQL DATA

AS

BEGIN

INSERT INTO "DataIntegration.db.synonyms::iml_exchange_rates"

SELECT

"BATCH_ID",

"SEQUENCE_NO",

"TIMESTAMP",

"FROM_CURRENCY",

"TO_CURRENCY",

"EXCHANGE_RATE",

"STATUS"

FROM "DataIntegration.db.synonyms::vt_exchange_rates";

END

It is something to do with the table reference "DataIntegration.db.synonyms::iml_exchange_rates". It will be great if somebody can help me to identify what I am doing wrong.

Thanks

Shantha