Re: [newbie]How to call stored procedure using DBIx?

On Fri, 28 Dec 2007 21:19:06 +0800, Tony Winslow wrote:
I've stored procedures defined in my database schema, and I need to call
them in my code.
The arbitrary-sql approach won't help since it writes sql statements in
source code to act as stored procedures. So could I do that in DBIx?

DBIx::What? In DBI, with a DBD::Oracle driver, I call stored procedures
with a database handle thus:

$dbh->do( "Begin somepackage.someprocedure; End;" );

It's picky about the semicolons.

--
Peter Scott
http://www.perlmedic.com/
http://www.perldebugged.com/

.

Relevant Pages

  • Automatically migratring metadata between instances of SQL Server 2000
    ... straight from your source code. ... >(updated or new Stored Procedures and tables) from one ... >whether there is a good way of backing up the metadata ... how can I script the process of ...
    (microsoft.public.sqlserver.tools)
  • Re: How to call stored procedure using DBIx?
    ... The arbitrary-sql approach won't help since it writes sql statements in ... source code to act as stored procedures. ... Yet I don't know how to call my stored procedures directly using ...
    (comp.lang.perl.misc)
  • Re: Help needed to apply Source Control to Stored Procedures
    ... Where is the source code for the stored procedures? ... VS.NET to a database server (via a database project)? ... to enable source control for stroed procedures is greyed out and I cannot ...
    (microsoft.public.vsnet.setup)
  • Re: Using Reflection to Dynamically Determine Stored Procedure Name
    ... If you have access to the source code, there's no reason that you couldn't ... Dacon Software Consulting ... names of the stored procedures to call as hard coded strings. ... then work my way down to the business/data layer assembly. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to call stored procedure using DBIx?
    ... The arbitrary-sql approach won't help since it writes sql statements in ... source code to act as stored procedures. ... Yet I don't know how to call my stored procedures directly using ...
    (comp.lang.perl.misc)