| |

VerySource

 Forgot password?
 Register
Search
View: 585|Reply: 1

The Oracle database is connected with oledb, and stored procedures or packages are called in C #, how can I return a dat

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-1-30 07:20:01
| Show all posts |Read mode
The Oracle database is connected with oledb, and stored procedures or packages are called in C #, how can I return a dataset.
   Generally, the oracle database is connected with oracleClient. You can use the cursor in the package to return the dataset.
   When connecting with oledb, there is no corresponding cursor data type (DbType), and I don't know how to return the dataset.
   And when sqlClient connects to Sqlserver, how to operate it.

Thank you for your guidance.
Reply

Use magic Report

0

Threads

15

Posts

10.00

Credits

Newbie

Rank: 1

Credits
10.00

 China

Post time: 2020-3-24 04:00:01
| Show all posts
You can use OleDBCommand.ExecuteReader () to handle return cursors
Dr.NextReult can traverse multiple return cursors

I can't use DataSet: (
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list