Using stored procedure to get the data for data window (Oracle)

Hi,
    I am trying to use the stored procedure in Oracle 7.3 to get the
data for the data window. I was able to do it successfully using the
stored procedure if it is not in the package by defining the the output
parameter for the stored procedure which is cursor. But I would like to
do the following if possible.

1. When I set the data source to stored procedure I get the list of
stored procedure which DOES NOT contain the stored procedures in
package. How to get the package stored procedures in the list. Any ideas
(Using synonymns,.....)

2.The work around I am using to solve the above problem is:
    * If the datawindow is NOT CROSSTAB.
         1. Compile the package stored procedure as stand alone
         2. Use stand alone stored procedure as  the data source
         3. go to the sqlsyntax and prepand the package name to the
stored procedure
         4. Delete the stand alone stored procedure.

    *BUT if the data window is the crosstab I cannot do the step 3, as
when I go to the sqlsyntax  it gives me the crosstab definition screen.
HOW do I get to the procedure name to modify it.
    Another problem is if I can not look at the stored procedure name
How do I debug the data window if there are problems. (I know I can
export the data window and look at the text file to get the procedure
name and prepand the package name to it, I am looking for a decent way
to do it)

Any pointer will be appreciate. I have already read the document no.
44553 and 44450 at sybase web site which helped a lot but I still have
above problems.

ASIF
====

0
Asif
7/3/1998 10:23:48 PM
sybase.powerbuilder.database 9855 articles. 2 followers. Follow

3 Replies
819 Views

Similar Articles

[PageSpeed] 40

Oracle doesn't have a system table that will show the procedures within a
package.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
Asif H. rajwani wrote in message <359D59F4.9DA12D2B@mci2000.com>...
>Hi,
>    I am trying to use the stored procedure in Oracle 7.3 to get the
>data for the data window. I was able to do it successfully using the
>stored procedure if it is not in the package by defining the the output
>parameter for the stored procedure which is cursor. But I would like to
>do the following if possible.
>
>1. When I set the data source to stored procedure I get the list of
>stored procedure which DOES NOT contain the stored procedures in
>package. How to get the package stored procedures in the list. Any ideas
>(Using synonymns,.....)
>
>2.The work around I am using to solve the above problem is:
>    * If the datawindow is NOT CROSSTAB.
>         1. Compile the package stored procedure as stand alone
>         2. Use stand alone stored procedure as  the data source
>         3. go to the sqlsyntax and prepand the package name to the
>stored procedure
>         4. Delete the stand alone stored procedure.
>
>    *BUT if the data window is the crosstab I cannot do the step 3, as
>when I go to the sqlsyntax  it gives me the crosstab definition screen.
>HOW do I get to the procedure name to modify it.
>    Another problem is if I can not look at the stored procedure name
>How do I debug the data window if there are problems. (I know I can
>export the data window and look at the text file to get the procedure
>name and prepand the package name to it, I am looking for a decent way
>to do it)
>
>Any pointer will be appreciate. I have already read the document no.
>44553 and 44450 at sybase web site which helped a lot but I still have
>above problems.
>
>ASIF
>====
>


0
Terry
7/6/1998 6:41:16 PM
This is not exactly true.  Check out the sys.all_arguments table.  This
table holds the procedures and functions as well as arguments that are in a
package.

Terry Dykstra [TeamPS] wrote in message ...
>Oracle doesn't have a system table that will show the procedures within a
>package.
>
>--
>Terry Dykstra [TeamPS]
>Canadian Forest Oil Ltd.
>Asif H. rajwani wrote in message <359D59F4.9DA12D2B@mci2000.com>...
>>Hi,
>>    I am trying to use the stored procedure in Oracle 7.3 to get the
>>data for the data window. I was able to do it successfully using the
>>stored procedure if it is not in the package by defining the the output
>>parameter for the stored procedure which is cursor. But I would like to
>>do the following if possible.
>>
>>1. When I set the data source to stored procedure I get the list of
>>stored procedure which DOES NOT contain the stored procedures in
>>package. How to get the package stored procedures in the list. Any ideas
>>(Using synonymns,.....)
>>
>>2.The work around I am using to solve the above problem is:
>>    * If the datawindow is NOT CROSSTAB.
>>         1. Compile the package stored procedure as stand alone
>>         2. Use stand alone stored procedure as  the data source
>>         3. go to the sqlsyntax and prepand the package name to the
>>stored procedure
>>         4. Delete the stand alone stored procedure.
>>
>>    *BUT if the data window is the crosstab I cannot do the step 3, as
>>when I go to the sqlsyntax  it gives me the crosstab definition screen.
>>HOW do I get to the procedure name to modify it.
>>    Another problem is if I can not look at the stored procedure name
>>How do I debug the data window if there are problems. (I know I can
>>export the data window and look at the text file to get the procedure
>>name and prepand the package name to it, I am looking for a decent way
>>to do it)
>>
>>Any pointer will be appreciate. I have already read the document no.
>>44553 and 44450 at sybase web site which helped a lot but I still have
>>above problems.
>>
>>ASIF
>>====
>>
>
>


