PB 10.2.1 build 9004 vs Oracle client 10G (10.1.0.2.0)
We are having an issue with Oracle 10G using SP's in RPC...
Seems we cannot disable unicode in DBParm if we use DBMS=O10.
Not even with DBMS=O90
The only way we can disable it is using DBMS=O84.
Which is documented...
The problem is that our sp's get extra garbage because of unicode.
Any thoughts anyone ?
They shouldn't get 'extra garbage', the character translation is the
responsibility of the driver. That said, there was an issue, where
data binding could cause a problem. Check out the latest EBF and the
DBParm ncharbind and se...PB 6.5 Build 1264 -> Oracle 8.1.7 client -> Oracle 7.3 db = FAILURE
I think this question appeared couple of times in this newsgroup before but
anyway we are facing a problem and I do not remember solution:
Customer upgraded Oracle client software from 7.3 to 8.1.7 and is getting
error: "ORA-01007: variable not in select list" when first SELECT statement
is executed. Database server remains Oracle 7.3. Application remains the
There is no problem executing the same select from either SQLPLus or PB
We use DBParm='DisableBind=1,StaticBind=0' as usual to connect.
What is wrong?
Would really ap...EAServer 5.3.0, Oracle 8.1.7 Database with Oracle 10.1.0.2 client VARCHAR2(4000) problem
I'm having some problems in this configuration on Windows
I am developing websites on an Oracle database (8.1.7), with
EAServer 5.3.0 (build 53016), Java objects using JSP as a
Here is my problem, I have a table with 2 VARCHAR2(4000),
and when I access the webpage, the they are displayed as
'?????????????'. If I debug the PB component, when I affect
the DW field to a variable, it displays it as it doesn't
"understand" a thing (each character is replaced by a
The codeset of EAServer is UTF8, and on my client, it is
AM...Re: DBD::Oracle doesn't work with Oracle 10g (10.1.0.3) under Mac OS X (10.3.8) or how to make it working?
Hermez, et al,
On Apr 9, 2005, Hermez <4Hertz@gmx.de> wrote:
> After painful days and nights, trying to make DBD::Oracle working
> with Oracle 10g Release 1 (10.1.0.3) on Mac OS X, I am at my wits'
> I have started the hard trip with the Oracle instant client and even
> the above mentioned full version doesn't lead to a solution.
> Afterwards, I have followed the advice mentioned in README.macosx
> (included in DBD::Oracle), and installed Perl from scratch. Without
> progress, unfortunately.
> Let me describe the affected envir...DBD::Oracle 1.22 not compiling on AIX 5.3, Oracle 10g client
Content-Type: text/plain; charset="us-ascii"
root @ server > make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
/usr/bin/perl -e 'use ExtUtils::Mksymlists;...Oracle 8.1.5 driver for pb6.5 (Oracle 8i)
Does anyone know if it exists an Oracle 8.1.5 driver for pb6.5 ?
You could potentially use O84 but Oracle 8.1.5 specific changes have been
made for O84 in PB 7. There is no O85 driver (O84 is supposed to work for
both Oracle 8.1.4 and 8.1.5).
Vincent Jouve <Vincent.Jouve@nestle.com> wrote in message
> Does anyone know if it exists an Oracle 8.1.5 driver for pb6.5 ?
You can use the O84 driver or the O73 if you don't need Oracle 8 specific
Terry Dykstra (TeamSybase)
Canadi...Is it possible to connect to Oracle 10i server from PB 6.5 using oracle 8.06 as client
I am using an application developed in PB 6.5 The backend
is oracle . The client is Oracle 8.0.6 and the server is
oracle 9i. Now we are planning to upgrade the oracle server
to 10 g. Will the application work after the
upgradation,ie,will PB6.5 which is using oracle8.0.6 as
client be able to connect to Oracle 10g.
Why do you keep asking the same question over and over? You got answers
from different users, all more or less indicating 'it might, it might not'.
With PB 6.5 being so old, nobody will be able to give you a definitive
answer unless they ...PB 6.5.1 using Oracle 8i Client to connect to 8i DB
I have installed the PB 6.5.1 maintenance patch and the Oracle 8i Client
software and I am unable to create a database profile. The only database
profile type I see is for OR8 Oracle 8.0 (The workstation previously had
Oracle 8.0.5 client which was uninstalled and replace with 8.1.6). When I
try to create a profile using the OR8 Oracle 8.0 profile type I get the
error "Unable to load the requested Powersoft database interface. Please
make sure both the interface and the client are properly installed." Is
there a way to load teh pbo8460.dll and create a profile type for thi...DBD::Oracle-1.10 build problem with Oracle-8.1.7
[ I'm not on the mailing list, so I apologize if this is already a known
reported problem. Also, if this is insufficient information please
let me know and I can supply a full verbose report as directed in
the README. ]
Attempting to build DBD::Oracle-1.10 under Solaris-2.6 and
Oracle-8.1.7, I encountered the following compilation error:
oci8.c: In function `oci_hdtype_name':
oci8.c:118: `OCI_DTYPE_DATETIME' undeclared (first use in this function)
oci8.c:118: (Each undeclared identifier is reported only once
oci8.c:118: for each function it appears in.)
oci...Character set problem Oracle 10g/EAServer 5.3/Powerbuilder 10.5/JSP
Web development: JSP/Java servlets/PB Components
I'm having quite some problems with my character sets...
Here is how our system is set up
Oracle 10g (10.2.0), NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
Client PC XP Pro, NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
EAServer codeset utf8
Connection cache: utf-8
JSP charset: <%@ page contentType="text/html;
I've tried all sort of combinations, all utf-8 (a part form
the database), all windows-1252, ... But nothing seems to
work, especially with the � sign... And when I put all
utf-...Help: DBD-Oracle-1.14 make: Error 1 with Oracle 9i client
This is my second attempt to send this because My first
attempt was kicked back because my message was too big, do to putting
the output in the message. The output is an attachment this time. If
you get this message twice sorry for the inconvience.
This may...PB 5.03 app works against NT Oracle Server but not UNix Oracle Server
As the subject suggests I am able to connect the NT Oracle Server
and the application works. If I try to connect to the UNIX Oracle
erver.( Both are at 7.3.3 release of Oracle. )
I get the following dialog error:
Database transaction information not available.
Call SetTrans or SetTransObject function.
Does any one have any idea what may be wrong..
The only thing I can think of is the PB CAtalogs.....
Thanks in advance.....
I would think you are not connected. Run the application with a trace by
setting SQLCA.dbms = trace O73 or use the debugger to check ...DBD::Oracle (perl 5.8.0, Oracle 8.0.3, DBD-Oracle 1.12, Solaris 8) make problems (fprintf)
The only fprintf warning I googled was at
Any suggestions appreciated. I'm assuming since the perl Makefile.PL ran
clean, I'm using kosher Oracle libraries (binaries worked with Perl 5.6.0).
Appended output of (in order):
gcc -c -I/app/oracle/product/8.0.3/rdbms/demo -I/app/oracle/product/8.0.3/rdbms
/public -I/app/oracle/product/8.0.3/plsql/public -I/app/oracle/product/8.0.3/net
work/public -I/app/oracle/product/8.0....Where can I get native PB drivers for ( Oracle Version 184.108.40.206) with Oracle Net Client Version 7.3.3
( Oracle Version 220.127.116.11) with Oracle Net Client Version 7.3.3 with SQL
*Net version 2.x , 32 bit implementation.
All versions of PB Enterprise (5,6,7) have the native O73 driver. If you
have PB Professional, you can only use ODBC to connect to Oracle.
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn
Veena Madhavi <email@example.com> wrote in message
> ( Oracle Version 18.104.22.168) with Oracle Net Client Version 7.3.3 with SQL
> *Net version 2...