Whan can i do? make "string" data type convert to "window" data type, and use a "window" name to get it ancestor "window name", thanks! i use pb5
With a string window name, you can open a window of that type if you need
to. You could, of course, query that window object for any attributes.
Another option is to use the LibraryExport function to export the definition
of the window which is specified by the string. You can then parse the
resulting file to get information on the ancestor object.
"Rich" <firstname.lastname@example.org> wrote in message
...How to use Oracle 7.3 stored procedures as datawindows' data sources?
We are trying to use stored procedures as datawindows' datasources using
PB5.0.03, Oracle 7.3.3, SQL*Net 2.3.3, clients with Windows 95, and the
server with NT 4.0. When we try to do that, we receive an ORA-06550 error
refering to a PLS-00306 error (wrong number or type of arguments in call to
'empleado'). We have tested the procedure directly in the database and
everything seems to be ok. Does anyone know where the problem can be? or
even better, how can we use the stored procedures as data sources for the
We created a package and the stored proc...How to retrieve the data from the data using the stored procedure?
Hi All, Can any one let me know "How to retreive the data from the database using the stored procedures". Once we retrieve the data from the database using the stored procedure we need to populate the fetched data into the textboxes of the application. Please let me know "How do I acheive this". And please note this, if I try to fetch the record which does not exists in the database it should throw an exception saying that the record which you are trying to search does not exist Thanks and Regards Sandeep.
For Calling Stored Proc U can re...Oracle Stored Procedure data window
I am trying to create datawindow from a stored procedure. I created a simple
SP that return a value.
I selected the Stored procedure option in datawindow creation and it showed
the procedure i created.After selcting the procedure I got a blank
datawindow painter. Menus except File,window are disabled.
Can anybody exlpain the basic procedure to create a stored procedure
datawindow with Oracle.
I am using PB6.5 and Ora 7.1
For Oracle 7.1 you need to use the pbdbms package. That version of Oracle
had no way of returning result sets.
The package is cr...Data window's Data source is Oracle Procedure
Hello I created one Packed in that i created one PROCEDURE
now i want to use that oracle procedure in data window as a
data source. but when i created a new datawindow (PB9)in
select store procedure dialog box i cant see that procedure
or package in a list what i have to please tell me .
First, the procedure has to return a ref cursor to be used as a datasource
with a datawindow (natively).
Second, your userid must have execute permission on the package/procedure.
Third, you need to configure you PB database connection on the SYSTEM tab,
there's a checkbox t...Oracle stored procedure as source of data in datawindow
I read some articles about this functionality here and I have one question.
A PL/SQL code is like this:
-- type definition
CREATE OR REPLACE PACKAGE fsp IS
TYPE rctl IS REF CURSOR;
-- stored procedure as source of data
create or replace procedure fsc(arg1 in number, rc1 in out fsp.rctl) as
OPEN rc1 FOR SELECT ..... FROM ... WHERE .. = arg1;
It works fine with multiple rows selection and dynamic declaration of cursor
who close this cursor after retrieve in datawindow (calling fsc procedure)?
Does PowerBuilder do it?
Yes, PB clo...Using Oracle Stored Procedures as a data source
I am working with PowerBuilder 6.5 and Oracle 7.3. I created a stored
procedure as suggested in the 'Connecting to your Database' manual.
The stored procedure executes using Oracle Plus. When I select it as
a source for a DataWindow I'm getting an Oracle error, ORA-06550. It
says that "'Proc1' must be declared". Proc1 is the name of the stored
I would appreciate any suggestions.
Try one of these:
1. Reset PBDBMS from the database profile setting. [PBDBMS =
-> DBParm] or
2. REMOVE the instance name from in front o...Oracle stored procedures as a datawindow data source
I've created an Oracle stored procedure that I would like to use as the
data source for my datawindow. When you create a new datawindow, you get
an option to select the data source and presentation style. I selected
stored procedure and grid and selected OK. Then a Select Stored
Procedure box came up.
How do I get my stored procedure to get listed in this box?
I don't know Oracle but I do know SQL Server/SQL Anywhere. Perhaps your
stored procedure needs to be created by a user that puts it into the public
domain? Maybe you are not logged into...data, data, data
Hello, I need some advice on the best method to keep a database updated in this scenario. I have a local Solomon SQL Server where we keep our inventory. I want to build an application that will be hosted at a remote hosting location which provides a SQL database. I want to build the application to allow clients to access the inventory items and make requests based on the remote SQL data. The order will be sent to our fulfillment department via email; they will fiill the request and ship. I'm not sure the method to do this while keeping the data current on the remote and the l...Can anyone tell me how to access data from Stored Procedures using data adapters?
Can anyone tell me how to access data from Stored Procedures using data adapters? My task is to select a row which is valid with data particular value. Suppose i had to get all values of particular user after validating username and password. Can anyone give me some hint regarding store procedure and retriving data from stored procedure using data adapters ? How can i bind data to dropdownbox of one field in the table using datasets and data adapters? How can i insert data in database using data adapters?Can any one solve this?
for your question, dataadapter's fill and...How do I resolve this problem of using a stored procedure with Data Window.
I have written a stored procedure in Sybase, which conssists of multiple
statements (including 'Select into') and at the end it has a final 'Select'
statement which gives out the output.
When I use this SP in a datawindow and try to retrieve the data using -
It gives following error message -
Select Error : Select INTO command not allowed within multi-statement
However there are other SPs written in similar manner running smoothly.
Please suggest how do I resolve...how to get data from all related tables using stored procedure
I have a situation where I want to load some entities from one table lets say the table is customers and i would like to load all the customers with first name = dummy, not only this i would like to load all the orders and order details for these specific customers (these are two different separate tables) . I want all this within one stored procedure that return me three results for three different tables. Please tell me whether it is possible and how.
You can simply have multiple SELECT's in a stored procedure. Then using a DataSet, the Tables collection will have the same num...Oracle Stored Procedures as DataWindows' data sources
We have been working with PowerBuilder and MS SQL Server 6.0 and now, we
need to work with Oracle 7. Some of the reports the application presents
were built using datawindows with Stored Procedures as their data source.
Trying to convert those procedures to Oracle, we've found that in Oracle
Stored Procedures we need to specify an INTO in a SELECT statement, which
is not properly for us because our SELECT retrieves many rows. Do you have
any ideas for solving this problem, keeping the stored procedures as the
datawindows' data sources? Any help is welcome.