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?
session checking in page load
hai all
I have a parse error in this query help..
Code: $query1="INSERT INTO `rating` (`item_name`, `rating`, `ip_address`, `date_rated`) VALUES ('{$varItem}', {$varRating}, '{$ipAddress}', NOW())", "InsertRating";Parse error
Help on code output
My CODE:Code: [Select] echo "<phone>".$line["phone"]."</phone>"; echo
Javascript or not?
How many people prefer javascript/ajax sites? How many prefer the good old fashion straight php sites?
Referential Integrity problem when inserting into 2 tables at same time
Hello Everyone,Im relativity new to PHP and MySQL and i have come up against a problem. i have 2 tables that are linked via foreign key constraints.Code: ---- Table structure for table
php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecutive pattern.For example, I might have the table "eggs" with the values "1",
Logging and nologging bulk insert
Hi,
$action = "insert"; //$action = $_GET['action'];
$action = "insert";//$action = $_GET['action'];why is this invalid type? I am just modifying code that is there and want the action = insert so it will run all the parts of the code for
Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game, how would I go about coding that? Would be like this?Code: ($purchace = 1000000) ==
cURL and Sessions
Ohai.So, I'm trying to cURL a bunch of things off of a page, and put them into a session. I've added all of the items so they look like $_SESSION['fur'] = ge_item(6814)Now I just need to figure out
