Wrox Programmer Forums
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 11th, 2004, 04:43 AM
Friend of Wrox
 
Join Date: Sep 2004
Posts: 140
Thanks: 0
Thanked 0 Times in 0 Posts
Default procedure

how can i get all the rows of a table from a procedure .i cannot use cursor.very urgent

 
Old October 12th, 2004, 12:54 AM
Authorized User
 
Join Date: Apr 2004
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Can you clarify what you are asking?

Are you trying to process the data from a table in a procedure? Are you trying to return rows of data to another procedure or a client application? Why can't you use a cursor for this?

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
 
Old October 13th, 2004, 05:14 AM
Friend of Wrox
 
Join Date: Sep 2004
Posts: 140
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i want to fill a ado.net dataset

 
Old October 13th, 2004, 09:31 AM
Authorized User
 
Join Date: Apr 2004
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you want an ADO.Net dataset, you would generally want to hsvr a REF CURSOR OUT parameter that opens and returns a cursor to the client application. That brings me back to my question about why you can't use a cursor...

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
 
Old October 14th, 2004, 07:53 AM
Friend of Wrox
 
Join Date: Sep 2004
Posts: 140
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i have sql server and oracle boath i want my codeto work on boath..

 
Old October 14th, 2004, 11:04 AM
Authorized User
 
Join Date: Apr 2004
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You are likely to have a problem, then... Oracle PL/SQL and SQL Server T SQL are rather different languages, and there are particular differences in how stored procedures are created to return data to a client application. Unless you want to move the SQL statement(s) into the application, you aren't going to be able to use the same code for both databases. You can use very similar code, but not identical.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
 
Old October 20th, 2004, 03:50 AM
Registered User
 
Join Date: Oct 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to mg2010 Send a message via Yahoo to mg2010
Default

I have the Oracle 8i then, when i try to import/export the line promt
declares the user name like '?DPAP{D (rabish)







Similar Threads
Thread Thread Starter Forum Replies Last Post
Procedure nick1005 MySQL 2 October 18th, 2007 08:41 AM
Function and Procedure code_lover Oracle 2 July 24th, 2007 07:05 AM
Stored Procedure Help BukovanJ SQL Language 2 October 10th, 2006 08:02 AM
Forms Procedure do what? saboorpan Oracle 0 July 12th, 2006 05:56 AM
Procedure ! minhtri Pro VB Databases 2 June 25th, 2004 05:01 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.