home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 5 Edit
/
05-Edit.zip
/
oraperl2.zip
/
oraperl.ref
< prev
next >
Wrap
Text File
|
1993-07-01
|
2KB
|
78 lines
.\" Quick reference sheet for OraPerl
.\"
.nf
.\"
.vs 10
.ps 10
\fBOraperl Quick Reference\fP
.ps 8
.sp 2
.ps 10
\fBOraperl Functions\fP
.ps 8
.in +2m
.sp
.ti -2m
\fB&ora_version\fP
Displays version and copyright information for Oraperl.
.sp
.ti -2m
\fB$lda = &ora_login($database, $name, $password)\fP
Logs into the specified database with the name and password given.
Returns an \fIlda\fP for use with \fIora_open()\fP.
.sp
.ti -2m
\fB$csr = &ora_open($lda, $statement)\fP
Associates the given SQL statement in the database identified by $lda.
Executes it if it contains no substitution variables.
Returns a \fIcsr\fP for use with \fIora_fetch()\fP.
.sp
.ti -2m
\fB&ora_bind($csr, $var, ...)\fP
Binds the given values to the substition variables in the SQL statement
associated with $csr, and executes the resulting statement.
.sp
.ti -2m
\fB$n = &ora_fetch($csr)\fP
Returns the number of fields available from the query.
.sp
.ti -2m
\fB@ary = &ora_fetch($csr)\fP
Retrieves the (next) output data from the statement identified by $csr.
.sp
.ti -2m
\fB&ora_close($csr)\fP
Finishes the SQL statement identified by $csr.
.sp
.ti -2m
\fB&ora_do($lda, $stmt)\fP
Equivalent to \fI&ora_close\fP(\fI&ora_open(...))\fP
for statements which have no substitution variables and do not return data.
.sp
.ti -2m
\fB&ora_logoff($lda)\fP
Logs out of the database identified by $lda.
.ti -2m
.sp 2
.ps 10
\fBOraperl Variables\fP
.sp
.ps 8
.ti -2m
\fB$ora_errno\fP (read only)
Contains the error code from the last funtion call.
.sp
.ti -2m
\fB$ora_errstr\fP (read only)
Contains the error message corresponding to $ora_errno.
.ti -2m
\fB$ora_debug\fP (if debugging is enabled)
Contains the debugging flags for \fIOraperl\fP, initialised from Perl's -D flag.
May be set by a program to debug only certain parts of the script.
The following flags are meaningful:
.ta 5m
\0\08 report function entry and exit
\032 report conversions between strings and numerics
128 report use of malloc and free