SQLConnection.Execute

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
ssa
Posts: 1
Joined: Thu 11 Dec 2008 09:01

SQLConnection.Execute

Post by ssa » Thu 11 Dec 2008 09:32

I have a StoredProcedure in a Oracle DataBase and I would like to call it from a Execute or executeDirect method of SqlConnection component.

Is that possible?

Example:

SQLConnection.Execute('EXECUTE INSCLIENTE_CLI('2418','Test','Test',null,'O',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'A')');

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Fri 12 Dec 2008 08:27

You should use PL/SQL block to execute a procedure. For example:

SQLConnection.Execute('BEGIN MyProc(1, 2); END;');

Post Reply