Re: Using Passthrough Query to Disable Triggers

DOH

I AM an idiot..... got it going.. i had my table name wrong AND was
prefixing the SQL with PL/SQL: ... what am i? an idiot.. thx Stefan...


"jeff" <jeff@work> wrote in message
news:OO8w$yd9IHA.3612@xxxxxxxxxxxxxxxxxxxxxxx
stefan

thx for your post, how do i run this from an MSACCESS pass through query?

My previous Passthrough Query used the following for MSSQL:-

EXECUTE sp_msforeachtable "ALTER TABLE tablename DISABLE TRIGGER ALL"

I cannot get this to work in the MSAccess pass through query...

PL/SQL: ALTER TABLE tableName DISABLE ALL TRIGGERS;

I get an "..Invalid SQL statement.." error

cheers
Jeff


"Stefan Hoffmann" <stefan.hoffmann@xxxxxxxxxx> wrote in message
news:%23yQcU978IHA.1568@xxxxxxxxxxxxxxxxxxxxxxx
hi Jeff,

jeff wrote:
is there a way I can run a passthrough query to call an appropriate
Oracle Stored Procedure to do the same as MSSQL???
PL/SQL: ALTER TABLE tableName ENABLE|DISABLE ALL TRIGGERS;


mfG
--> stefan <--





.

Relevant Pages

  • Re: Teaching Oracle PL/SQL class
    ... PL/SQL is used in industry. ... Common Uses? ... Tight Integration with SQL / Higher Productivity ... Subtopics ...
    (comp.databases.oracle.server)
  • Re: Teaching Oracle PL/SQL class
    ... I am teaching an Oracle PL/SQL class. ... Common Uses? ... Tight Integration with SQL / Higher Productivity ... Parameterized Cursors ...
    (comp.databases.oracle.server)
  • Re: Teaching Oracle PL/SQL class
    ... I am teaching an Oracle PL/SQL class. ... Common Uses? ... Tight Integration with SQL / Higher Productivity ... Parameterized Cursors ...
    (comp.databases.oracle.server)
  • Teaching Oracle PL/SQL class
    ... I am teaching an Oracle PL/SQL class. ... Common Uses? ... Tight Integration with SQL / Higher Productivity ... Parameterized Cursors ...
    (comp.databases.oracle.server)
  • Re: Bulk Collect without LIMIT
    ... >is as fast as BULK COLLECT without the LIMIT clause. ... "This is because Oracle 10g includes an optimization in PL/SQL that silently ... SQL> create table t1; ... for i in 1..500 loop ...
    (comp.databases.oracle.misc)