RE: How to use SYS.DBMS_OUTPUT.PUT_LINE in ProC?

First off you need SQLCHECK=SEMANTICS and the login that you pass must have execute priviledges.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: gyurika [mailto:gyurika_at_prolan.hu] Sent: Monday, July 21, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L Subject: How to use SYS.DBMS_OUTPUT.PUT_LINE in ProC?

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
----------------------------------------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: gyurika
  INET: gyurika_at_prolan.hu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).