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

Taylor Series Function
So I am working a a project for my intro C++ class, and I am having some trouble with a function for

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

Access database inside of a validation class
Hello,

For quite some time, I have been using functions to validate form input and access the

database design
Hi,

I got a page which allow candidate to type in their previous working experience,
I let

php libs/ browsercap.in
ok i have a host that refuses to stay current. they control my php settings and libs. is there a way

question about n
I was looking at some of the things you could do with php and one of the things I have tried is n.<

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

having probem inserting data into db table
hi

i have a table with following columns in it
Code: candidate_id, degree, cgpa, institute

db entry based on primary key
My "topics" table contains 10 entires
*--------------*
topicid topic
------