Home » SQL & PL/SQL » SQL & PL/SQL » Any easy way to run PL/SQL?
Any easy way to run PL/SQL? [message #36337] Fri, 16 November 2001 15:43 Go to next message
Stupid
Messages: 8
Registered: November 2001
Junior Member
Probably a stupid question, but: Any program I can compile PL/SQL code with easily? I have problems with installing Oracle 8i, and I only want to test out PL/SQL a little...

----------------------------------------------------------------------
Re: Any easy way to run PL/SQL? [message #36339 is a reply to message #36337] Sun, 18 November 2001 06:36 Go to previous messageGo to next message
Phenoracle
Messages: 35
Registered: March 2001
Member
Hi,
As far as I know PL/SQl is only complable, with Oracle tools.
What problem are you getting installing 8i.

Rae



----------------------------------------------------------------------
Re: Any easy way to run PL/SQL? [message #36351 is a reply to message #36337] Mon, 19 November 2001 10:54 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
the pl/sql engine is part of the database 
(I'm not speaking about client side pl/sql in 
forms etc). As such, you need to have access to
 a database then you can compile.
 From sqlplus:
 SQL> CREATE TABLE T ( 
   2    COL1  VARCHAR2 (80));
 Table created.
 SQL> create or replace procedure p  is
   2  begin
   3  insert into t values('hello world '||sysdate);
   4  end p;
   5  /
 Procedure created.
 SQL> show errors
 No errors.
 SQL> 


----------------------------------------------------------------------
Previous Topic: OnConnect/OnDisconnect events?
Next Topic: multiple inline view in pl/sql?
Goto Forum:
  


Current Time: Thu Mar 28 05:33:35 CDT 2024