Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to use SYS.DBMS_OUTPUT.PUT_LINE in ProC?

How to use SYS.DBMS_OUTPUT.PUT_LINE in ProC?

From: gyurika <gyurika_at_prolan.hu>
Date: Mon, 21 Jul 2003 16:05:09 -0100
Message-Id: <25977.338674@fatcity.com>


Hi,

I have a problem with using oracle built in stored procedures in embadded C. It is impossible to compile my program by ProC. It says:

      sys.dbms_alert.remove( 'prolan_alert' );
..........1

PLS-S-00201, identifier 'SYS.DBMS_ALERT' must be declared

      sys.dbms_alert.remove( 'prolan_alert' );
..........1

PLS-S-00000, Statement ignored
Semantic error at line 118, column 5, file reg_alert.pc:

    BEGIN
....1
PCC-S-02346, PL/SQL found semantic errors

      SYS.DBMS_OUTPUT.PUT_LINE('Value of payroll: ');
..........1

PLS-S-00201, identifier 'SYS.DBMS_OUTPUT' must be declared

      SYS.DBMS_OUTPUT.PUT_LINE('Value of payroll: ');
..........1

PLS-S-00000, Statement ignored

I can use these functions in sqlplus, but ProC produces this error message. Should I declare packages I want to use? How can I do it?

Thanks a lot,
Gyuri

-- 

----------------------------------------------------------------------
Lendvary Gyorgy                                           Prolan Rt.
tel: +36 26 543-136                                  Szentendrei ut 1-3.
fax: +36  26 543-101                               H-2011 Budakalasz
email: lendvary-g_at_prolan.hu                           Hungary
----------------------------------------------------------------------
Received on Mon Jul 21 2003 - 12:05:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US