powerbuilder 6.5 & Oracle 10
Hi, we have an app built by powerbuilder 6.5.1. Now we are
gonna miggrate from an Oracle 8 to an Oracle 10G database.
Anyone Knows if PB 651 can get connect with this version of
Do i need any new dll?
It may not. PB6.5 isn't supported anymore and if you see by this sybase
article, they start with PB8:
Senior Systems Analyst II
Command Technologies, Inc.
<marianux> wrote in message news:email@example.com...
> Hi, we have an app built by powerbuilder 6.5.1. N...Powerbuilder 5 to Powerbuilder 10
We have migrated our application from powerbuilder 5 to powerbuilder 10.
after migration to version 10, alignment in most of reports disturbed.
please advice me some solution.
On Fri, 29 Feb 2008 12:45:01 +0100, Adnan Jamil <firstname.lastname@example.org>
> Hi all
> We have migrated our application from powerbuilder 5 to powerbuilder 10.
> after migration to version 10, alignment in most of reports disturbed.
> please advice me some solution.
Is this a SQL Anywhere question?
If not, you have posted to the wrong forum.
If yes,...update powerbuilder 10.0 to powerbuilder 10.5
I need update powerbuilder ver 10.0 to powerbuilder 10.5. by the way,
my company already buy pb ver 10.00 and need to update to ver 10.5.
the question :
if update pb from ver 10.00 to ver 10.5, is it free of charge ? if no,
How I found the price ?
10.5 is considered a major release, you would need to purchase an
This is what I found on Sybase's own eshop:
You may find better through an online merchant, partner or local
This is also the Ent...Impact Analysis Powerbuilder & Tables & Stored Procedures
I have 2 datamodels:
One with tables & stored procedures
One with datawindows & nvos
I want to do an impact analysis against a table
and list all the datawindows and stored procedures that call
Is this possible? Thank you
Worst case is you can create your own relationships using the Extended
Dependency. Those can be created between any objects ( i think ). So
at a minimum you can build them.
Is there some way to do this automatically, I don't know. There's
always VBScript if nothing else.
To do IA you need to link the objects. Here is how you can do it.
...Moving from PowerBuilder 6.5 to PowerBuilder 10
I have an application developed in PB6.5 and due to changing
requirements application has to be switched to PB10.
There when I am trying to regenerate the contents of my PBL,
it is giving error stating:
C0042 : cannot compile without valid database signon.
This error is coming for few windows but not for the
functions I have made in my pbl. It is working perfectly
fine for pb6.5.
Can you please help me on this.
Thanks in advance.
First you must to connect to the database by a profile, continue migrate
<Manich Tripathi> escribi...PowerBuilder 10.5.2 Build 7826 differs from PowerBuilder 11.5.1 Build 4675
Apparently there's some data conversion issues that differ from PowerBuilder
10.5.2 and 11.5.1 (builds listed in subject). The following mini scrip
results in different returned values:
lb_test = 48
ld_test = Dec(lb_test)
In PowerBuilder 10.5.2, the messagebox displays the value "48". In
PowerBuilder 11.5.1 the messagebox displays the value "0.48". It appears
that in PB 11.5.1, it's dividing the result by 100 for some reason. It
appears to be a bug, just wanted to ve...ORACLE Stored Procedures in PowerBuilder
I am trying to pass a dynamic procedure name and dynamic number of arguments
to a DECLARE and EXECUTE (procedurename) statement within Powerbuilder 6.5.
The name and number of arguments are stored on a table and they are
syntactically extracted into variables. Any suggestions?
...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-...PowerBuilder 10.5.2 does not connect to Oracle 10.0.2 Windows 64-Bit...
I am trying to connect to Oracle 64-Bit from Powerbuilder 10.5.2(both
from IDE & Runtime)-Windows.
I am not able to connect to the Database , error message prompted is
"Oracle library oci.dll could not be loaded."
Timely responses would be greatly appreciated.
Do you have 32-bit Oracle client installed?
Terry Dykstra (TeamSybase)
product enhancement requests:
<email@example.com> wrote i...Oracle store procedure problem using Powerbuilder and Oracle 184.108.40.206 Net
Powerbuilder version 6.0.00 / 6.5 Build 444
Oracle Net 220.127.116.11
I found there is problem with Oracle store procedure having more than 6 in
parameters. I got GPF error on Window 95 and Dr. Watson error on NT.
Also, I found it works find in Oracle Net 18.104.22.168. Is this a bug? Is
there any new patch for this if it is a bug. Any recommendation about What
version Oracle Net or SQL Net should I used for Oracle server version
22.214.171.124 (I don't think I am using any Oracle 8 new features)?
Thanks in advance,
If you use PB 6.5, you can try the new Oracle 8 driver:
This is a multi-part message in MIME format.
One of our customer has Oracle 7.3 Server ; sinc PB 10.5 has not support =
for Oracle < 8 we used a workaround using
Oracle Client v.8 ; it works fine with a big problem: we cannot select =
more than 32 columns in a select.
We obtain an error : ORA-01001: invalid cursor=20
Could anyone help me, with any workaround, or configuration to change to =
allow out application work properly ?
...Powerbuilder Cursor & Stored Procedure
I am new to Powerbuilder 9.0, I have some queries
Can anyone tell what maximum number of rows a curosor can hold? Is
there a way to specify maximum limit a cursor can hold in powerbuilder
will it better to use the query from which cursor is built, to create
a stored procedure.
also what maximum number of rows a stored procedure can hold?
Please give me advise on use of stored proc Vs. Cursor
The size of a cursor is driven by the number of rows that the underlying
Cursors are "server-side" implementations - PowerBuilder runs on the client, ...Using Oracle Stored Procedures in Powerbuilder
I need to populate a datawindow using an Oracle stored procedure. I went
through various faxline documents and found that the PBDBMS.put_line
option was not useful in my case, as I was going to return multiple
result sets based on cursor processing. I took the suggested option of
creating a package which had a stored procedure which was returning
various output variables of type table. The output variables correspond
to each column of the datawindow. I will have to define the procedure as
an RPC in the transaction object. I am having a problem with this. When
I go into Local external f...Executing oracle stored procedures from powerbuilder
We have a thin-client application written in powerbuilder with all the
processing (add,update,delete etc) in Sybase stored procedures. We are
currently porting this app to Oracle 8.1.6. We use the following syntax to
execute stored procs for sybase
Declare instance variables:
DECLARE ptKitAdd PROCEDURE FOR
@RC = p_KitAdd_p
@OrgId = :OrgId,
@ProductId = :ProductId,
@KitID = :is_kitid,
@Note = :is_notename,
@Letter = :is_letter,
@paper = :is_paper,
@inTS = :id_TS ;
In script for add button: