home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 5 Edit
/
05-Edit.zip
/
oraperl2.zip
/
Hints
< prev
next >
Wrap
Text File
|
1993-07-01
|
2KB
|
53 lines
This file contains hints and tips about Oraperl, dealing with problems which
have arisen in the past.
Retrieving Dates
================
Due to a bug in earlier versions of Oraperl, it was not possible to return
a DATE field in default format. This has been corrected in patch 3. You may
still wish to use Oracle's to_char() function for greater control over the
format in which the date is returned.
Building on a Convex machine
============================
Uncomment the definitions of STRTOL and PUTENV in the Makefile.
Building with Perl v3
=====================
Ideally, get hold of v4. However, if you have to work with v3, uncomment
the definition of STR_2MORTAL in the Makefile.
Using Bind Variables
====================
The support for bind variables does not reflect the full potential of Pro*C.
Firstly, bind variables may only be numeric; named bind variables are not
supported. They must run in sequence from 1. (This is to make it easy for
&ora_bind() to check that it has received the correct number of parameters.)
Secondly, they may only be used to modify values within the SQL statement,
not field or table names. Thus
insert into telno values (:1, :2)
is valid, but
select * from telno order by :1
is not. This made the interaction between &ora_open() and &ora_bind() simpler,
but if it's a serious restriction for you let me know, and I'll look into
extending it. (Of course, there's nothing to stop you doing:
$order_by = "name";
&ora_open($lda, "select * from telno order by $order_by");
so I don't think it should be too big a problem.)