?
Solved

execution of plsql proc

Posted on 2011-05-03
3
Medium Priority
?
466 Views
Last Modified: 2013-12-07
Declare
  o_rc                  OUT      NUMBER;
  o_reason           OUT      VARCHAR2(200);
Begin
DBMS_OUTPUT.ENABLE(100000);
CQ_PDR_SEND_EMAIL_NOTIFY.pdr_send_email_pr ('pdr_program', 1699380, 'DEAL_EXPIRE_5_DAYS', 1, NULL, NULL, NULL, NULL, NULL, NULL)

Dbms_output.put_line(o_rc ||o_reason);
End ;

the above statement when i run its showing the error
Execution (4: 34): ORA-06550: line 2, column 34:
PLS-00103: Encountered the symbol "NUMBER" when expecting one of the following:

   := . ( @ % ; not null range default character
0
Comment
Question by:thota198
  • 3
3 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 35515387
try this...
DECLARE
    o_rc       NUMBER;
    o_reason   VARCHAR2(200);
BEGIN
    DBMS_OUTPUT.enable(100000);
    cq_pdr_send_email_notify.pdr_send_email_pr('pdr_program',
                                               1699380,
                                               'DEAL_EXPIRE_5_DAYS',
                                               1,
                                               NULL,
                                               NULL,
                                               NULL,
                                               NULL,
                                               NULL,
                                               NULL
                                              );

    DBMS_OUTPUT.put_line(o_rc || o_reason);
END;

Open in new window

0
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 35515391
I removed the  OUT  in your declarations  (IN and OUT only apply to parameters)

and put a semicolon ";"  after the procedure call
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 35515592
since you have opened a new question using the fixes suggested above

do you need any more help here?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question