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
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
...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...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...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 ...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 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...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...Composite Datawindow w/ store procedure problem
I have a composite datawindow in which one sub datawindow is based on a
stored procedure. I use this sub datawindow in other parts of my
application without problem. I am getting "Restricted data type attribute
violation" error when this datawindow is a part of my composiite datawindow.
Generally, I've seen this error if you don't specify the call to the stored
PB10.1.01.5502 / XPSP2 / SQL Server 2000
KSI Solutions, LLC
How's the retrieval of that "sub datawindow based on a
...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 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 ...