0
Roy
7/8/1998 3:10:20 AM
I never knew about that table.  It is not even described in the Oracle7.3
Server reference guide, although it's been around for some time, since I
found it in a 7.2 database as well.  Thanks.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
Roy Letlow wrote in message ...
>This is not exactly true.  Check out the sys.all_arguments table.  This
>table holds the procedures and functions as well as arguments that are in a
>package.
>
>Terry Dykstra [TeamPS] wrote in message ...
>>Oracle doesn't have a system table that will show the procedures within a
>>package.
>>
>>--
>>Terry Dykstra [TeamPS]
>>Canadian Forest Oil Ltd.
>>Asif H. rajwani wrote in message <359D59F4.9DA12D2B@mci2000.com>...
>>>Hi,
>>>    I am trying to use the stored procedure in Oracle 7.3 to get the
>>>data for the data window. I was able to do it successfully using the
>>>stored procedure if it is not in the package by defining the the output
>>>parameter for the stored procedure which is cursor. But I would like to
>>>do the following if possible.
>>>
>>>1. When I set the data source to stored procedure I get the list of
>>>stored procedure which DOES NOT contain the stored procedures in
>>>package. How to get the package stored procedures in the list. Any ideas
>>>(Using synonymns,.....)
>>>
>>>2.The work around I am using to solve the above problem is:
>>>    * If the datawindow is NOT CROSSTAB.
>>>         1. Compile the package stored procedure as stand alone
>>>         2. Use stand alone stored procedure as  the data source
>>>         3. go to the sqlsyntax and prepand the package name to the
>>>stored procedure
>>>         4. Delete the stand alone stored procedure.
>>>
>>>    *BUT if the data window is the crosstab I cannot do the step 3, as
>>>when I go to the sqlsyntax  it gives me the crosstab definition screen.
>>>HOW do I get to the procedure name to modify it.
>>>    Another problem is if I can not look at the stored procedure name
>>>How do I debug the data window if there are problems. (I know I can
>>>export the data window and look at the text file to get the procedure
>>>name and prepand the package name to it, I am looking for a decent way
>>>to do it)
>>>
>>>Any pointer will be appreciate. I have already read the document no.
>>>44553 and 44450 at sybase web site which helped a lot but I still have
>>>above problems.
>>>
>>>ASIF
>>>====
>>>
>>
>>
>
>


0
Terry
7/8/1998 7:09:04 PM
Reply:

Similar Artilces:

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
Rich, 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. HTH Sanjiv. "Rich" <windows_ce@netease.com> wrote in message news:2Xsr1WW0AHA.178@forums.sybase.com... > > > ...

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. Hi,sunny For Calling Stored Proc U can re...

Oracle Stored Procedure data window
Hello, 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 Thanks Bal 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 . regards s Patel 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...

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 procedure. I would appreciate any suggestions. George Farrance Try one of these: 1. Reset PBDBMS from the database profile setting. [PBDBMS = -> DBParm] or 2. REMOVE the instance name from in front o...

Inserting data into database using store procedure
Here is my code and it's not working.protected void btnInsert_Click(object sender, EventArgs e) { SqlConnection sqlConn = new SqlConnection(); sqlConn.ConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString; SqlCommand sqlComm = new SqlCommand(); sqlComm.Connection = sqlConn; sqlComm.CommandType = CommandType.StoredProcedure; try { //sqlConn.Open(); sqlComm.Connection.Open(); } catch (Exception x) { Cons...

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 update methods will sove the situation. Please look in google or in MSDN for these methods information. also visit these links. http://authors.aspalliance.com/aspxtreme/sys/data/common/DataAdapterClassFill.aspx http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.dropdownlist.aspx  Give a man a fish and you feed him for a day. Teach a man to fish and you feed him forever....

Using stored procedures to insert and pull data from database
I have my database: "RequestTrack" My table (with its columns): "Request"RequestKey (automatically generated)..and the Primary KeyEntryDate  (datetime)Summary (nvarchar)RequestStatusCodeKey (bigint)EntryUserID   (nvarchar)EntryUserEmail (nvarchar)I am wanting to create a basic web form where my user interface has 3 text boxes and a Submit button: txtUserID.TexttxtEmailAddress.TexttxtRequestSummary.Text **After I hit the submit button the information will then be inserted into the database. Also the RequestStatusCodeKey will be MANUALLY typed in so ...

How do I resolve this problem of using a stored procedure with Data Window.
Hi, 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 - dw_sheet.SEtTransobject (sqlca) dw.sheet.Retrieve() It gives following error message - DataWindow Error Select Error : Select INTO command not allowed within multi-statement transaction. 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...

Using a data set to hold data read from the database. And how to write it back out, getting it out of the listbox
I havent worked with data sets lately so I am hoping from some help from someone.i am working on a web application using asp.net 2.0 and c#. Basically I need to read html text from a column in a database table(600 chars max)I then need to copy this text into a multi line listbox and allow it to be editedOnce the application user has edited the text, then they will press a save buttonand the text will be written back to the database. I don't know if this is the best choice, but I want to use a data set to read the text into.The data set will act as the holder of the text. The problem i...

store frequently used data in session or get from database each time
i need to know user security like canRead,canWrite,canDelete,canPreview,canViewReport1,canViewReport2 ,.......canViewRport20 etc .......and then load the page. what would be the best option store all these information after successful login in Session Or query them from database as you need them Store in session.  Will be faster than going to DB each time. ^.^ session is definetly faster.but won't the performance of the application suffer if there are around 200 concurrent users.  ageorge: session is definetly faster.but won't the performance of the a...

inserting xml data in sql database using store procedure
 i want to write gridview data in Xml file and pass that xml file as input parameter tostore procedures and insert xml file data to sql database table.i dont how to write xml file and how to pass it to store procedurepl help me asap its urgent    "To handle XML from an xml data type column by using ADO.NET and the Microsoft .NET Framework you can use the standard behavior of the SqlCommand class. For example, an xml data type column and its values can be retrieved in the same way any SQL column is retrieved by using a SqlDataReader.However, if you want to work with the...

Oracle Data in Drop Down Data Windows
When I make a Drop Down data window using SQL server it works fine and give me the data. However, when I connect to Oracle directly it does not populate the drop down data window. When I look at the source data window for the DDDW, it works fine and I see all the data thats in the database. Any sugesstions? Assuming you created the dddw while connected to SQL Server and are now trying to use it in an Oracle database, is the dw for the dddw saved in Graphic Mode? Also, if you do an explicit retrieval of the dddw what happens? Ex. DataWindowChild dwc_orders dw_news.GetChi...

Is it possible to use stored procedure for Insert in data window ofr PB 7
We have a requirement to use insert into a particular table using a stored procedure while we don't need stored procedure for update. Delete has been disabled to all but dba via truncate table. I have coded and tested a ASA 6 function and procedure for the purpose of inserting a row into the table using pure watcom syntax. ( the function contains special logic to generate key value for the stored procedure) I can insert rows with the procedure in ISQL only by call p_insert_x (................, v_trans_id, v_timestamp) but not execute p_insert_x ( ................, v_trans_...

How to use Oracle 7.3 stored procedures as datawindows' data sources?
Hello! 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 datawindows? We created a package and the stored proc...

