| Subject: | Oracle: No stored procedure parameters during design. |
| Posted by: | Kyle Miller |
| Date: | Mon, 22 Sep 2008 |
I have a simple test stored procedure. I setup a TAdoStoredProcedure and a TAdoDataSet to call the procedure. I set the name (The name is present in the drop down.), but no parameters show up after setting the name procedure's name. What is missing here? Here is the procedure's code.
create or replace PROCEDURE ns_foo(
aInt1 in INTEGER,
aInt2 in INTEGER,
aResult out INTEGER)
IS
BEGIN
aResult := aInt1 + aInt2;
END ns_foo;
My database is a local database with Oracle 10g Express.