Problem with using Oracle stored procedure to create datasource for DW in PB 5.0.02
Using PB 6.0, I can create datawindow by using ORACLE stored procedure as
datasource ( I use cursor variable as IN OUT parameter ) without problem at
all. But when I used PB 5.0.02, I got error message even if I use same
stored procedure in same server ( Oracle version 7.3 ).
This was what the error message said:
"Cannot create Datawindow
'ORA - 06550: Line 1, Column 61:
PLS - 00103: Encountered the symbol "14" when expecting one of the
. () , * @ % & | = - + < / > in mod .......'"
Is anyone can help me?
kuan...Oracle store procedure problem using Powerbuilder and Oracle 126.96.36.199 Net
Powerbuilder version 6.0.00 / 6.5 Build 444
Oracle Net 188.8.131.52
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 184.108.40.206. 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
220.127.116.11 (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:
ftp...How to create a Stored Procedure DataWindow using PB5.0.02 and Oracle 7.2 ?
As you can see I'm trying to create a DW Stored Procedure DataWindow
using PB5.0.02 and Oracle 7.2
If I create a SQL Select DataWindow it works but if I try I Stored
Procedure DataWindow, It shows the list of my stored procedures, the
source code but when I click at OK button, nothing happens
Please, Reply this to me as soon as possible at my e-mail:
Thank you very much in Advance
Maur�cio A. Correa
It seems to me that the stored procedure in question dont have any result
set declared. TO have a datawindow based on ...I am using PB 6.5.1 and MSSQL Server 7.0. I have created a stored procedure and painted a DW off of
I am using PB 6.5.1 and MSSQL Server 7.0. I have created a stored procedure
and painted a DW off of it. When I run the procedure in MS query tool
everything runs fine and the result set is returned correctly. However,
when I run it out of PB one of the columns is returned as a null value. The
column is fine in the query tool but nothing on the PB side of life. I'm
thinking that this must be a connection issue but I have no real idea.
What is the datatype of the column? If you are using ODBC, you can run a
driver trace and perhaps get more inform...Oracle 8.0.5 stored procedures problem in PB 6.5
I am trying to create a datawindow in PowerBuilder 6.5 with Stored Procedure as
source. The stored procedure is on Oracle 8.0.5. It returns multiple rows. I am
using REF Cursor as IN OUT parameter to pass the result set.
Everytime I select the stored procedure while creating the datawindow, I get an
error 'Invalid Cursor'. Has anybody encountered this problem? Am I doing
P.S. If I use 7.3 drivers to connect to Oracle 8 database, everything works fine
but there are some Oracle datatypes which are recognized only by 8.0 drivers and
unfortunately I am us...MSSQL 6.5/PB 5.0.2 DataWindow Stored Procedure
PB ver. 5.0.2 & MS SQL ver 6.5
I am having problems using a DataWindow based on a stored procedure with
MS SQL. If I include any arguments for the stored procedure, it fails
with a SQLSTATE 22005 error "error in assignment". The same stored
procedure in Sybase SQLAnywhere DB does not have any errors. We have no
other problems with stored procedures exeuted from the application, only
when used as the data source for a datawindow with MS SQL.
Any input appreciated.
Primus Partners Inc.
Are you trying to pass an empty string to tha...Oracle Stored Procedure problems with 8.0.5 and PB 6.5 Error ORA-25123
We are getting the follow message when we execute this:
A database error has occurred.
Database error code: 25123
Database error message:
ORA-25123: Too many components specified in the name.
Has any one seen this or knows. I have talked to Oracle and they have not.
We have the latest builds from PB including a the weekly build.
A wild guess: the double-quote confuses Oracle. Try a single-quote.
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
Mark Drummond wrote in message ...
>W...PowerBuilder 5.0 to 18.104.22.168
I hope this the correct venue for this question. I have a fresh install of
PB 5.0 and I need to upgrade it to 22.214.171.124. I have found plenty of
reference/downloads to 126.96.36.199 on the sybase website, but I need to go from
5.0 to 188.8.131.52.
Where can I download the correct patch/upgrade?
184.108.40.206 is no longer available. You can choose between 5.0.03 (bug infested)
and 5.0.04 (stable).
Roy Kiesler [TeamSybase]
Sybase Developer Network (SDN) - http://sdn.sybase.com
MySybase - http://my.sybase.com
"Dwayne Bordelon" <dwayne.bordelon@shawinc...Problems with Powerbuilde 8.0.2 and Oracle 8.0.5 Client
I have been problems to set up my Power Builder (8.0.2 Build 9506)=20
application to run against Oracle, Client 8.0.5. The fields that was=20
created like DATE in INFORMIX database, doesn=B4t run correctly over Oracle=
that use only DATETIME data type (native).
In datawindow the field is DATE data type, and on Oracle table, this field =
is DATETIME. When PB select this field I receive a wrong date. For example,=
I save this date (using the same datawindow), "2002-12-05", then when I=20
Retrieve the data, the data looks like this "48/51/1398&qu...Problems with new FireFox 220.127.116.11 and 0.8.0.2 XForms extension
We are running the 0.8.0.2 extension and are having problems with the
new FireFox 18.104.22.168 that just came out. It looks like instance
documents are not loading on the Windows platform.
Is anyone else having problems with this?
Thanks - Dan
It won't work. We added support for current() which means changes to
XPath which means that any interaction in xforms that requires xpath
will fail (almost all of them if you consider binding, etc).
Dan McCreary wrote:
> Hi all,
> We are running the 0.8.0.2 extension and are having problems with th...Application created in new version of .NET (3.0 or 3.5) can use the library created in older version of .NET(i.e.-1.0 or 2.0)?
I am using Visual Studio .NET compiler for compiling my application . We have plugins (as library) which the user can write by their own in .NET . We are building our code in Visual Studio 2005 but we have already some plug-ins which are written in previous versions of Visual Studio (i.e. 2002 and 2003). Is these plug-ins will work with the new build of the application or I need to build these plug-ins as well in Visual Studio .NET 2005. These plugins are created as library.
Is their any differences between .NET 1.0, 2.0 and 3.0 because of which the old libraries (created in o...PB 5.0.04 DW retrieve using stored procedure to SA 7
Our PB 5.0.04 application has a few datawindows which retrieve using
stored procedures. These worked fine running against SA 5.5. It
seems retrieval of these same DWs against Sql Anywhere results in a
"Invalid use of null pointer"
These DWs retrieve just fine against SA 5.5.
Has anyone else experienced this?
...Connecting PB 5.0 to Oracle 22.214.171.124.0
Would anybody help me figure out this problem?
When trying to connect to the Oracle 126.96.36.199.0 database from PowerBuilder
5.0 (Windows NT 4.0) using the database profile I set up, I got the
following error message:
The database profile in PowerBuilder is set up as follows:
Profile Name : Connect_DB (i.e any name)
DBMS : 071 ORACLE v7.1
UserID : (i.e blank because they are not
Password : ( "
Data...Oracle Client 188.8.131.52 and PB 6.5 problems
We are experencing problems on Retrieve and with stored procedures.
Has anyone else had similar problems.
We are using the 8.0.5 client attaching to oracle 8.0 Using PB 8.0 native
The problem is most pronounced on a tabed object build using user objects
We get a "pb60.exe Exception: access violation (0xc0000005), Adress:
0x0593bf21" Error on a retrieve.
Can anyone tell me the most current 6.5 build and native drivers. I believe
that the problem lies with the sqlnet and or PB native drivers. If there are
new one I want to try those before going...