----- Original Message ----- From: "Karina Nahagama" <[EMAIL PROTECTED]> To: "Sterin, Ilya" <[EMAIL PROTECTED]>; "Randy Kobes" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, December 03, 2001 3:29 PM Subject: About Stored procedures
> My name is Karina Nagahama, > > I'm working on Windows NT and I'm using Apache, Perl , mod_perl and Dbi > modules. > I downloaded them from > ftp://theoryx5.uwinnipeg.ca/pub/other/perl-win32-bin-0.7.exe > > In order to find some data in the database I wrote the following code. > my $dbhandler = DBI->connect(oradb_service(), oradb_user(), oradb_pass()); > my $state = $dbhandler->prepare($SQL_STR); > $state->execute(); > > Then I use while to see the data, as follow. > while (my $RsTsuwaMeisai = $state->fetchrow_hashref){ > print "<BR>(".$RsTsuwaMeisai->{BUSYO_NAME_1}.")"; > } > > > Now I want to know, > how to execute an stored procedure and send some parameters to it. > How can I do that?. Why don't you try to read document? http://theoryx5.uwinnipeg.ca/CPAN/data/DBD-Oracle/Oracle.html#PL_SQL_Example s Japanese translation: http://member.nifty.ne.jp/hippo2000/perltips/DBD/Oracle.htm#PL_SQL_Examples ============================================== Kawai, Takanori(Hippo2000) Mail: [EMAIL PROTECTED] [EMAIL PROTECTED] http://member.nifty.ne.jp/hippo2000 ==============================================
