Professional Web Applications Themes

Call PL/SQL procedure from Perl - DBI - PERL Miscellaneous

Hi, How I can call PL/SQL store procedure from Perl - DBI script? Thanks in advance, Alex continued...

  1. #1

    Default Call PL/SQL procedure from Perl - DBI

    Hi,

    How I can call PL/SQL store procedure from Perl - DBI script?

    Thanks in advance,
    Alex
    Sashafay Guest

  2. #2

    Default Re: Call PL/SQL procedure from Perl - DBI

    Sashafay wrote:
    > Hi,
    >
    > How I can call PL/SQL store procedure from Perl - DBI script?
    >
    $dbh->do("begin procedure_call; end;");

    Actually, you can access procedure parameters (even in/out ones) and
    read dbms_output. It is documented in the DBD::Oracle POD.

    Joachim

    Joachim Pense Guest

  3. #3

    Default Re: Call PL/SQL procedure from Perl - DBI

    Ron Reidy <r_reidy@comcast.net> wrote in message news:<3F5BC057.4040600@comcast.net>...
    > perldoc DBD::Oracle
    >
    > Sashafay wrote:
    > > Hi,
    > >
    > > How I can call PL/SQL store procedure from Perl - DBI script?
    > >
    > > Thanks in advance,
    > > Alex

    Thanks Guys!

    Regards,
    Alex
    Sashafay Guest

Similar Threads

  1. asp to call Oracle stored procedure
    By eddie wang in forum ASP Database
    Replies: 0
    Last Post: March 2nd, 10:08 PM
  2. Replies: 0
    Last Post: August 23rd, 07:51 PM
  3. the SQL1131N error when I call a stored procedure
    By zhouhaiming in forum IBM DB2
    Replies: 3
    Last Post: July 24th, 09:57 AM
  4. remote call procedure call failed
    By Dave Warwick in forum Windows Networking
    Replies: 0
    Last Post: July 5th, 03:59 AM
  5. Call a stored procedure with decimal parameter
    By Mona in forum ASP.NET General
    Replies: 2
    Last Post: June 27th, 01:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139