I created a datawindow by using stored proc as datasource in PB 6.0. Db
is sqlany 5.5.04.
On one machine, when I tried to retrieve same datawindow from same
database, it is retrieving.
But on another machine, it's giving me the error column list do not
Is it related to pbodb60.ini file? Or with Powerbuilder profile( dbparm
I tried to change static bind = 0 to 1, but result is same.
Has anyone seen before? What is the problem?
Mahendra Dhamdhere, CPDA
Pl. Remove nospam_ from email id
...Powerbuilder datawindow + stored procedure
database ASA 7
When we build a datawindow in powerbuilder we choose the table and the
columns to build it. There is also the possibility to build a datawindow
from a stored procedure.
Is a stored procedure running faster because the database remembers the
"ontsnapt" <firstname.lastname@example.org> wrote:
> database ASA 7
> When we build a datawindow in powerbuilder we choose the table and the
> columns to build it. There is also the possibility to build a datawindow
> from a stored procedure.
> Is a stored...Problem with stored procedure datawindow
This is a multi-part message in MIME format.
I have converted a datawindow that had a SQL Select to a Stored =
Procedure that is retrieved on a page using the HTML generator. Now the =
datawindow will not retrieve. I have tried setting the weight of the =
datawindow in the dw painter to all options and still no luck. I have =
even hardcoded values in the retrieveex script and the datawindow does =
not return any rows. The SQL Select dat...problem with a stored procedure datawindow
I often work with datawindow based on oracle stored procedure and i never
had any problem except with one.
This datawindow works fine during 3 hours (approximately) and then becomes
invalid. The error is :
ORA-06553: PLS-707: structure non prise en charge ou erreur interne 
ORA-06550: Ligne 1, colonne 16:|PL/SQL: Statement ignored|
which seems to be an internal error...
I thought it was an instance problem and i shutdown the database and
re-start it but
the problem is still the same.
Datawindow based on stored procedure used a cursor that is never closed. Can
the problem be ...Datawindow with Stored Procedure Problem
I get the message "Select error: Requested result set number 1 not
found" from a datawindow when my Stored Procedure does not get a result
set. It works fine when there is data returned. Normally, when no data
is returned I just get zero rows returned without an error message. The
Stored Procedure works fine when no data is returned outside of PB. I am
using PB 7.0.2 C3 with Sybase 11. Any one have any thoughts on this
If you are using a datawindow, you HAVE to have a result set. That
result set could contain 0 rows. If your stored procedure has a...store procedure datawindow problem
In sybase ASE 11.5, I wrote such a store procedure:
CREATE PROCEDURE up_myproc
@arg_parm2 char(40) )
CREATE TABLE #temp_alertlist(
content_1 char(255) null,
content_2 char(255) null,
content_3 char(255) null,
content_4 char(255) null,
windowname char(255) null
Insert into #temp_alertlist
SELECT * FROM #temp_alertlist
In pb8, I made a datawindow from this store procedure, when I preview it, it
returns the correct results, but when I put this datawindow in my
...Datawindow against Stored Procedure problem
Has anyone had problems creating a datawindow against a database stored
procedure? I have a simple stored procedure that returns a result set.
When I try to create a tabular datawindow against the stored procedure, I
click 'finish' and PocketBuilder simply disappears (without even the
standard 'do you want to send the report to Microsoft' dialog box!).
ASA9 version 9.0.2 build 3044
PocketBuilder 2.0.1 build 688
I have no problems with this (I am running ASA 220.127.116.1124 in my tests).
"Michael Frank" <mfrank.removeme...Oracle stored procedure problems with datawindows
Currently using oracle 8 and using a stored procedure as a source for a
when the procedure is asscoiated with the datawindow it comes up with an
oracle error stating that the variabels have not been initalised.
The stored proc has two in variables and an inout.
Has any one had this problem and found a solution.
I had this problem. But I was necessary execute a stored procedure from the
When I checked my connect string to Oracle database in the connect script
and my connect string in the database profile I found a solution this
My con...problem with Oracle Stored procedure datawindow
I have a datawindow with a PL/SQL stored procedure
that uses REF cursors.
There is one block in the PL/SQL script that
has its own exception handling code to
essentially ignore the no_data_found condition.
When this code is included the datawindow
causes a GPF. IF I don't include the code
the datawindow does not GPF, but the procedure
ends without really completing the process and
hence no data is retrieved .
I am using Oracle 8i database and Powerbuilder 7.0.1
Any tips/work arounds are greatly appreciated
Can you show some code?
...DataWindow This, DataWindow That...
Blah blah blah
You've heard it enough that you don't even want to comment on how many
....but it can't be enough anymore...can it?
This from one of our colleagues
(and yes my apologies for taking it out of context)...
"...PB covers all you need to do that in ONE Tool. This
includes Windowprogramming ( meaning the interface to the user:
Windows, Sheets, diallougeboxes, etc.), Database operability AND
Reporting! Well, I see als well as many other PB users that some of
the implementations and features PB offers are improvable. But thi...Problem in updating a stored procedure datawindow
I am facing a problem while updating stored procedure
datawindow. I am using PB 9 and MSSQL Server 7.0.
The Stored Procedure which is fired for inserting into a
table , a trigger is written on this table.
Last line of trigger is creating problem is as follows -
UPDATETEXT Keane_Log.details @ptrval NULL 0 WITH LOG @tmp
When dw_1.Update() is issued it is giving following error -
ERRTEXT - Number of parameter do not agree
When the above mentioned line is commented in trigger and
dw_update() is fired then it is successfully updating data.
Alternatively if datawin...Problem calling stored procedure for datawindow update
I have a datawindow that uses stored procedures for update, insert, and delete.
One of the arguments of the Insert stored procedure is mapped to a computed
column. The problem I am having is that the Argument is of type SmallInt, and
even though my computed column evaluates to a numeric value, it always tries to
send the value as Varchar. If I try to access the computed column with
powerscript I must use the GetItemNumber function, so I know the datawindow sees
my computed column as a numeric type, so why does it convert it to Varchar to
send it to the stored procedure? Is ...Problem in creating stored procedure datawindow in oracle
I am using OBDC driver to connect to ORACLE( 10g Release 2 ) for my
Power Builder( PB8 ) application.
I have created following package and stored procedure
CREATE OR REPLACE PACKAGE a_demo IS
TYPE my_result_set IS REF CURSOR RETURN work_orders%ROWTYPE;
CREATE OR REPLACE PROCEDURE proc_demo (out_result IN OUT
FOR SELECT * FROM work_orders;
But when iam creating datawindow through this stored procedure, it is
giving error like
Cannot Create Datawindow
'SQLSTATE = 37000
...Problem with Datawindow Stored Procedure Closing in Oracle
Has anyone run into a problem where they are using a
stored procedure as the source for a datawindow, but Oracle
is reporting that the cursor does not close (even if this
window and datawindow are destroyed?). Is there a manual
way to close the cursor (opened in a datawindow)?
- Joe Slawsky (NOSPAMFORME_jslawsky@planetdx.com)
What version of PB?
Joe, Slawsky wrote:
> Has anyone run into a problem where they are using a
> stored procedure as the source for a datawindow, but Oracle
> is reporting that the cursor does not close (even i...