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

Update Database
Hi All,


I have a problem with this:

Code: [Select]<?php
session_start();

values not being entered into table
hi. I;ve created a form, so that when a user enters data into it, it gets added to a table in a data

SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign

Replacing a string on click of a button
Hi! Is there a way to replace a string on a click of a text link?

This is what I've come up w

Looking for help reading a .txt or .ini file and outputting the info.
I have a file called Info.ini and It has the following info:
Code: [General]
Online=0
I wou

need help in dynamic select menu in php
hi i have created a dynamic select menu using php. i have a problem in that which is when the user s

MASS PM
Hello all, I'm trying to send mass private messages to users in my database but keep getting an erro

Coding Critique
I was hoping someone could take a second and look down my code and see if they see any problems with

difference between datetimes
($row['totime']-$row['fromtime'])/60

this is giving me 0

example of totime and fromtim

PHP Thumbnail Creation
Ok so i use this function to create thumbnails:

Code: function createthumb($name,$filename,$n