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

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

i want to fill a ado.net dataset

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

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

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

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