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

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


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?
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
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
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?
Sep
18
comment Oracle remote OS authentication, security risks with domain users
what testing have you tried?
Sep
5
comment Is it possible to get this output in Oracle 8i?
What have you tried?
Sep
2
comment How to put more than 1000 values into an Oracle
Can you create an external table in a directory?
Jun
19
comment Is there a way to pass to execute immediate only once a variable but use it several times?
What you don't say is why you want to do this. Intellectual curiosity or other reason??? You are not really "saving" anything by repeating it or using a different solution to not repeat it.
Jun
19
comment Low performance oci_execute
You would verify this by running it in your app and then running it again in your app. Compare execution times and see. Using SQL Developer should make no difference to the execution plan but running the same query twice will.
May
9
comment MS Access migration from Oracle to SQL server?
I think you should describe what oracle/sql server do and what access does in this project.
Mar
11
comment How can I receive an input string parameter having about 200000 characters?
why can't you use a clob? or break the input into manageable chunks?
Feb
25
comment dynamic query manupulation
this query would seem to need some spaces after the reserved key words. Such as ...dep.DEPT_ID=depgr.DPGR_DEPT_ID'|| ' ' || --added space here 'inner join hod_groups hod on depgr.DPGR_DEPT_ID=hod.HODG_GN_ID'||
Feb
22
comment Installing Oracle on Windows Server 2008 R2 Guested by VMware
This is only a warning not a failed installation. You should take a snapshot before installation. After the warning continue the install. After it is finished run the emca script as recommended
Feb
17
comment query to search a particular word/string in toad/oracle
Some versions of TOAD have an object search that will allow you to search in any package,procedure, trigger, table definition (not the data)
Feb
7
comment Installing Oracle Database 12c in Windows 7, INS-08109 error
I guess using a clean install of windows is not possible?
Jan
31
comment “Oneway” Replication from Oracle DB to TimesTen
What versions of Oracle and TimesTen are you using?