mORMot Open Source

ericgarcia

Member

Registered: 2015-06-11

Posts: 9

oracle - OCI-21560

hello,

i am trying to connect to oracle direct driver OCI, and get the following message:
projet synDBEXplorer raise exception in the class TSQLDBOracleLib error OCI-21560
argument null, non valide ou Hors limite.
I am using instantclient 12.1 connect to Oracle server 11g
thanks for your help

eric g.

Last edited by ericgarcia (2015-07-08 00:07:26)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: oracle - OCI-21560

Executing which OCI API call?
With which parameters?

ericgarcia

Member

Registered: 2015-06-11

Posts: 9

Re: oracle - OCI-21560

I am really sorry, but i did a mistake in the settings.
I used :TSQLDBOracleConnectionProperties.Create(//ip-address:port,'SID','USER','PWD');  and get the issue.
but when using
TSQLDBOracleConnectionProperties.Create('TNSDEF','SID','USER','PWD'); it works well.

thanks

eric

ericgarcia

Member

Registered: 2015-06-11

Posts: 9

Re: oracle - OCI-21560

Nope. finally i get errors when trying to connect.
I'd like to connect directly to my database without any tnsname.
But even the tnsnames is defines i get errors.
for instance my  tnsnames.ora is as below
lsp45=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 54.85.217.118)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = DFCASB)
    )
  )

I am tying the sample 16 (client server). when executing the clientexe, I get the following results:
- server = lsp45
- database= blank or DFCASB

20150712 20384047  ! EXC   ESQLDBOracle {"Message":"TSQLDBOracleLib error: OCI-2
1560: argument 10 Null, non valide ou hors limites"} at 00705931  stack trace AP
I 005C0571 005C05A5 00007FFDC7299AB2 00007FFDC72982D3 00007FFDC729762D 00007FFDC
45A606C 00410526 004105A8 007083EB 006CA6E0 006C9AAA 006CF347 00739E63 006B3A88
006B3B55 00515AE5 005A7FC5 00742632 00007FFDC54A16AD 00007FFDC72AE954

server: my_ip_address
database: DFCASB
20150712 20424412  ! EXC   ESQLDBOracle {"Message":"TSQLDBOracleLib error: ORA-1
2504: TNS : le processus d'Ǹcoute n'a pas obtenu de SERVICE_NAME dans CONNECT_D
ATA"} at 00705931  stack trace API 005C0571 005C05A5 00007FFDC7299AB2 00007FFDC7
2982D3 00007FFDC729762D 00007FFDC45A606C 00410526 004105A8 007083EB 006CA6E0 006
C9AAA 006CF347 00739E63 006B3A88 006B3B55 00515AE5 005A7FC5 00742632 00007FFDC54
A16AD 00007FFDC72AE954

server : my_ip_address:1521/DFCASB
database:NULL
20150712 20445940  ! EXC   ESQLDBOracle {"Message":"TSQLDBOracleLib error: OCI-2
1560: argument 10 Null, non valide ou hors limites"} at 00705931  stack trace AP
I 005C0571 005C05A5 00007FFDC7299AB2 00007FFDC72982D3 00007FFDC729762D 00007FFDC
45A606C 00410526 004105A8 007083EB 006CA6E0 006C9AAA 006CF347 00739E63 006B3A88
006B3B55 00515AE5 005A7FC5 00742632 00007FFDC54A16AD 00007FFDC72AE954

thanks for your help