Oracle Stored Procedure in Delphi with ODac component

barlet
barlet used Ask the Experts™
on
Hello Experts,

I have a Stored Procedure in Oracle and I am using Odac component in Delphi.

I want to call a stored procedure with parameters.. I create a variable no1 and no2
but when I say OraStoredProc1.execute; it is not taking the parameters...

Any Idea?
as a Code I have only OraStoredProc1.execute
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010

Commented:
Can you post the code please ... ?
Commented:
I have found my solution...

I wrote this code and it worked...

OraStoredProc2.Params[0].Value:=DBtext3.Caption;
OraStoredProc2.Params[1].Value:=1;
OraStoredProc2.Execute;

Thanks for your time senad...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial