Problems with stored procedures in a datawindow
I'm using an external datawindow which uses stored procedures for insert,=20
delete and update.
I always insert a row and if I want to delete or modify a row, I fill in=20
the datawindow with the corresponding information. In order to execute the =
appropriate stored procedure, I change the status flags of the row to=20
DataModified! using the SetItemStatus method (and call the deleteRow()=20
method if I want to delete the row). After that, I set the transaction I=20
want the datawindow to use and call the datawindow's of=5Fupdate() method.
It executes the stored p...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...Stored Procedure
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
...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 188.8.131.5224 in my tests).
"Michael Frank" <mfrank.removeme...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 ...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
...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 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?
...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...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 in creatingCROSSTAB STORED PROCEDURE datawindow thro
Iam using ORACLE( 10g Release 2 ) and Power Builder 8 for my application
through ODBC driver.
Iam facing a problem in creation and a crosstab stored procedure datawindow
through ODBC driver. It is giving an error message like
PLS-00306: wrong number or types of arguments in call to
But when i use NATIVE ORACLE DRIVER for creating CROSSTAB STORED PROCEDURE
DATAWINDOW, it is working fine. It is creating the datawindow and retrieving
successfully. But when i used this created datawindow to retrieve data by
connecting ...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 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...