Any good coders out there? Perl?
- From: "amerar@xxxxxxx" <amerar@xxxxxxx>
- Date: 21 Mar 2007 09:13:35 -0700
Hi All,
I need to convert a PHP script into Perl. This PHP script interacts
with our Oracle database. It executes some stored procedures and
returns values. I've pasted the PHP code below, I'm just not sure how
to code it in Perl & DBI. Can anyone help?? I would really
appreciate it.
PHP CODE
----------------
$conn = ociplogon("scott", "tiger", "ABCD.world");
$curs = OCINewCursor($conn);
$stmt = OCIParse($conn,"BEGIN AUTO_CHARGE.EXP_RENEW_SUBSCR(:data);
end ;");
ocibindbyname($stmt,"data",&$curs,-1,OCI_B_CURSOR);
ociexecute($stmt);
ociexecute($curs);
while (OCIFetchInto($curs,&$data)) {
$customer_id = $data[0];
$owner_name = $data[1];
$type = $data[2];
$code = $data[3];
..
..
..
}
.
- Follow-Ups:
- Re: Any good coders out there? Perl?
- From: Mladen Gogala
- Re: Any good coders out there? Perl?
- From: Mladen Gogala
- Re: Any good coders out there? Perl?
- Prev by Date: $sth->bind_columns() with varying amount of columns
- Next by Date: Re: Apache::Status plugin to show all DBI connections and statements
- Previous by thread: $sth->bind_columns() with varying amount of columns
- Next by thread: Re: Any good coders out there? Perl?
- Index(es):
Relevant Pages
|
|