Skip to content

[BUG] Push type RAW base oracle (ORA-01465) #53

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

Open
P0labrD opened this issue Jan 31, 2022 · 1 comment
Open

[BUG] Push type RAW base oracle (ORA-01465) #53

P0labrD opened this issue Jan 31, 2022 · 1 comment
Labels
bug Something isn't working

Comments

@P0labrD
Copy link
Collaborator

P0labrD commented Jan 31, 2022

Problème

Lors d'un push LINO, une erreur oracle est survenue: ORA-01465: nombre hexadécimal non valide.

D'après le thread: https://stackoverflow.com/questions/33708959/ora-01465-invalid-hex-number-in-oracle-while-using-blob
il faudrait utiliser une fonction du type utl_raw.cast_to_raw pour convertir la chaîne de caractère en type compatible oracle.

(remarque: même solution proposée pour erreur #51, mais problèmes de tailles de chaîne de caractères en plus dans ce cas , >4000)

Peut-être intégrer la gestion des types dans le dialecte oracle de LINO.

@P0labrD P0labrD added the bug Something isn't working label Jan 31, 2022
@P0labrD
Copy link
Collaborator Author

P0labrD commented Feb 11, 2022

Issue #33 might be a solution.

Import as []bytes and export as binary (or equivalent type).

NB: check if length of inserted data does not cause ORACLE bug.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant