Re: Can't even get 'Hello World' to work in Oracle!

Hi

In article <Xns9AF0BEC5CBEF8anacedenthotmailcom_at_69.16.185.247>, "Ana C. Dent" <anacedent_at_hotmail.com> wrote:
>Kramer314 <johnlkramer_at_gmail.com> wrote in news:70448005-569c-41bb-aab9-
>dde6c9118d07_at_p10g2000prf.googlegroups.com:
>
>> Maybe I'm a moron. I don't know, but I can't even get Hello World to
>> work in Oracle. I have the following SQL file:
>>
>>
>> BEGIN
>> DBMS_OUTPUT.put_line
>> ('Hello World');
>> END;
>>
>below is untested but can't hurt
>
>BEGIN
> DBMS_OUTPUT.ENABLE(32000);
> DBMS_OUTPUT.put_line
> ('Hello World');
>END;
it also needs to be prefaced with:

set serveroutput on

Eg

SQL> set serveroutput on
SQL> BEGIN

  2         DBMS_OUTPUT.ENABLE(32000);
  3          DBMS_OUTPUT.put_line
  4                ('Hello World');

PL/SQL procedure successfully completed.

See Ya
(when bandwidth gets better ;-)

Chris Eastwood
Photographer, Programmer Motorcyclist and dingbat blog: http://cjeastwd.blogspot.com/

please remove undies for reply Received on Tue Aug 05 2008 - 02:22:50 CDT