can I execute DBMS packages with DBI?

From: Marc Torres (marc.torres_at_fedex.com)
Date: 03/18/04

  • Next message: Samuel Gold: "RE: can I execute DBMS packages with DBI?" 
    To: dbi-users@perl.org
Date: Thu, 18 Mar 2004 13:46:36 +0100

    Hi all

    I was wondering whether or not I can run commands other than the typical
    SELECT, INSERT, UPDATE & DELETE. For instance, I am working with Oracle and
    would like to launch with Perl scripts that would use the DBMS_STATS
    package. And I would also like to launch commands such as: alter
    database..., alter system..., alter table..., alter index..., create
    tablespace..., alter tablespace..., drop tablespace..., alter datafile...,
    etc, etc, etc.

    Has anybody done that before? Can I just use the "do->" command to do those
    tasks mentioned above?

    Thanks in advance for your wise advise. :-)

    Marc Torres Alvarez

  • Next message: Samuel Gold: "RE: can I execute DBMS packages with DBI?"

    Relevant Pages

    • Re: AIX Performance issue
      ... this is how we take backup ... Same for Oracle 7.3.4? ... application, in this database, on this Operating System? ... Perhaps the scripts and commands you're running ...
      (comp.unix.aix)
    • Re: Quick role test
      ... alter user bob1 default role all except foo33 identified using ... After the combined commands, ... Surely Oracle development tests all sorts of things, ...
      (comp.databases.oracle.server)
    • Re: [SLE] sudoers file
      ... I like it because it logs all commands, ... # This file MUST be edited with the 'visudo' command as root. ... # Oracle user is oracle on some machines, ...
      (SuSE)
    • Re: Spool in SQL*Plus without SQL statments
      ... ECHO does not affect the display of commands ... Oh and to get rid of the column heading underline I asked about ... web; not oracle docs though). ...
      (comp.databases.oracle.misc)
    • Re: Call Oracle Stored Proceedure VB.NET
      ... You also have to ensure the Commands CommandType is set to stored procedure. ... Oracle which is already written to do more work on this data, ... Dim objcnn As New Data.OracleClient.OracleConnection ... Dim objcom As Data.OracleClient.OracleCommand ...
      (microsoft.public.dotnet.framework.aspnet)