Search found 4 matches

Go to advanced search

by davidsdudley
Mon 25 Jul 2005 14:21
Forum: dbExpress driver for Oracle
Topic: TSQLStoredProcedure parameters
Replies: 10
Views: 8349

Oracle NET

Paul wrote:We cannot reproduce your problem with Delphi 2005 Service Pach 3, DbxOda 2.50.4
"Oracle Net (Core Lab)" can work without installing Oracle client please see Readme.html how to configure "DataBase" parameter.

You must enter ::, where take from SERVICE_NAME parameter in tnsnames.ora. For example DataBase='server:1521:orcl920'

Code: Select all

ORA920 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl920)
      (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES=100)
(DELAY=1))
    )
  )
OK.

Is there any advantage/disadvantage of using Oracle Net vs Oracle within the Corelab version?
by davidsdudley
Thu 21 Jul 2005 15:45
Forum: dbExpress driver for Oracle
Topic: TSQLStoredProcedure parameters
Replies: 10
Views: 8349

Oracle Packages

Paul wrote:What is the version of Delphi do you use? Does it have Service pack?
Please check that TSQLStoredProc.SQLConnection propery is assigned and TSQLConnection is configyred in design-time.
Regarding to your first question, please check that your procedure and package are valid on Oracle server with other tools or components (Borland Oracle driver, for example)

Send us please small demo project to demonstrate the problem to DbxOda support address and include script to create server objects.
Paul:
I'm using Delphi 2005 Service Pack 3
I have tried the OracleConnection type and it works fine; it pulls up list of packages and then I can pull up stored procs from within it.

However the Core Lab version does not.

By the way, what's the difference between "Oracle (Core Lab)" and
"Oracle Net (Core Lab)" ? When I try the Net type I get an "Invalid SID" when I try to connect.
by davidsdudley
Thu 21 Jul 2005 14:07
Forum: dbExpress driver for Oracle
Topic: TSQLStoredProcedure parameters
Replies: 10
Views: 8349

Anyone?

Does anyone have a suggestion as to what's wrong?
by davidsdudley
Fri 08 Jul 2005 14:56
Forum: dbExpress driver for Oracle
Topic: TSQLStoredProcedure parameters
Replies: 10
Views: 8349

Re: Oracle package being called from TSQLStoredProc Object.

davidsdudley wrote:I see the packagename property on this component.

However it does not have a drop down on it like the storedprocname property does.
- Actually I misspoke... The PackageName DOES have a drop down like the storedprocname... It's just not showing the package. I can see it thru TOAD

Go to advanced search