How can I get data using as source a Store Procedure sending it a sql sentence?
I'm using Power Builder 8 and Oracle 8i, what I want, It is to use a datawindow with a store procedure as data source but as a parameter, I want to send it a sql sentence like a string "select * from table". The store procedure should execute it and then the data has to be showed in this datawindow. It's easy to do this if the store procedure only has to get data from a static sql using: open cursor for select * from table where data1 = parameter1 but if I want to execute something like that: open cursor for parameter_sql; -- This a String ("select ...

Problem use sqldatasource to access stored procedure and get data bind to label control
Hi every experts I have a exist Stored Procedure in SQL 2005 Server, the stored procedure contain few output parameter, I have no problem to get result from output parameter to display using label control by using SqlCommand in Visual Studio 2003. Now new in Visual Studio 2005, I can't use sqlcommand wizard anymore, therefore I try to use the new sqldatasource control. When I Configure Datasource in Sqldatasource wizard, I assign select field using exist stored procedure, the wizard control return all parameter in the list with auto assign the direction type(input/ouput....), after that...

How to speed up the data assignment from one data window to another data window ?
I have a report program that need to show three different periods of sales data for my users. I used a datastore ( called 'dw_source' ) to hold these information and then used three 'for loops' to assign individual sales data to related period columns into the final data window ( called 'dw_target' ) that will be displayed for the users. The number of columns on the report group are user selected and the program will do all grouping and subtotal when the group data changed ( is a dynamic created data window ). The time needed to do the the assingment from &...

passing data from controls to session then taking the data and writing custom sql queries to get data from the database
Hi, I'm making a property search. I want to get data from controls and store in a session object which saved in the session until remove or close the browser so on the next page I can take the data stored in the session and use it to write a custom sql query using vb.net or stored procedure to get data from the database and then display the date in the list of results page. Can anyone help with this or forward me to some tutorials that could help me. ThanksAndy Current project: Cycle round the world Heytry thissession["name"]=TextBoxName.Text; And in ...

how to retrive the XML data by using LINQ and how to store that data in GridView(by using LINQ) Dynamically
Friend's i have 'n' number of tabels.if i select particular table that table data should bind to GridView using XML and LINQ dynamically with their column names. Friend's what i have i done i will give that code :           XmlDataDocument MyDoc = new XmlDataDocument(Ds);                   MyDoc.Save(Server.MapPath("App_Data\\DsFile.xml"));          XElement MyDoc1 = XElement.Load(Server.MapPath(...

Sorting in gridView: Can I use LINQ to call a stored procedure and still get sorting like I can with an SQL Data source to a sproc?
I have a gridView, it is populated by the results of a stored procedure. I would like to be able to sort on the columns returned. If I use an SQL Data Source control and point it to the stored procedure it will allow me to sort the columns in the gridView by enabling sorting.   However, I can not select a stored procedure using a LINQ data source.  I can call a stored procedure with LINQ and assign it to the gridView's datasource, but this won't let me enable sorting. Is there a way to call a stored procedure using a LINQ data source, so that I can enable sorting in th...

Web resources about - Using stored procedure to get the data for data window (Oracle) - sybase.powerbuilder.database

Parliamentary procedure - Wikipedia, the free encyclopedia
... of the House of Commons of the Parliament of the United Kingdom , from which it derives its name. In the United States, parliamentary procedure ...

Rushed cosmetic procedures a 'recipe for disaster'
&#8203;When Chanelle O'Hare went searching online for a deal on potential cosmetic procedures, she could not have imagined that what she ended ...

Jetstar procedures under investigation after planes took off too heavy
Jetstar's procedures for calculating the weight of its aircraft are under review by the Australian Transport Safety Bureau after two of its planes ...

Doctors Perform Medical Procedure On Wrong Newborn
The procedure was meant for another child.

Old Lady Lawyer: Uncivil Procedure
What is some of the worst behavior you've witnesses by attorneys?

NFL Announces Changes to Officiating Procedures for Playoffs - Bleacher Report
The NFL formally approved changes to its postseason officiating procedures to allow referees the opportunity to consult Vice President of Officiating ...

We need to reform the culture of law enforcement, not just the procedures
We need to reform the culture of law enforcement, not just the procedures by digby I have a new piece up at Salon this morning about police ...

Rescued tiger cub "Himmel" dies during medical procedure - CBS News 8 - San Diego, CA News Station ...
Alpine animal rescue sanctuary Lions, Tigers & Bears is sadly reporting Himmel, the tiger cub found roaming the streets of Hemet and rescued ...

Catholic hospital allowed to deny sterilization procedure, judge says
Hospital in California argued that the procedure known as ‚Äčtubal ligation would violate its religious freedom

TSA Updates Screening Procedure, Will Mandate Some Passengers Use Full-Body Scanners
... Imaging Technologies, or AIT, in favor of full-body pat-downs by TSA agents. Under the new mandate, not everyone can opt for the pat-down procedure. ...

Resources last updated: 2/19/2016 4:12:38 AM