Search results for query: *

Usually Running the AutoRun file will fix that problem.

Hum. If you are executing over an ODBC connection, you can set it up to ask for return of query longer than a certain time. That's only if you are connecting via ODBC.

My fav development tool for Oracle is TOAD. You can try it on <a href=&quot;http://www.toadsoft.com/&quot; target=&quot;new_win&quot;>http://www.toadsoft.com/</a>.

Okay. I ran into that problem before using BEQUETH. My work around was to use TCP/IP, an djust put in the ip address of your box. Follow hemantpandya's instruction to use NET 8, but if it doesn't work, go back and use TCP/IP instead of BEQUETH (Local protocol). That solved it for me last time.

I usually use MS Access when I have to do such thing.

joereena, How do you want to show it? In an message box as the date is being saved? or in a different field? Chester

I want to thank everyone who helped me! And the least I can do is to post the final trigger for reference, in case anyone else is wondering! THANKS! CREATE OR REPLACE TRIGGER v_gcd before update or insert of int_filename on editorial for each row declare vcount number; begin select count(*)...

Okay. I am transferred the field I want ot update onto another table, and yet i am still getting the same error. Can anyone give me an example code? Thanks for everyone's help. I am going insane!

Oh, I am getting this error: ORA-04091: table HEMERA.EDITORIAL is mutating, trigger/function may not see it ORA-06512: at &quot;HEMERA.V_GCD&quot;, line 5 ORA-04088: error during execution of trigger 'HEMERA.V_GCD'

I am so so desperate of help. It's pretty simple by concept, but I can't seem to get it right. Okay 2 tables. Table A -> id, c1, c2, c3 Table B -> id, c1, c2, c3 I want a trigger that will populate c1 from table b when I insert or update the id in table a. So far, I have this: (what did I...