1,911 reputation
732
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 5 months
seen 4 hours ago

Oracle DBA and programmer with 10 years experience maintaining mission-critical applications. Lots of PL/SQL, C# and the usual glue, vbscript, DOS


2d
revised Enforce a constraint problem
deleted 16 characters in body
Dec
16
revised berkeley-db wiki description
added 723 characters in body
Dec
16
revised berkeley-db wiki excerpt
added 116 characters in body
Dec
16
wiki created berkeley-db description
Dec
16
wiki created berkeley-db excerpt
Dec
16
suggested approved edit on berkeley-db tag wiki
Dec
16
suggested approved edit on berkeley-db tag wiki excerpt
Dec
16
comment database design for storing individual users' items
how many users, what data type and how large are the columns A,B,C,D?
Dec
16
comment Standard data types for email address, telephone number , first name, rixh text editor, etc
Whatever is suggested, make it larger....
Dec
16
comment ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file
is there a parameter file or spfile present?
Dec
3
comment Prevent row from being inserted with a trigger
oracle version please and actual output should be logged to a table so we can see what happens on an insert. Or do you have the output from an insert?
Nov
26
comment Toad 9.7.2 for Oracle hangs on Windows 7
what version of oracle are you connecting to?
Nov
17
awarded  Popular Question
Oct
20
asked Replacement for Pragma Restrict references
Oct
17
comment grant permissions in oracle from one database to another
Are they actually two different instances on the same machine? Or two schemas on the same machine, or two instances on different machines?
Sep
24
awarded  Autobiographer
Sep
22
comment How would I implement interprocess communication from Oracle (10g R1) trigger using DBMS_ALERT?
Ah, Forms... You can do stored procedures in Forms and skip the triggers if you like.
Sep
22
answered Compare sysdate month with a column data
Sep
19
answered How would I implement interprocess communication from Oracle (10g R1) trigger using DBMS_ALERT?
Sep
19
comment How would I implement interprocess communication from Oracle (10g R1) trigger using DBMS_ALERT?
You are really handcuffing yourself with all the things that cannot be changed. Have you considered Advanced queues, or a table that is inserted into every time a row is changed?