Problem with TNSNAME

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
regisvicente
Posts: 5
Joined: Fri 04 May 2018 17:13

Problem with TNSNAME

Post by regisvicente » Mon 04 Jun 2018 20:54

I'm using the dbExpress driver for Oracle (6.7.10) and I have a problem when my tnsname has a dot.

I have two tnsname:

TNSNAME = 'COMPANY'

and

TNSNAME = 'COMPANY.SJC.BR'


When my TNSNAME has a dot and I execute the procedure, I get this error:

"Could not parse the GetPackageProcedureParameters metadata command. Problem found near: .. Original query: GetPackageProcedureParameters TNS_NAME. OWNER_NAME. PACKAGE_NAME . PROCECURE_NAME"

MaximG
Devart Team
Posts: 1098
Joined: Mon 06 Jul 2015 11:34

Re: Problem with TNSNAME

Post by MaximG » Thu 07 Jun 2018 14:50

We have started to investigate the issue according to your description. Please, compose and send us a DDL script of the simplest Oracle package, execution of whose procedure causes the described issue. In addition, please, provide a code snippet that demonstrates how to work with this procedure. It is convenient to do this using the e-support form (https://www.devart.com/company/contactform.html)

MaximG
Devart Team
Posts: 1098
Joined: Mon 06 Jul 2015 11:34

Re: Problem with TNSNAME

Post by MaximG » Thu 07 Jun 2018 14:58

In addition, try using the connection parameter 'UseQuoteChar' :

Code: Select all

SQLConnection.Params.Values['UseQuoteChar'] := 'True';

Post Reply