problem when executing Oracle stored proc : ORA-01036 . Urgent Please

From: JMG (jmgranier_at_agilog.fr)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 17:35:13 +0200

Hello,

Delphi 5
Oralce 8 or 9.
use of TADOStoredProc

I get ORA-01036 illegal variable name/number when I open a stored proc.

I don't know why. In PL Sql Developper, the test is OK.

Here is my delphi code :

  with ADOStoredProc1 do
  begin
    Close;
    ProcedureName := 'P_CLASSCAT_LG';
    Parameters[0].Value := 'F';
    Open;
  end;

Here is the stored procedure :

CREATE PROCEDURE P_CLASSCAT_LG(
LANGUE IN VARCHAR2,
RC1 OUT globalPkg.RCT1
)
AS
BEGIN
     OPEN RC1 FOR
     SELECT DISTINCT C.CODE_CLA, C.CODE_TYPO, C1.DES_CLA, C.TYPE_CLA,
C.TYPE_MAT, LG_ABR
     FROM CLASSCAT C, CLASSCAT_LG C1
     WHERE
         (C1.CODE_CLA (+) = C.CODE_CLA)
     AND
         (C1.LG_ABR (+) = P_CLASSCAT_LG.LANGUE);

END P_CLASSCAT_LG;

Can someone help me ?

regards

Jean-Michel

Relevant Pages

  • Re: Update statement performance decreases in stored proc
    ... Have you had a look at the execution plan of the stored procedure? ... Here are the important parts of the stored proc: ... I found that this was casued by the UPDATE statement at the end ...
    (microsoft.public.sqlserver.programming)
  • Re: RETURN_VALUES ??? done... What have I gained?
    ... b (aka whipper-snapper) ... > similar questions via stored proc and can set up a function to do the work ... >> tAdoDataSet is really easy to use. ... >> dataset even though you are pointing to a stored procedure. ...
    (borland.public.delphi.database.ado)
  • Re: RETURN_VALUES ??? done... What have I gained?
    ... Who is Doctor Codd? ... similar questions via stored proc and can set up a function to do the work ... > tAdoDataSet is really easy to use. ... > dataset even though you are pointing to a stored procedure. ...
    (borland.public.delphi.database.ado)
  • TableAdapter, INNER JOINs, stored procs, and problems with Update
    ... I have a stored procedure that uses JOINs to return columns from multiple ... I also have another stored proc that that takes a series of params ... @ac2 int, ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Repost - Sql Server 2005 - SSIS - nbr of input cols < nbr stored proc parameters (MS
    ... proc parameters ... | file and insert them into an existing table using an 'insert stored proc' ... | inputs for all the stored proc parameters but the flat file only contains ... | and a stored procedure that inserts records into our lkp_county table ...
    (microsoft.public.sqlserver.dts)