🚀 go-pugleaf

Hello All,

I have just started to try the latest Borland C++ 6 out for
Oracle Database access to stored procedures.

It is possible to call an Oracle stored procedore from TADOStoredProc,
but I am having some dificulties.
Could someone give me some hints ?

I use an ADOConnection to connect to the Oracle Database, because
I want to call the stored procedure called REPAIRS.TEST.
	in package REPAIRS, the next stored proc is defined

	TYPE curs IS REF CURSOR;
	procedure TEST
	(
	 pRetCursor OUT curs
	);

I use the next calls to open the connection and to call the stored
procedure, which work correctly:

	ADOConnection1->Open("test", "test");

	ADOStoredProc1->ProcedureName = "REPAIR.TEST";
	ADOStoredProc1->Prepared = true;
	ADOStoredProc1->ExecProc();

I have not configured any of the Parameters properties of TADOStoreProc,
and the ExecProc() function is called without any problems.

But when I now add an input paramater, before or after the cursor ref,
I always get the same exception:
"EOleException with message ORA-06550 : PLS-00306 Wrong number of
parameters in calling TEST".
	
	procedure TEST
	(
  	 pCounter IN number,
	 pRetCursor OUT curs
	);

I have searched for help in the FAQ papers, Borland help, ... but find
nothing explaining why this is not working.
There should be something wrong with my parameters, but trying different
possibilities did not help me further.

When I want to configure the Parameters propetry, to specify to use
a ftCursor, this is refused because the help says ftCursor can only
be used with TStoredProc instead of TADOStoredProc.

On the other hand, only using the input parameter, leaving our the ref
to the cursor, works fine !

Is there an explication why these 2 could not work together.
Could adding the correct fields in the Parameters properties do the
work?
Is a ref to a cursor returned as a parameter.
Should I use TStoredProc instead of TADOStoredProc ?

Many thanks for any help,
Olivier Berode