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...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 22.214.171.12424 in my tests).
"Michael Frank" <mfrank.removeme...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...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
...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" <email@example.com> 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...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...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 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?
...problem while running a stored procedure from powerbuilder
When I run a Sybase stored procedure from PowerBuilder, I
get an error message as "'The parameter of type 111 did not
have a valid value". What is this parameter type 111? Can
anyone tell me the reason for this error and how should I
resolve the same?
PS: Sybase version is 12.5 and PowerBuilder version is 8.0.3
> When I run a Sybase stored procedure from PowerBuilder, I
> get an error message as "'The parameter of type 111 did
> not have a valid value". What is this parameter type 111?
Type 111 is pro...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 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 executing the stored procedure from powerbuilder
i have a stored procedure in sybase as follows.
create procedure p_tes_update_open_seats @class_id int, @enroll_cnt int,
@ret_value int output
Declare @capacity int, @open_seats int
Select @capacity = capacity
Where class_id = @class_id
Select @open_seats = @capacity - @enroll_cnt
Set open_seats = @open_seats
Where class_id = @class_id
if @@error !=0
Select @ret_value = -1
Select @ret_value = 1
i wanted to execute the above procedure, so i wrote like the code as follows in
powerbuilde...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 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