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

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

Display Database
I need to create a shopping cart. I found this code online: http://conceptlogic.com/jcart/
Unfort

MySQL query problem
When I try to run the following piece of code, I get this error:
QuoteWarning: mysql_query(): sup

do while conditions
i want to display 6 images in a 2x3 table
now what would be the correct logic to
count that th

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

How to return to a previous page after running a PHP script
I'm having a bit of a melt down here because I think this should be really easy but can't work it ou

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di

Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a resu

Breaking results into week blocks
I have a set of dates (and times), which are returned from a mySQL query.

These usually span