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

Menu restriction
How can I restrict the individual menu that would appear when a user logs in so that all users are c

Relative path
I have a absolute path to an image - like so: C:/Program Files/Apache Software Foundation/Apache2.2/

Header is not working in IE
Hi ! header function is not working in IE but it works in FF, Safari, Chrome. any help please. :

Passing JS to PHP
So I have the following
Code: <?php
getdetails(?><script type="text/

mails going in spam??
The mails I sent to folks in my database using mail(function) are going in spam??

Any idea ho

Redistributing dependent dlls
Hai all ,

I have created an application in VC++ using VS2008 in a development machine which r

CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones

generating all possible random letters
hi'

how can i randomize the letters a,b,c,d,e all possible ways, and i want to print the res

Two fgetcsv related questions ;D
First of im trying to get a file from a merchants server but the directory is protected, I know the

Better Method of a Member Cloud
I assume most people know how tag clouds work, where the tags most used are bigger and the least use