Oracle 7.3 Packages using TStoredProc

jonathan.black

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Oracle 7.3 Packages using TStoredProc

hi,

anyone know how to access a packaged procedure using a TStoredProc ??
I'm using Oracle 7.3.x and Delphi 3.0

example...

***********
Server Side
***********

/* PACKAGE INTERFACE */

create or replace package FooPackage as
procedure FooProc(aValue in number);
end FooPackage;

/* PACKAGE IMPLEMENTATION */

create or replace package body FooPackage as

procedure FooProc(aValue in number) is
begin
insert into FooTable values (aValue);
exception
when others then raise;
end FooProc;

end FooPackage;

***********
Client Side
***********

in some event...

with spFooProc do begin
Prepare;
ParamByName('aValue').Value := 100;
ExecProc;
end;

any ideas other than creating a non packaged procedure ??

thanx in advance

JB

Rinaldo da Silv

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Oracle 7.3 Packages using TStoredProc

In StoredProcName property use:
FOOPACKAGE.FOOPROC

jonathan.black escreveu na mensagem <36CF0FBF.83E32...@{*word*269}.net>...
hi,
anyone know how to access a packaged procedure using a TStoredProc ??
I'm using Oracle 7.3.x and Delphi 3.0

example...

***********
Server Side
***********

/* PACKAGE INTERFACE */

create or replace package FooPackage as
procedure FooProc(aValue in number);
end FooPackage;

/* PACKAGE IMPLEMENTATION */

create or replace package body FooPackage as

procedure FooProc(aValue in number) is
begin
insert into FooTable values (aValue);
exception
when others then raise;
end FooProc;

end FooPackage;

***********
Client Side
***********

in some event...

with spFooProc do begin
Prepare;
ParamByName('aValue').Value := 100;
ExecProc;
end;

any ideas other than creating a non packaged procedure ??

thanx in advance

JB

Other Threads

1. TStoredProc.Exec releases locks under Oracle 7.3

2. Oracle 7.3 and TStoredProc...

3. Problems using BDE 5.01 and Oracle 8 drivers reading Oracle 7.3 databases

4. problems with packages access in Oracle 7.3 and D3

5. Oracle 7.3 packages

6. Oracle 7.3 Store Proc in Packages

7. Delphi 3 and Packaged Stored Procs on Oracle 7.3

8. Very bad performance when using the cache (Delphi C/S 3.0 + Oracle 7.3)

9. Using/Creating Oracle 7.3 Stored Procedures

10. Parameterized query with datasource using Delphi 4 C/S Oracle 7.3