I have this stored procedure:
procedure mulnum (
numuno in number,
numdos in number,
resultado out number) as
begin
resultado := numuno * numdos;
end;

I already tested it with D2K and it works (But I dont like D2K).

Here is my code in Delphi:
procedure TForm1.Button1Click(Sender: TObject);
begin
with OraclePackage1 do
begin
OraclePackage1.CallProcedure('MULNUM',[15,5,parInteger]);
Label1.Caption:='15 Times 5 is'+IntToStr(GetParameter(2));
end;
end;

I receive the error "ORA-06550 line 2 column 10" and then the "PLS-00225 Subprogram or cursos MULNUM reference is out of scope" and then the "ORA-06550: line 2 , column 3 :PL/SQL Statment ignored"

So stupid question?? yes/no? either way and dont know whats going on.

Hello,

I've tried your code and it works just fine.
Is the procedure in the database valid?
What are the settings for the OraclePackage component and for the Session component.

[Linked Image]
Greetings Johan



------------------
JohaViss

What do you mean with valid?. I think it is ok because I can call it from D2K.

Here are the OraclePackage properties:
Cursor => crDefault
Debug => False
Name => OraclePackage1
Optimize => True
PackageName => MULNUM
ParameterMode => pmPositional
Session => OracleSession1
Tag => 0

In the OracleSession component I only changed:

Connected => True
LogonDatabase => molddie (it is in the tnsnames file)
LogonPassword => the system manager password.
LogonUserName => the system manager user.

All other setting are the default.

While I write this. I changed the OraclePackage1.PackageName to SYS.STANDARD, where the MULNUM procedure is. But now I get the error "PLS-00302 component MULNUM must be declared"