Create Procedure Oracle Errors

mbewers1

Hello

I have 2 errors on the following procedure and none of the posts on Bytes or websites I have researched (e.g.: This One seem to be able to help me resolve them.

Error (1): SQL Statement ignored
Error (2): ORA-00907: missing right parenthesis

The errors are marked (1) and (2) where they appear in the code.

Expand|Select|Wrap|Line Numbers

 create or replace

PROCEDURE SP_SELECTCATS (

  "SearchItem" IN VARCHAR2,

  "SearchCriteria" IN VARCHAR2,

  "RESULTS" OUT SYS_REFCURSOR) AS

BEGIN

  OPEN RESULTS FOR

  SELECT corporateactionnumber, (1)

  sedolnumber,

  isincode,

  stockname,

  corporateactiontype,

  to_date(a.receiveddate, 'dd/mm/yyyy')

FROM 

 tblcorporateactions

WHERE "SearchItem" = "SearchCriteria"

 (

    ("SearchItem" = 'CorporateActionNumber' AND a.corporateactionnumber = "SearchCriteria") (2)

 );
 
END SP_SELECTCATS;

It may be something simple, but I don't understand what is causing the errors.

Many thanks
Matt

rski

I'm just beggining int oracle but what do you thik does it mean

Expand|Select|Wrap|Line Numbers

 
 WHERE "SearchItem" = "SearchCriteria"

  (

     ("SearchItem" = 'CorporateActionNumber' AND a.corporateactionnumber = "SearchCriteria")

  );

amitpatel66

Try this:

I have changed the code in oracle syntax. I would suggest you to let us know your exact requirement so that we can help better:

Expand|Select|Wrap|Line Numbers

 
create or replace 

PROCEDURE SP_SELECTCATS ( 

  "SearchItem" IN VARCHAR2, 

  "SearchCriteria" IN VARCHAR2, 

  "RESULTS" OUT SYS_REFCURSOR) AS 

BEGIN 

IF ("SearchItem" = "SearchCriteria") THEN

  OPEN RESULTS FOR 

  SELECT corporateactionnumber,

  sedolnumber, 

  isincode, 

  stockname, 

  corporateactiontype, 

  to_date(a.receiveddate, 'dd/mm/yyyy') 

FROM  

 tblcorporateactions a

WHERE a.corporateactionnumber = "SearchItem"

AND a.corporateactionnumber = "SearchCriteria";   

END IF;

END SP_SELECTCATS;

Create Procedure Oracle Errors

re: Create Procedure Oracle Errors

re: Create Procedure Oracle Errors

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about