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...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
...PowerBuilder 8 and Oracle 8 Stored Procedure Datawindow
I worked many years with Sql Server and it was easy to do, but I don't
know how to do in Oracle:
How a Oracle 8 Stored Procedure can return to PowerBuilder 8 the result
of a query or a recordset (in Sql Server is as easy as put a select
sentence at the end of the procedure). I don't want to use temporary
tables for a concurrence issue.
Can anyone give me a help?
Thanks in advance,
Ra�l La Torre
You need a REF CURSOR. See enclosed datawindow examples.
Terry Dykstra (TeamSybase)
product ...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 with Oracle stored procedure
We are using dw with Oracle stored procedure result set as output reference
(The method that mentioned in faxline 44553). As this method required us
to set DBPARM with PBDBMS=0, which enable the stored procedure to return
result set to a dw.
One problem we encounter is that after we use this PBDBMS=0 setting, all
other dw with simple SQL won't work any more. When try to update a dw
with simple SQL, PB complaints about the record has been changed, but the
data actually is unchanged. Our dw have setting for Where Clause for
Update/Delete is 'Key & Updateable columns&...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
...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 ...Stored Procedure datawindow with Oracle
Is it possible to create stored proc datawindow with oracle and update it?
...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 188.8.131.5224 in my tests).
"Michael Frank" <mfrank.removeme...Oracle stored procedures and Datawindows
Using an additional OUT parameter with an Oracle stored
procedure does not display the updated value back on the
Any ideas ?
Assuming you are the same person as Spidey, please don't repost the same
question. If not, I apologize.
Did you change the Ref Cursor to reflect the additional column(s)?
Did you change on the datawindow add the additional column(s). You add them
in using the 'View, Column Specifications' sheet. Rightclick on the list of
columns and append or insert a new row.
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.syba...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...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...