|
|
 |
| 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 .
|
 |
|
|
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
|
|
procedure
how can i get all the rows of a table from a procedure .i cannot use cursor.very urgent
|
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
|
|
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
|
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
|
|
i want to fill a ado.net dataset
|
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
|
|
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
|
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
|
|
i have sql server and oracle boath i want my codeto work on boath..
|
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
|
|
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
|
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
|
|
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 |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
