-
Notifications
You must be signed in to change notification settings - Fork 78
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[question] Where the code indicates that select statement use a db cursor #239
Comments
It depends on DBMS (Oracle, MySQL, etc.) and the programming language. |
Thanks for your reply. So you mean From docs.oracle sql_cursor, I saw
But I am still confused. Implicit cursors how to return the database cursor from the DBMS to the ruby code? Does the implicit cursors will automatically open, fetch and close? |
Correct.
Implicit cursors and explicit cursors are concept specific to the PL/SQL language.
Ruby-oci8 uses Oracle Call Interface (OCI).
|
Thanks! |
What I wrote in #239 (comment) is not documented in the OCI manual. I checked it by network capture. I have made a prototype of Oracle network protocol decoder more than a decade ago. |
So that is it. I closed the issue. Because the issue is related to Oracle, not Thanks for your patience again. |
https://docs.oracle.com/cd/E11882_01/server.112/e40540/sqllangu.htm#CNCPT1741
|
Hello, kubo
I have a question that confused me a lot. Could you give a favor? Thanks a lot!
Q: Where the code indicates that
select statement
use a dbcursor
?Does the
select statement
need to explicitly declare cursor?Something like that
lib\oci8\cursor.rb
I don't see
DECLARE CURSOR
, but it actually use a cursor.So I tried to find where the code declare cursor step to step.
Then, I found that
ext\oci8\stmt.c
C code is a big challenge for me and I failed to find the code that explicit cursor for a select statement.
The text was updated successfully, but these errors were encountered: