home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 5 Edit
/
05-Edit.zip
/
oraperl2.zip
/
ex.pl
< prev
next >
Wrap
Text File
|
1993-07-01
|
655b
|
28 lines
format top =
Name Phone
==== =====
.
format STDOUT =
@<<<<<<<<<< @>>>>>>>>>>
$name, $phone
.
die ("You should use oraperl, not perl\n") unless defined &ora_login;
$lda = &ora_login("t", "kstock", "kstock")
|| die $ora_errstr;
$csr = &ora_open($lda, "select * from telno order by name")
|| die $ora_errstr;
$nfields = &ora_fetch($csr);
print "Query will return $nfields fields\n\n";
while (($name, $phone) = &ora_fetch($csr))
{
write;
}
do ora_close($csr) || die "can't close cursor";
do ora_logoff($lda) || die "can't log off Oracle";