search

oracle / python-oracledb

Python driver for Oracle Database conforming to the Python DB API 2.0 specification. This is the renamed, new major release of cx_Oracle
https://oracle.github.io/python-oracledb
Other
308 stars 61 forks source link

Quering Database and getting Empty values #267

Closed motolanialimi closed 6 months ago

motolanialimi commented 6 months ago
  1. What versions are you using?

  1. Is it an error or a hang or a crash?

  2. Error, Empty values. the results are not returning. even though the connection to database is correct and sql query is also correct

  3. What error(s) or behavior you are seeing?

  1. Does your application call init_oracle_client()?
  1. Include a runnable Python script that shows the problem.
anthony-tuininga commented 6 months ago

Can you supply the additional information requested in the template? Frequently the issue with not seing results is due to the fact that the data was not committed -- but I can't know for sure without more details.

motolanialimi commented 6 months ago

That is the issue, empty results. At first part of the results came in and now nothing is coming in.

On Wed, Dec 13, 2023, 2:20 PM Anthony Tuininga @.***> wrote:

Can you supply the additional information requested in the template? Frequently the issue with not seing results is due to the fact that the data was not committed -- but I can't know for sure without more details.

— Reply to this email directly, view it on GitHub https://github.com/oracle/python-oracledb/issues/267#issuecomment-1854645448, or unsubscribe https://github.com/notifications/unsubscribe-auth/AH4MHSKY3W6E4FU7MJU3GZTYJIEYRAVCNFSM6AAAAABATX3DKKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNJUGY2DKNBUHA . You are receiving this because you authored the thread.Message ID: @.***>

motolanialimi commented 6 months ago

Error: list index out of range Returned: None.

On Wed, Dec 13, 2023 at 2:36 PM Motolani Alimi @.***> wrote:

That is the issue, empty results. At first part of the results came in and now nothing is coming in.

On Wed, Dec 13, 2023, 2:20 PM Anthony Tuininga @.***> wrote:

Can you supply the additional information requested in the template? Frequently the issue with not seing results is due to the fact that the data was not committed -- but I can't know for sure without more details.

— Reply to this email directly, view it on GitHub https://github.com/oracle/python-oracledb/issues/267#issuecomment-1854645448, or unsubscribe https://github.com/notifications/unsubscribe-auth/AH4MHSKY3W6E4FU7MJU3GZTYJIEYRAVCNFSM6AAAAABATX3DKKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNJUGY2DKNBUHA . You are receiving this because you authored the thread.Message ID: @.***>

--

Personal Website https://motolsnaturalhair.com/ Instagram https://www.instagram.com/motols/

1 Peter 4: 10 NLT: "God has given each of you a gift from his great variety of spiritual gifts. Use them well to serve one another"

motolanialimi commented 6 months ago

all I see are the columns and no values.

On Wed, Dec 13, 2023 at 2:49 PM Motolani Alimi @.***> wrote:

Error: list index out of range Returned: None.

On Wed, Dec 13, 2023 at 2:36 PM Motolani Alimi @.***> wrote:

That is the issue, empty results. At first part of the results came in and now nothing is coming in.

On Wed, Dec 13, 2023, 2:20 PM Anthony Tuininga @.***> wrote:

Can you supply the additional information requested in the template? Frequently the issue with not seing results is due to the fact that the data was not committed -- but I can't know for sure without more details.

— Reply to this email directly, view it on GitHub https://github.com/oracle/python-oracledb/issues/267#issuecomment-1854645448, or unsubscribe https://github.com/notifications/unsubscribe-auth/AH4MHSKY3W6E4FU7MJU3GZTYJIEYRAVCNFSM6AAAAABATX3DKKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNJUGY2DKNBUHA . You are receiving this because you authored the thread.Message ID: @.***>

--

Personal Website https://motolsnaturalhair.com/ Instagram https://www.instagram.com/motols/

1 Peter 4: 10 NLT: "God has given each of you a gift from his great variety of spiritual gifts. Use them well to serve one another"

--

Personal Website https://motolsnaturalhair.com/ Instagram https://www.instagram.com/motols/

1 Peter 4: 10 NLT: "God has given each of you a gift from his great variety of spiritual gifts. Use them well to serve one another"

cjbj commented 6 months ago

Please give us the info requested in 6:

  1. Include a runnable Python script that shows the problem.
motolanialimi commented 6 months ago

Never mind the issue is resolved now.

On Wed, Dec 13, 2023, 11:31 PM Christopher Jones @.***> wrote:

Please give us the info requested in 6:

  1. Include a runnable Python script that shows the problem.

— Reply to this email directly, view it on GitHub https://github.com/oracle/python-oracledb/issues/267#issuecomment-1855166320, or unsubscribe https://github.com/notifications/unsubscribe-auth/AH4MHSISX7IA3V7LKD632DLYJKFKFAVCNFSM6AAAAABATX3DKKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNJVGE3DMMZSGA . You are receiving this because you authored the thread.Message ID: @.***>

anthony-tuininga commented 6 months ago

Glad to hear it! I'll close this, then.