ora2pg icon indicating copy to clipboard operation
ora2pg copied to clipboard
verified publisher icon darold

ORA-01008: not all variables bound (DBD ERROR: OCIStmtExecute)

Open rksengee opened this issue 3 years ago • 3 comments

I'm getting below while trying to take schema backup from oracle 10.2 database.

[2022-02-21 00:51:21] Ora2Pg version: 20.0 [2022-02-21 00:51:21] Trying to connect to database: dbi:Oracle:D....C [2022-02-21 00:51:21] Isolation level: SET TRANSACTION ISOLATION LEVEL READ COMMITTED [2022-02-21 00:51:21] Retrieving table information... [2022-02-21 00:51:21] FATAL: ORA-01008: not all variables bound (DBD ERROR: OCIStmtExecute)

rksengee avatar Mar 29 '22 12:03 rksengee

Please use latest development code, old versions are not maintained you need to upgrade. Use git clone or wget https://github.com/darold/ora2pg/archive/refs/heads/master.zip to download latest code.

darold avatar Mar 30 '22 06:03 darold

i had the same problem with 10g I was able to solve this problem by changing the value of cursor_sharing in oracle database instance. if the value is similar change it to exact

aymanadou avatar Apr 05 '22 08:04 aymanadou

Thanks @aymanadou , It is working fine now after changing to exact. Thanks a lot!

rksengee avatar Apr 08 '22 11:04 rksengee