Varible in trigger - refering to correct schema

Posted on 16th Feb 2014 07:03 pm by admin

Hello

Im having some issues with my trigger.
What I want to do is call opon a different schema - depending on which data the triggers picks up.

For example, lets say, triggers picks up CUSTOMER_ID & MARKET_CODE
CUSTOMER_ID = 20
MARKET_CODE = IT

then I want call a PLSQL package in that is in a schema called CORE_IT. What I tried is using varibles with define, and concat, but I cannot get it to work.

CREATE OR REPLACE TRIGGER AFTER_801
after insert on market_table
referencing new as new old as old
for each row
declare
v_marketcode varchar2(2) := :new.market_code;
begin
CORE_||v_market_code||.Execute_package();
end;
Iv also tried

..
define MK := :new.MARKET_ID
CORE_&MK.Execute_package();
..
I hope you get my picture, any ideas on how to get this to work?

Your Answer:

Login to answer

Other forums

LIMIT $start, 10... how to pass last value queried into next page with GET??
Ok I know how to display the first or last 10 results of a query...

$result = mysql_query(&q

Simple MySQL query...
Hello,
How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ag

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

get font info from a font file
hello,

Does anyone know how to get font info from a font file ... using php of course !
<

Batch Related Pricing
Hi, I need some clarity on the batch related pricing

For example the following are the b

How to kill asynchronous postback / current postback?
Hi,here is my problem:I have a web site with many pages of which some may take time to process resul

Class not found error
I am getting Class 'index' not found in Eval function:

//write config

$pat

Page Reload
I am having issues getting a page to reload after I submit data to a database. This form should inp

Data storage spaces in varchar2
Trying to understand what's happening.
I am selecting a value from a table that is defined as c

Comparing Values
Hi
I'm reading data from a database and this seems to work OK.

Each system has an associat