PL/SQL compiler

[TheStandard]

What can I use to write a hello world program (or preferably something a little more advanced) with PL/SQL?

Since I'm using Windows XP Home Edition, none of the software on Oracle's website works when I install it on my system.

 

[sem]

How about Personal Edition? BTW development tools work pretty well on XP, is installing database locally a must?

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

Stan",

Is this what you mean by a "Hello World" program?:

set serveroutput on format wrap
begin
    dbms_output.put_line('Hello World.');
end;
/
Hello World.

We can certainly get more advanced after we confirm that PL/SQL is working properly for you. Let us know.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 16:02 (18Feb05) UTC (aka "GMT" and "Zulu"),
@ 09:02 (18Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[TheStandard]

For Oracle's Personal Edition, should I install Oracle 9i Datbase, Management and Integration, or Client?

How well is this guaranteed to work on the Home Edition of XP as opposed to the Professional Edition?

 

[SantaMufasa]

Stan,

Oracle does not certify on Windows XP Home Edition. Here is a copy and paste of a statement from Oracle's "Certify and Availability" webpage:

"32-bit Windows XP has 2 editions/versions, Professional and Home. Oracle will ONLY certify on Professional."

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 03:27 (19Feb05) UTC (aka "GMT" and "Zulu"),
@ 20:27 (18Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[TheStandard]

Are you saying it's useless to try to learn PL/SQL with Windows XP Home Edition?

 

[TheStandard]

Well, I just upgraded to Windows XP Professional Edition.

So I guess now I should restate my previous question:

For Oracle's Personal Edition, should I install Oracle 9i Datbase, Management and Integration, or Client?

 

[SantaMufasa]

If you will be always connecting to a remote database, then all you need is the Client. If you do not have a remote database to which to connect, then you will want to install the server with a database.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 17:33 (19Feb05) UTC (aka "GMT" and "Zulu"),
@ 10:33 (19Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[TheStandard]

Thanks for the help. I got it to work.

I have one more question, though...

Why did you type...

set serveroutput on format wrap

...instead of...

set serveroutput on

...?

 

[SantaMufasa]

If you just enter "set serveroutput on", Oracle suppresses leading blank spaces from any line of dbms_output.put_line output. Using "set serveroutput on format wrap" allows leading blank spaces.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 03:59 (20Feb05) UTC (aka "GMT" and "Zulu"),
@ 20:59 (19Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.