SQLConnection.Execute

SQLConnection.Execute

Postby 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')');
ssa
 
Posts: 1
Joined: Thu 11 Dec 2008 09:01

Postby 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;');
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for Oracle