Calling an oracle stored procedure with SqlDB or Zeos components

[flamer0n]

Zoran do you mind doing that from LazSqlX and see if it works? I mean write the query to call oracle procedure from lazsqlx and execute it ? Optionally on connection dialog you can choose which components to use (sqldb or zeos) to execute queries and maybe spot the differences.

compile sources yourself from here https://github.com/flakron-shkodra/LazSqlX or install latest windows setup http://sourceforge.net/projects/lazsqlx/ (which I built yesterday using Lazarus 1.4RC2 with fpc 2.6.4  and Zeos7.2 from svn)

of course i understand if you don't have time but I just want to know where is the problem: is it my ignorance or database servers I'm running queries against or laz/fpc or zeos or sqldb?
I still couldn't execute not even one simple parameterless, resultless procedure so I don't know how it's gonna be after it executes
thanks

[Zoran]

Okay, I'll try. I'm just about to finish my working time today and at home I do not have Oracle. Tomorrow I will try.

[flamer0n]

thanks

[Zoran]

I just couldn't connect to oracle server with LazSqlX (with Zeos). In your case, how do you connect with ZConnection?

In past I have experienced a lot of trouble before managed to connect to oracle server. Eventually, I succeeded, but I still don't like and don't really understand the way I do it. If there is a better way, I would really like to know.

In my application:

I leave Server property empty
LibraryLocation = path to oci.dll
Protocol = oracle

What is put in Database property I do not understand well, but my system admins gave me that and they tried to connect and succeded. See (the words in italic are of course replaced with actual addresses or names):

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server_ip)(PORT = port)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = instance_name_on_the_server)))

So, I tried the same in LazSqlX, but it fails to connect. See attached picture.