Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 11th, 2004, 04:43 AM
Friend of Wrox
 
Join Date: Sep 2004
Location: , , India.
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

  #2 (permalink)  
Old October 12th, 2004, 12:54 AM
Authorized User
 
Join Date: Apr 2004
Location: Boise, ID, USA.
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
  #3 (permalink)  
Old October 13th, 2004, 05:14 AM
Friend of Wrox
 
Join Date: Sep 2004
Location: , , India.
Posts: 140
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i want to fill a ado.net dataset

  #4 (permalink)  
Old October 13th, 2004, 09:31 AM
Authorized User
 
Join Date: Apr 2004
Location: Boise, ID, USA.
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
  #5 (permalink)  
Old October 14th, 2004, 07:53 AM
Friend of Wrox
 
Join Date: Sep 2004
Location: , , India.
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..

  #6 (permalink)  
Old October 14th, 2004, 11:04 AM
Authorized User
 
Join Date: Apr 2004
Location: Boise, ID, USA.
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
  #7 (permalink)  
Old October 20th, 2004, 03:50 AM
Registered User
 
Join Date: Oct 2004
Location: Nasr City, Cairo, Egypt.
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)


 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 01:45 AM.


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