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

Formatting echo from database
So I have a database that stores First and last names, then echos them back to a website, as of now

Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f

admin with my register system?
Hey i wana make it so i can make a admin level on my register system , I'm kinda new to php to im no

Need help Updating SQL Server Express DB from c# :(
Please can anyone help with:-
1 How to sructure the strSelect statement.
2 How to instruct

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

Last character removed
I have created a string from an array. I have inserted commas from my form values. I am trying to re

Need understanding of this bit of code
Code: <?php
// WHERE clause filters
$arrSQLFilters = array();

//

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

cURL error
So here is my code... I got it off of here... http://www.youtube.com/watch?v=XcgQUsorF_8
Because