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?
...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...Create datawindow using Oracle stored procedure
I'm using PB 7.0.2 and Oracle 8i to try and create a datawindow with a
stored procedure. When using the wizard and it's selecting the stored
procedure I receive a validation error on some stored procedure which has
different owner than the database connection. I have put the owner name in
the database preference that I am connected to and still get the error. Is
there a way to tell it specifically where to get the stored procedure or
does PB 7 even accommodate this option?
Putting the owner name in the database preferences just filters out
the list of objects in table...Unable to create datawindow through Oracle Stored Procedure
I have installed Oracle 8.0.5 on windows 2000 (at home just for my lab
practice). When I have created datawindow through oracle stored procedure,
I am getting following error message,
Cannot create datawindow
ORA-20999: ORA-01001:invalid cursor||
ORA-06512: "at SYSTEM:SP__DW_GROUPS", line 17
ORA-06512: at line 1
Nothing wrong with Oracle stored procedure and Package. They deployed to
oracle database without error. Anyone can guide me what I have missing
here. Thanks in Advance
...How do we create datawindow object using Oracle Stored Procedures
I am working on Oracle 7.3 and want to create datawindow object using
If stored procedure says
Select * from tabletame
If, we use cursor and define a table in stored procedure than how will
it go back and display in datawindow.
How this data will go back to datawindow object.
...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 ...Create DataWindow by using Oracle 7.3 Stored Procedure
I am using PowerBuilder Enterprise/32 version 5.0.03 and Oracle 7.3.
When I try to create a DataWindow by using Stored Procedure, I can't get
the screen to define the result set. However, if I connect to the local
ODBC, it works fine. Any tips?
>> Can't define result set <<
Oracle procedures are a little tricky when you first start to use them.
You need to use Oracle Packages and Records to get the result set to be
read in. I would suggest looking at www.teamps.com and follow the links
to Bruce Armstrong'...How to create a Stored Procedure DataWindow using PB5.0.02 and Oracle 7.2 ?
As you can see I'm trying to create a DW Stored Procedure DataWindow
using PB5.0.02 and Oracle 7.2
If I create a SQL Select DataWindow it works but if I try I Stored
Procedure DataWindow, It shows the list of my stored procedures, the
source code but when I click at OK button, nothing happens
Please, Reply this to me as soon as possible at my e-mail:
Thank you very much in Advance
Maur�cio A. Correa
It seems to me that the stored procedure in question dont have any result
set declared. TO have a datawindow based on ...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
...Problems about datawindow that is created from procedure.
I am using PB 6.5.1, Oracle8i
I have some problems of retrieving data from Oracle db.
We need create a datawindow from a procedure that is locates in a
package,this package has beed tested ok, this procedure has three arguments,
two of them are passed in, the rest one is for out, the execute statements
in datawindow as following:
"execute package_name.procedure_name;0 argument1 = :varible1,argument2 =
But when we run this datawindow, the error occurs as following:
"wrong number or types of arguments in call to the package"
Tha...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 ...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...