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

Select question
Hi,

First I would like to say that php is pretty new for me..
so please don't shoot me if

line breaks in between fetched file names
Hi,

I have this code:
Code: <?php
if($dir = opendir('files')){
while (($f

mysql_real_escape_string
Let me preface this that I am very much a PHP noob, but I have some SQL training (not necessarily My

single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be

Socket Server
In my following socket server, I am trying to listen to a connection through port 12345 in my web br

Running a cron job through PHP/Apache?!
Hello all,
I have a PHP script which makes a cron file from user input. When i try to run the cro

recrawling
Can anyone suggest me how may i know a page is updated before it is being downloaded, so that i can

Get word number x from string?
How can I use a function to loop through a string, and "have a look at" every word in the

Applet JTextField Size Problem
Hello,

I recently started making an applet to calculate certain values for airplanes. However

PHP Programming error. Please help!
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing